How to avoid dead rows in tables.

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема How to avoid dead rows in tables.
Дата
Msg-id CAEHH7R5jtoRV=+H2yL1FWv6gE5iS-zCda1YkYGMjMk7d99X_KQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to avoid dead rows in tables.  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general

Hi All,


auto vacuum is enabled in our database. But few of the tables contains the dead tuples more than 5,000 records. Number of dead rows are keep on increasing day by day if we didn’t perform the vacuum full. Monthly once we are performing vacuum full by stopping application server process. Later we are restarting the application server process.

 

How to avoid accumulating the dead tuples for those tables. Is there any other approach to remove the dead tuple’s without vacuum full/down time.

 

Note:- We are using the postgres version 9.2


--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: Who and How is responsible for released installations packagesand 3rd party packs? (e.g. onhttps://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: How to avoid dead rows in tables.