Skip site navigation (1) Skip section navigation (2)

Re: pg_autovacuum not having enough suction ?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Otto Blomqvist <o(dot)blomqvist(at)secomintl(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_autovacuum not having enough suction ?
Date: 2005-03-24 23:40:44
Message-ID: 42434FFC.10105@zeut.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
The version that shipped with 8.0 should be fine.  The only version that 
had the problem Tom referred to are in the early 7.4.x releases. 

Did you get my other message about information from the stats system 
(I'm not sure why my other post has yet to show up on the performance 
list).

Matthew


Otto Blomqvist wrote:

>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
>>
>>    
>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>  
>

In response to

pgsql-performance by date

Next:From: Matthew T. O'ConnorDate: 2005-03-24 23:58:00
Subject: Re: pg_autovacuum not having enough suction ?
Previous:From: Otto BlomqvistDate: 2005-03-24 23:04:24
Subject: Re: pg_autovacuum not having enough suction ?

pgsql-hackers by date

Next:From: Matthew T. O'ConnorDate: 2005-03-24 23:58:00
Subject: Re: pg_autovacuum not having enough suction ?
Previous:From: Palle GirgensohnDate: 2005-03-24 23:40:04
Subject: Patch for collation using ICU

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group