Postgres Pro
Downloads
Home   >   mailing lists

Re: What exactly is postgres doing during INSERT/UPDATE ? - Mailing list pgsql-performance

From Joseph S
Subject Re: What exactly is postgres doing during INSERT/UPDATE ?
Date
Msg-id 4A97E8C6.4060408@selectacast.net
Whole thread Raw
In response to Re: What exactly is postgres doing during INSERT/UPDATE ?  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Tree view 
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?
>

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Next
From: Joseph S
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?