Re: [GENERAL] Avoiding seq scan over 3.2 millions rows

2008-11-12 Thread tv
> "Andrus" <[EMAIL PROTECTED]> writes: >> explain analyze SELECT sum(xxx) >>FROM dok JOIN rid USING (dokumnr) >>WHERE dok.kuupaev BETWEEN '2008-04-01' AND '2008-04-30' > >> "Hash Join (cost=29584.84..308259.32 rows=142686 width=0) (actual >> time=68510.748..96932.174 rows=117883 loops=1)"

Re: [GENERAL] Avoiding seq scan over 3.2 millions rows

2008-11-11 Thread Tom Lane
"Andrus" <[EMAIL PROTECTED]> writes: > explain analyze SELECT sum(xxx) >FROM dok JOIN rid USING (dokumnr) >WHERE dok.kuupaev BETWEEN '2008-04-01' AND '2008-04-30' > "Hash Join (cost=29584.84..308259.32 rows=142686 width=0) (actual > time=68510.748..96932.174 rows=117883 loops=1)" > " Ha