Re: Yet another question about not use on indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Xevi Serrats <tomcatbsd(at)yahoo(dot)es>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Yet another question about not use on indexes
Date: 2003-05-11 14:15:32
Message-ID: 13082.1052662532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?iso-8859-1?q?Xevi=20Serrats?= <tomcatbsd(at)yahoo(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2003-05-11 16:54:50 Re: realtime data inserts
Previous Message Richard Huxton 2003-05-11 14:08:34 Re: Yet another question about not use on indexes