Re: Yet another question about not use on indexes - Mailing list pgsql-performance

From Tom Lane
Subject Re: Yet another question about not use on indexes
Date
Msg-id 13082.1052662532@sss.pgh.pa.us
Whole thread Raw
In response to Yet another question about not use on indexes  (Xevi Serrats <tomcatbsd@yahoo.es>)
List pgsql-performance
=?iso-8859-1?q?Xevi=20Serrats?= <tomcatbsd@yahoo.es> writes:
> pfc=# explain select * from document where codi=2;
>                         QUERY PLAN
> ----------------------------------------------------------
>  Seq Scan on document  (cost=0.00..1.19 rows=1 width=120)
>    Filter: (codi = 2)
> (2 rows)

Judging from the cost estimate, this table is too small to bother with
an indexscan.

            regards, tom lane


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Yet another question about not use on indexes
Next
From: "Lucas Adamski"
Date:
Subject: Re: Hack around lack of CORRESPONDING BY in EXCEPT?