From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
---|---|
To: | Doug McNaught <doug(at)wireboard(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: help with getting index scan |
Date: | 2002-02-25 15:22:06 |
Message-ID: | Pine.NEB.4.43.0202250919490.26699-100000@ns01.minnesota.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 25 Feb 2002, Doug McNaught wrote:
> "Thomas T. Thai" <tom(at)minnesota(dot)com> writes:
>
> > i can't seem to get index scan to work on table phone_cat_address. here
> > are my schemas:
>
> Standard question: have you run VACUUM ANALYZE?
yes :) before each test.
> Also, the estimate of rows returned from the phone_cat_address scan is
> pretty large--how large is the table itself? Sequential scan is
> actually faster if you're going to end up returning most of the rows
> in the table...
yellowpages=# select count(*) from phone_cat_address;
count
--------
336702
(1 row)
type typical results should be a tiny fraction of that number.
---
Thomas T. Thai | Minnesota.com | tom(at)minnesota(dot)com | 612.220.6220
Visit http://www.minnesota.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-25 15:31:36 | Re: tcpip_socket vs -i |
Previous Message | Doug McNaught | 2002-02-25 15:20:39 | Re: Work Around For Oracle Feature |