Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?

Поиск

Список

Период

Сортировка

От	Ron
Тема	Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
Дата	19 июля 2018 г. 21:06:28
Msg-id	575c70f5-829c-cdb0-4d89-15243c18c703@gmail.com обсуждение исходный текст
Ответ на	Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples? (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список	pgsql-general

Дерево обсуждения

On 07/19/2018 06:00 AM, Raghavendra Rao J S V wrote:

Please find my inline comments.

On 18 July 2018 at 18:48, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 07/18/2018 02:13 AM, Raghavendra Rao J S V wrote:
We have thousands of tables. But out of those tables, around 20 to 40 tables are always busy due to that those tables are bloating.

Define bloating?

Table contains more dead tuples more than 5000 records. Sometimes few tables may contains 50million records and size also in GB's. Refer below screen print.