Re: What exactly is postgres doing during INSERT/UPDATE ?

From: Joseph S <jks(at)selectacast(dot)net>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Date: 2009-08-28 14:25:10
Message-ID: 4A97E8C6.4060408@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith wrote:

> The main two things you can do to improve this on the database side:
>
> -Increase checkpoint_segments, which reduces how often updated data has
> to be flushed to disk

It fsync is turned off, does this matter so much?
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joseph S 2009-08-28 14:28:51 Re: What exactly is postgres doing during INSERT/UPDATE ?
Previous Message Scott Marlowe 2009-08-28 08:29:17 Re: What exactly is postgres doing during INSERT/UPDATE ?