On Thu, Jan 9, 2014 at 2:03 PM, Jeff Amiel becauseimj...@yahoo.com 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
On Thursday, January 9, 2014 4:03 PM, Jeff Amiel becauseimj...@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 -
On Thu, Jan 9, 2014 at 2:03 PM, Jeff Amiel becauseimj...@yahoo.com 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