| From: | Alexander Lohse <al(at)humantouch(dot)de> |
|---|---|
| To: | Patrik Kudo <kudo(at)partitur(dot)se> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using Indices |
| Date: | 2001-04-02 11:46:12 |
| Message-ID: | p05010400b6ee16d0717d@[192.168.0.44] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>Hi
>
>You should use the original field name. You don't have to worry about the
>indicies after they're created. Postgres uses them automagicaly whenever
>she think they'll speed up your queries. The name of the index is choosen
>to make it easy to understand what it's indexing (pers table, uid key in
>your case)
>
>Hope it helps.
Yeap, that was what I needed. Thanx.
Alex
--
___________________________
Alexander Lohse
Human Touch Medienproduktion GmbH
Am See 1
17440 Klein Jasedow
Tel: (038374) 75211
Fax: (038374) 75223
eMail: al(at)humantouch(dot)de
http://www.humantouch.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-04-02 12:09:46 | Re: Log file to sql database |
| Previous Message | Einar Karttunen | 2001-04-02 11:32:38 | User identification (external/internal) |