Tom Lane wrote:
> Alban Hertroys <[EMAIL PROTECTED]> writes:
>> My conclusion is that this query time is mostly limited to the somewhat
>> complex COUNT expressions. Is there any way to do this more efficiently?
>
> Offhand I would bet on the bitstring-AND operations being the
> bottleneck; you co
Brandon Aiken wrote:
> Shouldn't these be using HAVING?
>
> SELECT COUNT(max_persons) ...
> GROUP BY NULL
> HAVING max_persons >= 5 AND max_persons <= 8;
I don't think so; I need multiple COUNT results for multiple
combinations; 5-8 persons isn't the only one. I also need counts for
1-4, 9-12 and
Alban Hertroys <[EMAIL PROTECTED]> writes:
> My conclusion is that this query time is mostly limited to the somewhat
> complex COUNT expressions. Is there any way to do this more efficiently?
Offhand I would bet on the bitstring-AND operations being the
bottleneck; you could test this by comparing
January 09, 2007 11:07 AM
To: Postgres General
Subject: [GENERAL] Operator performance question
Hi all,
I need your help on a small performance problem.
I have a table of which I have to do a bunch of counts of various
conditions. The worst case scenario where I have to iterate over every
record i
Hi all,
I need your help on a small performance problem.
I have a table of which I have to do a bunch of counts of various
conditions. The worst case scenario where I have to iterate over every
record in the table performs just a little bit too slow (800ms). That
particular query will be hit a lo
