Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group