pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hervé Piedvache <herve@elma.fr>
To: pgsql-performance@postgresql.org
To: josh@agliodbs.com
Cc: Shridhar Daithankar <shridhar@frodo.hserus.net>
Cc: Hervé Piedvache <footcow@noos.fr>
Subject: Re: Insert are going slower ...
Date: Fri, 16 Jul 2004 13:17:02 +0200
Message-ID: <200407161317.02515.herve@elma.fr> (raw)
In-Reply-To: <200407151109.16466.josh@agliodbs.com>
References: <200407131850.52095.herve@elma.fr>
	<40F62284.3090004@frodo.hserus.net>
	<200407151109.16466.josh@agliodbs.com>

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



view thread (17+ messages)  latest in thread

Message-ID: <200407161317.02515.herve@elma.fr>
Permalink:  ../200407161317.02515.herve@elma.fr/
Also on:    postgresql.org/message-id/200407161317.02515.herve@elma.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: herve@elma.fr, josh@agliodbs.com, shridhar@frodo.hserus.net, footcow@noos.fr
  Subject: Re: Insert are going slower ...
  In-Reply-To: <200407161317.02515.herve@elma.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox