From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
Date: Thu, 19 Jul 2018 10:06:28 -0500
Message-ID: <575c70f5-829c-cdb0-4d89-15243c18c703@gmail.com> (raw)
In-Reply-To: <CAEHH7R6H8YH4r0XDB9GqW29+QWL0jWWb-X4rhPxCySzpEZp=QA@mail.gmail.com>
References: <CAEHH7R7f9oQauDNLsOZ4BO_Yi7icP_n6SxChQj69ROsX0FuGOg@mail.gmail.com>
<6ff5e1a7-32d3-0e84-93f5-20630b2ccdca@aklaver.com>
<CAEHH7R6H8YH4r0XDB9GqW29+QWL0jWWb-X4rhPxCySzpEZp=QA@mail.gmail.com>
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
> <mailto: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.
Attachments:image.png (image/png, 419.8K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?
In-Reply-To: <575c70f5-829c-cdb0-4d89-15243c18c703@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox