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

Re: Experimental patch for inter-page delay in VACUUM

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-11-03 08:24:48
Message-ID: 1067847887.2580.1.camel@fuji.krosing.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Christopher Browne kirjutas E, 03.11.2003 kell 02:15:
> Well, actually, the case where it _would_ be troublesome would be
> where there was a combination of huge tables needing vacuuming and
> smaller ones that are _heavily_ updated (e.g. - account balances),
> where pg_autovacuum might take so long on some big tables that it
> wouldn't get to the smaller ones often enough.  

Can't one just run a _separate_ VACUUM on those smaller tables ?

------------
Hannu


In response to

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2003-11-03 09:21:36
Subject: Re: adding support for posix_fadvise()
Previous:From: Larry RosenmanDate: 2003-11-03 06:37:28
Subject: Re: Port Report: UnixWare

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