On Thu, Jan 9, 2014 at 2:03 PM, Jeff Amiel wrote:
> I have a maintenance window coming up and using pg_upgrade to upgrade from
> 9.2.X to 9.3.X.
> As part of the window, I’d like to ‘cluster’ each table by its primary
> key. After doing so, I see amazing performance improvements (probably
> most
On Thu, Jan 9, 2014 at 2:03 PM, Jeff Amiel wrote:
> I have a maintenance window coming up and using pg_upgrade to upgrade from
> 9.2.X to 9.3.X.
> As part of the window, I’d like to ‘cluster’ each table by its primary key.
> After doing so, I see amazing performance improvements (probably mostl
On Thursday, January 9, 2014 4:03 PM, Jeff Amiel
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
I have a maintenance window coming up and using pg_upgrade to upgrade from
9.2.X to 9.3.X.
As part of the window, I’d like to ‘cluster’ each table by its primary key.
After doing so, I see amazing performance improvements (probably mostly because
of index bloat - but possibly due to table fragm
