Re: FOREIGN KEYS vs PERFORMANCE

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
Cc: "Markus Schaber" <schabi(at)logix-tt(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: FOREIGN KEYS vs PERFORMANCE
Date: 2006-04-12 15:06:27
Message-ID: 919DB481-053D-4C06-852C-44F19F381EA8@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Apr 12, 2006, at 23:49 , Rodrigo Sakai wrote:

> Thanks for all help!! But my problem is with performance, I agree
> with all
> of you, the RI must be maintained by the database, because a bunch of
> reasons that everyone knows!

You've gotten a variety of good advice from a number of people. For
more specific advice (e.g., for your particular situation), it would
be very helpful if you could provide examples of queries that aren't
performing well for you (including table schema and explain analyze
output).

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2006-04-12 15:09:37 Re: FOREIGN KEYS vs PERFORMANCE
Previous Message Merlin Moncure 2006-04-12 15:03:26 Re: FOREIGN KEYS vs PERFORMANCE