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

Re: [HACKERS] Resurrecting per-page cleaner for btree

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>,postgres hackers <pgsql-hackers(at)postgresql(dot)org>,ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>,pgsql-patches(at)postgresql(dot)org, teramoto(dot)junji(at)lab(dot)ntt(dot)co(dot)jp
Subject: Re: [HACKERS] Resurrecting per-page cleaner for btree
Date: 2006-07-26 21:02:38
Message-ID: 20060726210238.GD32377@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Wed, Jul 26, 2006 at 12:47:57PM -0400, Greg Stark wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> 
> > So far, the case hasn't been made for retail vacuum even ignoring the
> > not-so-immutable-function risk.
> 
> Well the desire for it comes from a very well established need for dealing
> with extremely large tales with relatively small hot spots. The basic problem
> being that currently the cost of vacuum is proportional to the size of the
> table rather than the amount of dead space. There's no link between those
> variables (at least in one direction) and any time they're far out of whack it
> means excruciating pain for the DBA.

I thought the suggested solution for that was the dead space map. That
way vacuum can ignore parts of the table that havn't changed...

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-07-26 21:03:23
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level
Previous:From: Hannu KrosingDate: 2006-07-26 21:01:15
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to

pgsql-patches by date

Next:From: Tom LaneDate: 2006-07-26 21:03:23
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level
Previous:From: Hannu KrosingDate: 2006-07-26 21:01:15
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to

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