[GENERAL] trying to use CLUSTER

2013-02-12 Thread Sahagian, David
Version=9.1.7 INFO: clustering "my_cool_table" using sequential scan and sort INFO: "my_cool_table": found 1 removable, 1699139 nonremovable row versions in 49762 pages Detail: 1689396 dead row versions cannot be removed yet. CPU 9.80s/4.98u sec elapsed 175.92 sec. INFO: clustering "my_cool_tab

[GENERAL] trying to use CLUSTER

2013-02-13 Thread Jeff Janes
On Tuesday, February 12, 2013, Sahagian, David wrote: > Version=9.1.7 > > ** ** > > INFO: clustering "my_cool_table" using sequential scan and sort > > INFO: "my_cool_table": found 1 removable, 1699139 nonremovable row > versions in 49762 pages > > Detail: 1689396 dead row versions ca

Re: [GENERAL] trying to use CLUSTER

2013-02-13 Thread Albe Laurenz
David Sahagian wrote: > Version=9.1.7 > > INFO: clustering "my_cool_table" using sequential scan and sort > INFO: "my_cool_table": found 1 removable, 1699139 nonremovable row versions > in 49762 pages > Detail: 1689396 dead row versions cannot be removed yet. > CPU 9.80s/4.98u sec elapsed 175.92