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

Joseph Shraibman <jks@selectacast.net>

From: Joseph S <jks@selectacast.net>
To: Greg Smith <gsmith@gregsmith.com>
Date: 2009-08-28T14:25:10Z
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?
>