If set have the max_fsm_pages set correctly, that makes VACUUM faster and
removes the need for VACUUM FULL or REINDEX. Should be slightly more than
the total number of data pages which will be touched by updates and deletes
between vacuums.
Thanks,
Shoaib Mir
EnterpriseDB (www.enterprise
"Angva" <[EMAIL PROTECTED]> wrote:
>
> > clustering also removes the dead tuples.
>
> I have a followup question. What if the set of dead tuples is too big
> and I need to VACUUM FULL, as opposed to VACUUM. (The update size
> varies greatly from day to day.) Will the clustering effectively do a
>
Thank you very much, Alan and Martijn, for the advice!
Mark
Martijn van Oosterhout wrote:
> On Thu, Dec 07, 2006 at 02:52:11PM -0800, Alan Hodgson wrote:
> > On Thursday 07 December 2006 08:38, "Angva" <[EMAIL PROTECTED]> wrote:
> > > three commands. For instance I have a hunch that creating the
> clustering also removes the dead tuples.
I have a followup question. What if the set of dead tuples is too big
and I need to VACUUM FULL, as opposed to VACUUM. (The update size
varies greatly from day to day.) Will the clustering effectively do a
VACUUM FULL, or just a VACUUM?
Thanks again for
On Thu, Dec 07, 2006 at 02:52:11PM -0800, Alan Hodgson wrote:
> On Thursday 07 December 2006 08:38, "Angva" <[EMAIL PROTECTED]> wrote:
> > three commands. For instance I have a hunch that creating the indexes
> > first (as I do now) could slow down the clustering - perhaps the row
> > locations in
On Thursday 07 December 2006 08:38, "Angva" <[EMAIL PROTECTED]> wrote:
> three commands. For instance I have a hunch that creating the indexes
> first (as I do now) could slow down the clustering - perhaps the row
> locations in the indexes all have to be updated as the cluster command
> shifts the
Hi everyone,
Looking for a small bit of advice...
I have a script that updates several tables with large amounts of data.
Before running the updates, it drops all indexes for optimal
performance. When the updates have finished, I run the following
procedure:
recreate the indexes
cluster the tabl
