From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chris <dmagick@gmail.com>
Cc: Francisco Reyes <lists@stringsutils.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Inserts optimization?
Date: Thu, 13 Apr 2006 00:42:24 -0400
Message-ID: <9549.1144903344@sss.pgh.pa.us> (raw)
In-Reply-To: <443DA715.4060606@gmail.com>
References: <cone.1144888738.434948.92126.5001@35st-server.simplicato.com>
<443DA715.4060606@gmail.com>
Chris <dmagick@gmail.com> writes:
> Francisco Reyes wrote:
>> Doing my first write heavy database.
>> What settings will help improve inserts?
>> Only a handfull of connections, but each doing up to 30 inserts/second.
> If you can, use copy instead:
> http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
Or at least try to do multiple inserts per transaction.
Also, increasing checkpoint_segments and possibly wal_buffers helps a
lot for write-intensive loads. 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.)
regards, tom lane
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: tgl@sss.pgh.pa.us, dmagick@gmail.com, lists@stringsutils.com
Subject: Re: Inserts optimization?
In-Reply-To: <9549.1144903344@sss.pgh.pa.us>
* 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