Re: Plan time Improvement - 64bit bitmapset - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Plan time Improvement - 64bit bitmapset
Date
Msg-id 4A2F9BAE.2050208@anarazel.de
Whole thread Raw
In response to Re: Plan time Improvement - 64bit bitmapset  (Gregory Stark <stark@enterprisedb.com>)
List 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 by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Plan time Improvement - 64bit bitmapset
Next
From: Jeremy Kerr
Date:
Subject: Re: [PATCH 2/2] [libpq] Try to avoid manually masking SIGPIPEs on every send()