[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

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

2014-07-03 Thread Nick Cabatoff
at 5:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: Nick Cabatoff nick.cabat...@gmail.com 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 monitor the counts in pg_stat_all_tables

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 michael.paqu...@gmail.com wrote: On Fri, Jul 4, 2014 at 7:41 AM, Nick Cabatoff