Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
On 07/19/2018 06:00 AM, Raghavendra Rao J S V wrote:
When's your maintenance window?
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.
When's your maintenance window?
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
Вложения
В списке pgsql-general по дате отправления: