| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Daryl Herzmann" <akrherz(at)iastate(dot)edu>, "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Queries not using Index |
| Date: | 2002-07-24 01:47:18 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOCEEPCDAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> I inserted the data via 30 "COPY t2002_06 from stdin" (one per
> day) So it
> was grouped by station and then day for each insert. (My script dumped
> the data from each station for the day and then repeated for each station
> and then finally dumped the entire day into the DB. Are you saying that
> this process has tricked pgsql into not believing it needs to use an
> INDEX? Sorry for my ignorance here. I have done similar processes with
> PG7.1.2 and it seemed to use the INDEX.
>
> In fact, I just repeated the dumping scripts on a machine with 7.1.2 and
> the "explain select" reports to be using the Index Scan. Hmmmm
You _have_ actually run ANALYZE on the table, right?
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daryl Herzmann | 2002-07-24 01:57:15 | Re: Queries not using Index |
| Previous Message | Daryl Herzmann | 2002-07-24 00:53:46 | Re: Queries not using Index |