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: | Raw Message | Whole Thread | 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 |