Re: autovacuum suggestions for 500,000,000+ row tables?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Alex Stapleton <alexs(at)advfn(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: autovacuum suggestions for 500,000,000+ row tables?
Date: 2005-06-21 17:13:40
Message-ID: 200506211013.40993.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alex,

> Downtime is something I'd rather avoid if possible. Do you think we
> will need to run VACUUM FULL occasionally? I'd rather not lock tables
> up unless I cant avoid it. We can probably squeeze an automated
> vacuum tied to our data inserters every now and then though.

As long as your update/deletes are less than 10% of the table for all time,
you should never have to vacuum, pending XID wraparound.

> Is this an 8.0 thing? I don't have a pg_controldata from what I can
> see. Thats nice to hear though.

'fraid so, yes.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Nuzum 2005-06-21 17:57:17 Re: Do Views execute underlying query everytime ??
Previous Message PFC 2005-06-21 16:59:48 Re: Do Views execute underlying query everytime ??