Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: 8.2 Autovacuum BUG ?
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: 8.2 Autovacuum BUG ?
- Date: Fri, 31 Aug 2007 12:11:58 -0400
- Message-id: <20070831161158.GD8046@alvh.no-ip.org> <text/plain>
Pallav Kalva wrote: > Tom Lane wrote: >> Probably represents freezing of old tuples, which is a WAL-logged >> operation as of 8.2. Is it likely that the data is 200M transactions >> old? >> > If nothing changed on these tables how can it freeze old tuples ? > Does it mean that once it reaches 200M transactions it will do the same > thing all over again ? No -- once tuples are frozen, they don't need freezing again (unless they are modified by UPDATE or DELETE). > If I am doing just SELECTS on these tables ? how can there be any > transactions ? or SELECTS considered transactions too ? Selects are transactions too. They just don't modify data. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- Follow-Ups:
- Re: 8.2 Autovacuum BUG ?
- From: Mikko Partio
- Re: 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- Re: 8.2 Autovacuum BUG ?
- References:
- 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- Re: 8.2 Autovacuum BUG ?
- From: Tom Lane
- Re: 8.2 Autovacuum BUG ?
- From: Pallav Kalva
- 8.2 Autovacuum BUG ?
- Prev by Date: Re: 8.2 Autovacuum BUG ?
- Next by Date: Re: 8.2 Autovacuum BUG ?
- Previous by thread: Re: 8.2 Autovacuum BUG ?
- Next by thread: Re: 8.2 Autovacuum BUG ?
- Indexes: