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

Re: Insert are going slower ...

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

Le jeudi 15 Juillet 2004 20:09, Josh Berkus a écrit :
> > 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?

Hum ... it's only for speed aspect ... I was using postgresql with this option 
since 7.01 ... and for me fsync=on was so slow ...
Is it really no time consuming for the system to bring it ON now with 
v7.4.3 ??

Tell me ...
-- 
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902

In response to

Responses

pgsql-performance by date

Next:From: Litao WuDate: 2004-07-16 21:36:30
Subject: same plan, different time
Previous:From: Matt ClarkDate: 2004-07-16 07:35:32
Subject: Re: Swapping in 7.4.3

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