From: Francisco Reyes <lists@stringsutils.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Chris <dmagick@gmail.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Inserts optimization?
Date: Thu, 13 Apr 2006 14:59:23 -0400
Message-ID: <cone.1144954763.735087.95544.5001@35st-server.simplicato.com> (raw)
References: <cone.1144888738.434948.92126.5001@35st-server.simplicato.com>
<443DA715.4060606@gmail.com>
<9549.1144903344@sss.pgh.pa.us>
Tom Lane writes:
> Or at least try to do multiple inserts per transaction.
Will see if the program has an option like that.
> Also, increasing checkpoint_segments and possibly wal_buffers helps a
Will try those.
>Try to get the WAL onto a separate disk
>spindle if you can. (These things don't matter for SELECTs, but they
>do matter for writes.)
This particular server is pretty much what I inherited for now for this
project.and its Raid 5. There is a new server I am setting up
soon... 8 disks which we are planning to setup
6 disks in RAID 10
2 Hot spares
In RAID 10 would it matter that WALL is in the same RAID set?
Would it be better:
4 disks in RAID10 Data
2 disks RAID 1 WALL
2 hot spares
All in the same RAID controller
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: lists@stringsutils.com, tgl@sss.pgh.pa.us, dmagick@gmail.com
Subject: Re: Inserts optimization?
In-Reply-To: <cone.1144954763.735087.95544.5001@35st-server.simplicato.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