Subject: Re: Is it ok to run vacuum full verbose command for live database for
 the tables which has more dead tuples?
To: Raghavendra Rao J S V <raghavendrajsv@gmail.com>,
 pgsql-general@lists.postgresql.org
References: 
 <CAEHH7R7f9oQauDNLsOZ4BO_Yi7icP_n6SxChQj69ROsX0FuGOg@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <6ff5e1a7-32d3-0e84-93f5-20630b2ccdca@aklaver.com>
Date: Wed, 18 Jul 2018 06:18:52 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAEHH7R7f9oQauDNLsOZ4BO_Yi7icP_n6SxChQj69ROsX0FuGOg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

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?

> 
> In order to avoid this we are running a shell script which performs 
> vacuum full on the tables which has more than ten thousand dead tuples. 

Out of how many live tuples?

> While running this we are stopping all application processors and 
> running vacuum full on the tables which has more dead tuples.
> 
>  1. Is it ok to run *vacuum full verbose* command for live database for
>     the tables which has more dead tuples(greater than)?
>  2. Does it cause any *adverse *effect?

https://www.postgresql.org/docs/10/static/sql-vacuum.html

"FULL

     Selects “full” vacuum, which can reclaim more space, but takes much 
longer and exclusively locks the table. This method also requires extra 
disk space, since it writes a new copy of the table and doesn't release 
the old copy until the operation is complete. Usually this should only 
be used when a significant amount of space needs to be reclaimed from 
within the table.
"

> 
> 
> Please clarify me. Thanks in advance.
> 
> -- 
> Regards,
> Raghavendra Rao J S V
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com