From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PostgreSQL HA questions |
Date: | 2006-09-27 20:26:12 |
Message-ID: | 60lko5hx97.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
ajs(at)crankycanuck(dot)ca (Andrew Sullivan) writes:
> It isn't clear to me why you think you need to do this: vacuum
> doesn't block your queries anyway. If the idea is that you have a
> table that you'd rather TRUNCATE and not have to vacuum, however,
> that makes sense. There are several strategies for this. My
> colleague Chris Browne seems really to like this kind of
> functionality, and has discussed it more than once on the -general
> list. I think you can find his detailed outlines of how to do this
> sort of thing by searching for "rotor tables".
I'd suggest looking at the section in the documentation on
Partitioning; the mechanisms there look like the Better Way these
days.
<http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html>
There were some things that were Pretty Neat about rotor tables; as of
8.1, the benefits gotten from constraint propagation with partitioning
seems to make that a much more attractive way to go about things.
There are always going to be some caveats for whatever mechanism is
used to partition data; it looks like 8.1's constraint propagation
pushes preference towards using inheritance...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/linux.html
"It is easier to optimize correct code, than correct optimized code"
-- Yves Deville
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2006-09-27 20:27:25 | Re: How to Examine a view |
Previous Message | Gene Wirchenko | 2006-09-27 20:25:27 | Re: cyclical redundancy checksum algorithm(s)? |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-09-27 20:44:36 | Re: [GENERAL] Restart after power outage: createdb |
Previous Message | Andrew Dunstan | 2006-09-27 20:25:57 | Re: [Pgbuildfarm-members] Buildfarm alarms |