From: Josh Berkus <josh@agliodbs.com>
To: Alex Stapleton <alexs@advfn.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum suggestions for 500,000,000+ row tables?
Date: Tue, 21 Jun 2005 10:13:40 -0700
Message-ID: <200506211013.40993.josh@agliodbs.com> (raw)
In-Reply-To: <7E161634-29A0-4DBC-A303-3675D705A965@advfn.com>
References: <BE7E1F60-FA3A-4843-988E-AC2CC1FA22E5@advfn.com>
<200506201046.42062.josh@agliodbs.com>
<7E161634-29A0-4DBC-A303-3675D705A965@advfn.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, alexs@advfn.com
Subject: Re: autovacuum suggestions for 500,000,000+ row tables?
In-Reply-To: <200506211013.40993.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox