Postgres Pro
Downloads
Home   >   mailing lists

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

From Otto Blomqvist
Subject Re: pg_autovacuum not having enough suction ?
Date
Msg-id d1vgq6$31j2$1@news.hub.org
Whole thread Raw
In response to pg_autovacuum not having enough suction ?  ("Otto Blomqvist" <o.blomqvist@secomintl.com>)
Responses Re: pg_autovacuum not having enough suction ?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-performance
Tree view 
Sorry about that. I'm Running 8.0.0 on Linux Redhat 8.0


"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:4933.1111692779@sss.pgh.pa.us...
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum not having enough suction ?