"Nicholay P. Chuprynin" <[EMAIL PROTECTED]> writes:
> I switched enable_seqscan to 'false', restarted server and EXPLAINed the
> same query again:
> ...
> Now it uses index scan, but query takes MUCH more time than before (about
> an hour, and it's not finished yet).
> It seems very strange for m
Hello, All!
Today I tried the following query on a large table (11543179 rows).
SELECT sum(raw_bytes)
FROM raw_acct
WHERE raw_date > '2001-12-31'
AND ts_client_id = 93
AND ts_server_id IS NOT NULL;
It took about 4 minutes to complete so I EXPLAINed it:
NOTICE: QUERY PLAN:
Aggregate (cost=3
