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: Mon, 12 Sep 2005 22:53:55 -0500
Message-ID: <84621a605091220533aa8fa12@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:
>
>
> 2) Tune ext3. The default configuration wrecks high-write situations.
> Look into data=writeback for mounting, turning off atime (I hope
> you've done this already) updates, and also modifying the scheduler to
> the elevator model. This is poorly documented in Linux (like just
> about everything), but it's crtical.
I'm using noatime and data=writeback already. I changed my scheduler from
the default anticipatory to deadline and saw an improvement, but I haven't
yet delved into playing with specific elevator tunable values per-device.
3) Use 8.1 and strongly look at Bizgres. The data partitioning is critical.
I've just started down the path of getting 8.1 running with a larger block
size, and tommorow I'm going to look at Bizgres's partitioning as opposed to
some manual schemes. Will the current Bizgres have a lot of the performance
enhancements of 8.1 already (or will 8.1 or 8.2 eventually get Bizgres's
partitioning?)?
-- Brandon
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: <84621a605091220533aa8fa12@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