Re: Performance considerations for very heavy INSERT - Mailing list pgsql-performance

From evgeny gridasov
Subject Re: Performance considerations for very heavy INSERT
Date
Msg-id 20050913192638.3093c63c.eugrid@fpm.kubsu.ru
Whole thread Raw
In response to Performance considerations for very heavy INSERT traffic  (Brandon Black <blblack@gmail.com>)
List pgsql-performance
On Mon, 12 Sep 2005 16:04:06 -0500
Brandon Black <blblack@gmail.com> wrote:

I've seen serveral tests PostgreSQL on JFS file system, it runs faster than using ext3.
Our production server works using JFS and RAID10,
we have 250K+ transactions per day and everything is OK.
Try switching to separate RAID10 arrays and use one for xlog, and others for data.
If you are using indexes, try to put them on separate RAID10 array.

> Test hardware right now is a dual Opteron with 4G of ram, which we've barely
> gotten 1,000 clients running against. Current disk hardware in testing is
> whatever we could scrape together (4x 3-ware PCI hardware RAID controllers,
> with 8 SATA drives in a RAID10 array off of each - aggregated up in a 4-way
> stripe with linux md driver and then formatted as ext3 with an appropriate
> stride parameter and data=writeback). Production will hopefully be a 4-8-way
> Opteron, 16 or more G of RAM, and a fiberchannel hardware raid array or two
> (~ 1TB available RAID10 storage) with 15krpm disks and battery-backed write
> cache.

--
Evgeny Gridasov
Software Developer
I-Free, Russia

pgsql-performance by date:

Previous
From: Brandon Black
Date:
Subject: Re: Performance considerations for very heavy INSERT traffic
Next
From: Ian Westmacott
Date:
Subject: Re: Performance considerations for very heavy INSERT