Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_autovacuum not having enough suction ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: pg_autovacuum not having enough suction ?
Date
Msg-id 4933.1111692779@sss.pgh.pa.us
Whole thread Raw
In response to pg_autovacuum not having enough suction ?  ("Otto Blomqvist" <o.blomqvist@secomintl.com>)
List pgsql-performance
Tree view 
"Otto Blomqvist" <o.blomqvist@secomintl.com> writes:
> Over 100'000 Index Rows removed, 300'000 unused item pointers ? How could
> autovacuum let this happen ?

What PG version is this?

(The earlier autovacuum releases had some bugs with large tables, thus
the question...)

            regards, tom lane

pgsql-performance by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: Preventing query from hogging server
Next
From: Tom Lane
Date:
Subject: Re: Preventing query from hogging server