Re: Enhancement request

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Enhancement request
Date: 2007-12-03 07:26:17
Message-ID: 20071203072617.GF18421@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Nov 30, 2007 at 02:00:05PM -0800, Joshua D. Drake wrote:
> Yes autovacuum is great for general low use scenarios. Throw it at a
> database doing hundreds of thousands (or even millions) of transactions
> an hour that has relations that in the multiple hundred gig range and
> autovacuum is useless for a good portion of that database.

This isn't a good argument for adding new knobs, though. It's an argument
for using the limited resources to make autovacuum better.

Compare with the never-ending arguments for index hints.

A

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tommy Cheng 2007-12-03 10:21:09 How to identify the current WAL segment file
Previous Message Usama Dar 2007-12-02 20:51:23 Re: Enhancement request