test (cost=0.00..137223.89 rows=156194
width=725) (actual time=25.999..25708.478 rows=132528
loops=1)
Index Cond: (typeid = 9)
Filter: (productlistid = 3)
Total runtime: 25757.679 ms
(4 rows)
On Fri, 10 Jun 2005, Joshua D. Drake wrote:
Clark Slater wrote:
thanks for your suggestion
))
Total runtime: 36847.754 ms
(3 rows)
Time: 36850.719 ms
On Fri, 10 Jun 2005, Joshua D. Drake wrote:
Clark Slater wrote:
hmm, i'm baffled. i simplified the query
and it is still taking forever...
What happens if you:
alter table test alter column productlistid set statistics 150;
alter
red 7200 RPM IDE disks
On Fri, 10 Jun 2005, John A Meinel wrote:
Clark Slater wrote:
Hi-
Would someone please enlighten me as
to why I'm not seeing a faster execution
time on the simple scenario below?
there are 412,485 rows in the table and the
query matches on 132,528 rows, taking
almo
Hi-
Would someone please enlighten me as
to why I'm not seeing a faster execution
time on the simple scenario below?
there are 412,485 rows in the table and the
query matches on 132,528 rows, taking
almost a minute to execute. vaccuum
analyze was just run.
Thanks!
Clark
test
---
