| From: | "Ron St(dot)Pierre" <rstpierre(at)syscor(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Indexing foreign keys |
| Date: | 2003-01-28 00:06:51 |
| Message-ID: | 3E35C99B.5020105@syscor.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Josh Berkus wrote:
> Matt,
>>Did the docs say to index those FK fields (is that standard in the DB
>>industry?), or was I just spoiled by IFX doing it for me? ;)
> It's pretty standard in the DB industry.
I didn't know that, but I'm new to the DB field. I've gleaned quite a
few tips from this group, especially from responses to people with slow
queries/databases, but this is the first I've noticed it this tip. I'll
try it on my db too.
--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre(at)syscor(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Johnson | 2003-01-28 00:33:13 | Re: Documentation needs significant improvement |
| Previous Message | Andrew Sullivan | 2003-01-27 23:38:38 | Thanks to PostgreSQL community |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-01-28 01:42:41 | Re: 7.3.1 New install, large queries are slow |
| Previous Message | Josh Berkus | 2003-01-27 21:23:19 | Re: Indexing foreign keys |