From: Brandon Black <blblack@gmail.com>
To: petrilli@gmail.com
To: pgsql-performance@postgresql.org
Subject: Re: Performance considerations for very heavy INSERT traffic
Date: Tue, 13 Sep 2005 10:30:59 -0500
Message-ID: <84621a6050913083079ef0559@mail.gmail.com> (raw)
In-Reply-To: <59d991c40509122039773cac17@mail.gmail.com>
References: <84621a6050912140464c380c3@mail.gmail.com>
<59d991c40509122039773cac17@mail.gmail.com>
On 9/12/05, Christopher Petrilli <petrilli@gmail.com> wrote:
>
>
> 3) Use 8.1 and strongly look at Bizgres. The data partitioning is
> critical.
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).
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: blblack@gmail.com, petrilli@gmail.com
Subject: Re: Performance considerations for very heavy INSERT traffic
In-Reply-To: <84621a6050913083079ef0559@mail.gmail.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