| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: select query not using index |
| Date: | 2006-12-02 12:32:20 |
| Message-ID: | 20061202123220.GA31919@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am Sat, dem 02.12.2006, um 16:35:47 +0530 mailte vivek(at)staff(dot)ownmail(dot)com folgendes:
>
> The index was created before the table was populated. There are 3 rows
> in the table for 3 different users. Now when I do a
In this case, with only 3 rows, it is much cheaper to do a seq-scan
instead a index-scan, because a index-scan must read the index first and
then the table. And in your case, with only 3 rows, the engine needs
only one page to read.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2006-12-02 12:54:52 | Re: select query not using index |
| Previous Message | Gregory S. Williamson | 2006-12-02 12:28:11 | Re: select query not using index |