From: | "Fabio Panizzutti" <panizzutti(at)interlogica(dot)net> |
---|---|
To: | "'Christopher Kings-Lynne'" <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | R: R: R: Query plan on identical tables differs . Why ? |
Date: | 2004-05-14 10:30:16 |
Message-ID: | 001201c4399e$73469cc0$3c02020a@ufficio |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>>>-----Messaggio originale-----
>>>Da: pgsql-performance-owner(at)postgresql(dot)org
>>>[mailto:pgsql-performance-owner(at)postgresql(dot)org] Per conto di
>>>Christopher Kings-Lynne
>>>Inviato: venerdì 14 maggio 2004 11.55
>>>A: Fabio Panizzutti
>>>Cc: 'Manfred Koizar'; pgsql-performance(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Eduardo Almeida | 2004-05-14 18:00:37 | TPCH 100GB - need some help |
Previous Message | Mark Kirkwood | 2004-05-14 10:17:10 | Re: [PERFORM] Quad processor options - summary |