pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Fabio Panizzutti <panizzutti@interlogica.net>
To: 'Christopher Kings-Lynne' <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: R: R: R: Query plan on identical tables differs . Why ?
Date: Fri, 14 May 2004 12:30:16 +0200
Message-ID: <001201c4399e$73469cc0$3c02020a@ufficio> (raw)
In-Reply-To: <20040514175425.S22343-100000@houston.familyhealth.com.au>



>>>-----Messaggio originale-----
>>>Da: pgsql-performance-owner@postgresql.org 
>>>[mailto:pgsql-performance-owner@postgresql.org] Per conto di 
>>>Christopher Kings-Lynne
>>>Inviato: venerdì 14 maggio 2004 11.55
>>>A: Fabio Panizzutti
>>>Cc: 'Manfred Koizar'; pgsql-performance@postgresql.org
>>>Oggetto: Re: R: R: [PERFORM] Query plan on identical tables 
>>>differs . Why ?
>>>
>>>
>>>> I trust in my hardware an O.S so fsync setting is a
>>>> big dubt for my production enviroment .
>>>
>>>Then you are making a big mistake, loving your hardware more 
>>>than your data...
>>>
>>>Chris
>>>


I'm testing for better performance in insert/delete so i turn off fsync
, i don't love hardware more than data , so i'll set fsync on in the
production enviroment .
Thanks a lot

Best regards

Fabio    




Message-ID: <001201c4399e$73469cc0$3c02020a@ufficio>
Permalink:  ../001201c4399e$73469cc0$3c02020a@ufficio/
Also on:    postgresql.org/message-id/001201c4399e$73469cc0$3c02020a@ufficio

 · 

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: panizzutti@interlogica.net, chriskl@familyhealth.com.au
  Subject: Re: R: R: R: Query plan on identical tables differs . Why ?
  In-Reply-To: <001201c4399e$73469cc0$3c02020a@ufficio>

* 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