| From: | "Otto Blomqvist" <o(dot)blomqvist(at)secomintl(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: pg_autovacuum not having enough suction ? |
| Date: | 2005-03-24 23:04:24 |
| Message-ID: | d1vgq6$31j2$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Sorry about that. I'm Running 8.0.0 on Linux Redhat 8.0
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:4933(dot)1111692779(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "Otto Blomqvist" <o(dot)blomqvist(at)secomintl(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Palle Girgensohn | 2005-03-24 23:40:04 | Patch for collation using ICU |
| Previous Message | Dave Page | 2005-03-24 21:28:59 | Re: Upcoming 8.0.2 Release |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2005-03-24 23:40:44 | Re: pg_autovacuum not having enough suction ? |
| Previous Message | Simon Riggs | 2005-03-24 21:55:56 | Re: CPU 0.1% IOWAIT 99% for decisonnal queries |