From: Eoin O'Hehir <eoin.ohehir@clavistechnology.com>
To: CAEyp7J8DDnCv2cFWNExq+=8f5QH0ttY2JGBbpBOgBRRMVCn_GA@mail.gmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Does VACUUM FULL need ANALYZE ?
Date: Mon, 29 Jun 2015 08:46:36 +0100
Message-ID: <5590F7DC.4050902@clavistechnology.com> (raw)
In-Reply-To: <CAEyp7J8DDnCv2cFWNExq+=8f5QH0ttY2JGBbpBOgBRRMVCn_GA@mail.gmail.com>
References: <CAMgPRZrB0aj=ipzroc95xMLticzJfmxQMR56vdvOV-T8Xpk=tg@mail.gmail.com>
<CAEyp7J8DDnCv2cFWNExq+=8f5QH0ttY2JGBbpBOgBRRMVCn_GA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Thanks Venkata.
On 22/06/15 01:30, Venkata Balaji N wrote:
>
> On Sun, Jun 21, 2015 at 6:02 AM, Eoin O'Hehir
> <eoin.ohehir@clavisinsight.com <mailto:eoin.ohehir@clavisinsight.com>>
> wrote:
>
>
> Eoin O'Hehir <eoin.ohehir@clavisinsight.com
> <mailto:eoin.ohehir@clavisinsight.com>>
>
> 8:59 PM (0 minutes ago)
> to pgsql-admin-ow.
>
> Hi,
>
> I'd be grateful for some insight into the VACUUM functionality in
> 9.3. I read through the documentation and searched around a bit
> but could not find a definitive answer to this.
>
> I'm setting up a weekly DB maintenance job for a 9.3 server.
>
> Part of this will be a VACUUM FULL.
>
> Is there any point in adding the ANALYZE option to the command ?
>
> According to the 9.3 documentation, "/VACUUM FULL rewrites the
> entire contents of the table into a new disk file with no extra
> space, allowing unused space to be returned to the operating
> system./". If the table is completely recreated then do I need to
> specifically ask for ANALYZE to happen or are the statistics
> updated automatically as the rows are written to the new version
> of the table ?
>
>
> VACUUM FULL will only remove the bloats and releases the bloated space
> to the disk. ANALYZE updates the statistics which will make
> significant difference in the query's cost calculation.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
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-admin@postgresql.org
Cc: eoin.ohehir@clavistechnology.com, CAEyp7J8DDnCv2cFWNExq+=8f5QH0ttY2JGBbpBOgBRRMVCn_GA@mail.gmail.com
Subject: Re: Does VACUUM FULL need ANALYZE ?
In-Reply-To: <5590F7DC.4050902@clavistechnology.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