| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: INDEX |
| Date: | 2002-09-28 19:13:18 |
| Message-ID: | 20020928151318.B22793@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, Sep 28, 2002 at 09:50:13PM +0600, Waruna Geekiyanage wrote:
> When a table is created with a primary key it generates a index.
> Dos the queries on that table use that index automatically?
Only if you analyse the table, and it's a "win". See the various
past discussion on -general, for instance, about index use, and the
FAQ.
> Do I need to reindex that index after insertions?
No, but you need to analyse.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-10-01 18:27:56 | Re: [pgsql-performance] Deletes from tables with foreign keys taking |
| Previous Message | Waruna Geekiyanage | 2002-09-28 15:50:13 | INDEX |