It might be worth trying out a build with -O2, just to rule out any -O3
oddness.
regards
Mark
Jim C. Nasby wrote:
PostgreSQL 7.4.2 compiled with -O3.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> stats=# explain analyze SELECT work_units, min(raw_rank) AS rank FROM
> Trank_work_overall GROUP BY work_units;
>
> ...
>
> raw_rank | bigint |
> work_units | bigint |
If you create a copy of the same table using regular integers does that run
fast? And a copy of the table using bigin
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Anyone have any ideas why this query would be so slow?
That seems very bizarre. Would you be willing to send me a dump of the
table off-list?
regards, tom lane
---(end of broadcast)-
Anyone have any ideas why this query would be so slow?
stats=# explain analyze SELECT work_units, min(raw_rank) AS rank FROM
Trank_work_overall GROUP BY work_units;
QUERY PLAN
--
