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

R: R: R: Query plan on identical tables differs . Why ?

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 (view raw, whole thread or download thread mbox)
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...

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


In response to

pgsql-performance by date

Next:From: Eduardo AlmeidaDate: 2004-05-14 18:00:37
Subject: TPCH 100GB - need some help
Previous:From: Mark KirkwoodDate: 2004-05-14 10:17:10
Subject: Re: [PERFORM] Quad processor options - summary

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