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

Поиск
Список
Период
Сортировка
От Fabio Panizzutti
Тема R: R: R: Query plan on identical tables differs . Why ?
Дата
Msg-id 001201c4399e$73469cc0$3c02020a@ufficio
обсуждение исходный текст
Ответ на Re: R: R: Query plan on identical tables differs . Why ?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance

>>>-----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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Quad processor options - summary
Следующее
От: Eduardo Almeida
Дата:
Сообщение: TPCH 100GB - need some help