Re: Looking for settings/configuration for FASTEST reindex on idle system. - Mailing list pgsql-general

From Jeff Amiel
Subject Re: Looking for settings/configuration for FASTEST reindex on idle system.
Date
Msg-id 1389309745.96307.YahooMailNeo@web122905.mail.ne1.yahoo.com
Whole thread Raw
In response to Looking for settings/configuration for FASTEST reindex on idle system.  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general



On Thursday, January 9, 2014 4:03 PM, Jeff Amiel <becauseimjeff@yahoo.com> wrote:
I am familiar with pg_reorg and it’s sibling pg_repack - but they call the base postgresql reindex functions underneath
-and I have learned by using ‘verbose’ that the actual clustering of the table is quick - it’s the reindexing that is
slow(It’s doing each reindex sequentially instead of concurently) 


I'm second guessing this - I'm not sure I REALLY know how long the table cluster takes versus the index -



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: returning json object with subset of keys
Next
From: Michael Paquier
Date:
Subject: Re: wal archive peak during pg_dump