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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> I suggest you check this first. Check the performance tuning guide..
> That is a starters. As Josh suggested, increase checkpoint segments if you 
> 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


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-2017 The PostgreSQL Global Development Group