Re: [GENERAL] Why does autovacuum clean fewer rows than I expect?

2014-07-03 Thread Nick Cabatoff
We've been running 9.2 on our later branches for a while now. We're overdue to bump the older branches to a later 8.4 though, you're right. Thanks for the reminder. On Thu, Jul 3, 2014 at 7:46 PM, Michael Paquier wrote: > On Fri, Jul 4, 2014 at 7:41 AM, Nick Cabatoff

Re: [GENERAL] Why does autovacuum clean fewer rows than I expect?

2014-07-03 Thread Nick Cabatoff
hat turns up. On Thu, Jul 3, 2014 at 5:35 PM, Tom Lane wrote: > Nick Cabatoff writes: > > I'm having trouble making sense of the these two autovacuum log entries. > > I'm running PostgreSQL 8.4. > > 8.4.what? > > It'd probably be a good idea to monito

[GENERAL] Why does autovacuum clean fewer rows than I expect?

2014-07-03 Thread Nick Cabatoff
Hi, I'm having trouble making sense of the these two autovacuum log entries. I'm running PostgreSQL 8.4. [2014-05-22 04:56:43.486 EST] {537cf2c6.30f9} LOG: automatic vacuum of table "postgres.globaldicom.requests": index scans: 1 pages: 0 removed, 163600 remain tuples: 5916 rem