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

Re: Insert are going slower ...

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>, Hervé Piedvache <footcow(at)noos(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Insert are going slower ...
Date: 2004-07-15 18:09:16
Message-ID: 200407151109.16466.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Shridhar,

> I suggest you check this first. Check the performance tuning guide..
> 
> http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
> 
> That is a starters. As Josh suggested, increase checkpoint segments if you 
have 
> disk space. Correspondingly WAL disk space requirements go up as well.

Well, not if he has fsync=off.   But having fsync off is a very bad idea.  You 
do realize, Herve', that if you lose power on that machine you'll most likely 
have to restore from backup?

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-07-15 18:11:33
Subject: Re: Odd sorting behaviour
Previous:From: Brian HirtDate: 2004-07-15 18:07:12
Subject: hardware raid suggestions

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