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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
Date: 2018-07-19 15:06:28
Message-ID: 575c70f5-829c-cdb0-4d89-15243c18c703@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-07-19 15:39:45 Re: cache lookup failed for attribute 1 of relation XXXXXX
Previous Message Tom Lane 2018-07-19 14:41:19 Re: cache lookup failed for attribute 1 of relation XXXXXX