4 maj 2007 kl. 18:09 skrev Tom Lane:
Henrik Zagerholm <[EMAIL PROTECTED]> writes:
I have a SELECT query that uses Seq scans instead of index scan
despite that the index scan is faster.
Try 8.2, it's a bit smarter about the costs of repeated indexscans
on the inside of a nestloop.
Ahh sorr
Henrik Zagerholm <[EMAIL PROTECTED]> writes:
> I have a SELECT query that uses Seq scans instead of index scan
> despite that the index scan is faster.
Try 8.2, it's a bit smarter about the costs of repeated indexscans
on the inside of a nestloop.
regards, tom lane
---
Hello list,
I have a SELECT query that uses Seq scans instead of index scan
despite that the index scan is faster.
Below is the query and its first run with enable seqsan = true which
give a Seq Scan on tbl_structure (cost=0.00..19147.29 rows=172229
width=97) (actual time=0.094..878.309
