Re: Plan time Improvement - 64bit bitmapset

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Plan time Improvement - 64bit bitmapset
Дата
Msg-id 4A2F9BAE.2050208@anarazel.de
обсуждение исходный текст
Ответ на Re: Plan time Improvement - 64bit bitmapset  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Hi,

On 06/10/2009 01:38 PM, Gregory Stark wrote:
> Andres Freund<andres@anarazel.de>  writes:
>
>> Plan time (averaged) without change:
>> cnt: 40 (4 times per session)
>> avg: 4572ms
>>
>> Plan time (averaged) with change:
>> cnt: 40 (4 times per session)
>> avg: 4236ms
>>
>> ~7% difference. Same with higher number of repetitions and with most other
>> planner settings I tried
>
> What are you comparing here?
32bit and 64bit bitmapsets with the attached query. 32beeing the default 
and the slower one.

Does that answer the question?


Andres


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Plan time Improvement - 64bit bitmapset
Следующее
От: Jeremy Kerr
Дата:
Сообщение: Re: [PATCH 2/2] [libpq] Try to avoid manually masking SIGPIPEs on every send()