| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
| Cc: | postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: index not scanned |
| Date: | 2002-10-27 10:56:57 |
| Message-ID: | 20021027105657.GF5775@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Oct 27, 2002 at 12:46:39PM +0200, Ben-Nes Michael wrote:
> Hi
>
> I add an Index to table that have only 30 rows.
...
> does the planner knows that the table is small and it will take more time to
> check the index then stright check ?
Yes.
> by the way, the table will get quite big in the future.
So add a few thousand more rows and try again. Don't forget to ANALYZE.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Yapt | 2002-10-27 12:02:38 | Operator to compare numeric and double precision |
| Previous Message | Ben-Nes Michael | 2002-10-27 10:46:39 | index not scanned |