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

From Tom Lane
Subject Re: Plan time Improvement - 64bit bitmapset
Date
Msg-id 10114.1244057053@sss.pgh.pa.us
Whole thread Raw
In response to Re: Plan time Improvement - 64bit bitmapset  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> But that doesn't explain the bitmap ops being important. Hm. Actually
> having a lot of columns and then joining a lot of tables could mean
> having fairly large bitmapsets.

Yeah, but then you have a lot of *other* expensive operations too,
such as the aforementioned statistics-pushing.  It's still pretty
mystifying why bitmapsets would be eating a noticeable fraction
of the total.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Plan time Improvement - 64bit bitmapset
Next
From: Ron Mayer
Date:
Subject: Re: PostgreSQL Developer meeting minutes up