Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-06 Thread Bruce Momjian
Andy Lester wrote: > > On Sep 6, 2011, at 9:04 AM, Bruce Momjian wrote: > > > Well, if you TRUNCATE I don't think it updates the statistics either. I > > think we assume the autovacuum system will analyse the new table soon. > > > When I brought this up in IRC, I recall that that sentiment was

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-06 Thread Andy Lester
On Sep 6, 2011, at 9:04 AM, Bruce Momjian wrote: > Well, if you TRUNCATE I don't think it updates the statistics either. I > think we assume the autovacuum system will analyse the new table soon. When I brought this up in IRC, I recall that that sentiment was expressed, along with the standar

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-06 Thread Bruce Momjian
Andy Lester wrote: > > On Sep 5, 2011, at 3:19 PM, Bruce Momjian wrote: > > > > > This is an interesting bug report from March that got no replies. In my > > testing, not only does CLUSTER not update the n_dead_tup statistics, but > > neither does VACUUM FULL, which internally uses the CLUSTER

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-05 Thread Andy Lester
On Sep 5, 2011, at 3:19 PM, Bruce Momjian wrote: > > This is an interesting bug report from March that got no replies. In my > testing, not only does CLUSTER not update the n_dead_tup statistics, but > neither does VACUUM FULL, which internally uses the CLUSTER code > (cluster_rel()). Is this

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-05 Thread Bruce Momjian
This is an interesting bug report from March that got no replies. In my testing, not only does CLUSTER not update the n_dead_tup statistics, but neither does VACUUM FULL, which internally uses the CLUSTER code (cluster_rel()). Is this a bug? -

[BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-03-15 Thread Andy Lester
The following bug has been logged online: Bug reference: 5932 Logged by: Andy Lester Email address: a...@petdance.com PostgreSQL version: 9.0 Operating system: Linux Description:CLUSTER doesn't update n_dead_tup Details: The CLUSTER command does not update the resul