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)
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 |
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 |