Re: Autovacuum in the backend

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-16 15:11:20
Message-ID: 20050616151120.GC16044@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Jun 16, 2005 at 04:20:34PM +1000, Gavin Sherry wrote:

> 2) By no fault of its own, autovacuum's level of granularity is the table
> level. For people dealing with non-trivial amounts of data (and we're not
> talking gigabytes or terabytes here), this is a serious drawback. Vacuum
> at peak times can cause very intense IO bursts -- even with the
> enhancements in 8.0. I don't think the solution to the problem is to give
> users the impression that it is solved and then vacuum their tables during
> peak periods. I cannot stress this enough.

People running systems with petabyte-sized tables can disable autovacuum
for those tables, and leave it running for the rest. Then they can
schedule whatever maintenance they see fit on their gigantic tables.
Trying to run a database with more than a dozen gigabytes of data
without expert advice (or at least reading the manual) would be
extremely stupid anyway.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message eblues 2005-06-16 15:14:16 Help: chinese character set support (EUC_TW to/from BIG5 conversion)
Previous Message Alvaro Herrera 2005-06-16 15:08:33 Re: Autovacuum in the backend

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-06-16 15:25:23 Re: [PATCHES] Escape handling in strings
Previous Message Alvaro Herrera 2005-06-16 15:08:33 Re: Autovacuum in the backend