Re: Looking for settings/configuration for FASTEST reindex on idle system.

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Looking for settings/configuration for FASTEST reindex on idle system.
Date: 2014-01-09 23:22:25
Message-ID: 1389309745.96307.YahooMailNeo@web122905.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, January 9, 2014 4:03 PM, Jeff Amiel <becauseimjeff(at)yahoo(dot)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 -

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-01-10 03:12:06 Re: wal archive peak during pg_dump
Previous Message Merlin Moncure 2014-01-09 23:09:50 Re: returning json object with subset of keys