Re: Getting even more insert performance (250m+rows/day)

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Getting even more insert performance (250m+rows/day)
Date: 2006-05-24 20:13:50
Message-ID: 20060524201350.GB10918@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, May 24, 2006 at 04:09:54PM -0400, Daniel J. Luke wrote:
> no warnings in the log (I did change the checkpoint settings when I
> set up the database, but didn't notice an appreciable difference in
> insert performance).

How about wal_buffers? Upping it might not help all that much if only one
thread is writing, but you might give it a try...

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel J. Luke 2006-05-24 20:18:06 Re: Getting even more insert performance (250m+rows/day)
Previous Message Larry Rosenman 2006-05-24 20:12:26 Re: Getting even more insert performance (250m+rows/day)