From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Ian Westmacott <ianw@intellivid.com>
Cc: blblack@gmail.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance considerations for very heavy INSERT
Date: Tue, 13 Sep 2005 13:22:43 -0400
Message-ID: <20050913172243.GA18107@surnet.cl> (raw)
In-Reply-To: <1126628214.11675.55.camel@spectre.intellivid.com>
References: <84621a6050912140464c380c3@mail.gmail.com>
<59d991c40509122039773cac17@mail.gmail.com>
<84621a6050913083079ef0559@mail.gmail.com>
<1126628214.11675.55.camel@spectre.intellivid.com>
On Tue, Sep 13, 2005 at 12:16:55PM -0400, Ian Westmacott wrote:
> On Tue, 2005-09-13 at 11:30, Brandon Black wrote:
> > I started looking closer at my options for partitioning (inheritance,
> > union all), and at Bizgres today. Bizgres partitioning appears to be
> > basically the same kind of inheritance partitioning one can do in
> > mainline PostgreSQL. Am I correct in thinking that the main
> > difference is that they've coded support for
> > "enable_constraint_exclusion=true" so that the query planner can be
> > more effective at taking advantage of the partitioning when you've
> > specified CHECK constraints on the child tables? I may go for 8.1
> > instead in that case, as the main win I'm looking for is that with
> > inheritance I'll be doing inserts into smaller tables instead of ones
> > that grow to unmanageable sizes (and that I can drop old child tables
> > instead of delete/vacuum).
>
> Perhaps I missed something in this thread, but don't forget
> you still need vacuum to reclaim XIDs.
Yes, but if you are going to drop the partition before 1 billion
transactions, you can skip vacuuming it completely.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Es filósofo el que disfruta con los enigmas" (G. Coli)
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: alvherre@alvh.no-ip.org, ianw@intellivid.com, blblack@gmail.com
Subject: Re: Performance considerations for very heavy INSERT
In-Reply-To: <20050913172243.GA18107@surnet.cl>
* 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