X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 265C211F8B81
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Apr 2006 16:35:47 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0.001
X-Spam-Level: 
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id yCsSDIwcQ7Vk
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Apr 2006 16:33:06 -0300 (ADT)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id ACF6A11F87D0
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Apr 2006 16:13:30 -0300 (ADT)
Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85])
	by svr4.postgresql.org (Postfix) with ESMTP id 53F2F5AF18F
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Apr 2006 19:13:29 +0000 (GMT)
Received: from cprsakai ([192.168.0.71])
	by mail.zanthus.com.br (8.13.4/8.13.4/Debian-3) with SMTP id
	k3BJEhB6005390
	for <pgsql-performance@postgresql.org>; Tue, 11 Apr 2006 16:14:43 -0300
Message-ID: <001301c65d9c$08884ef0$4700a8c0@TREEZANTHUS>
Reply-To: "Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>
From: "Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>
To: <pgsql-performance@postgresql.org>
Subject: FOREIGN KEYS  vs  PERFORMANCE
Date: Tue, 11 Apr 2006 16:13:34 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0010_01C65D82.E258A630"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
X-Zanthus-MailScanner: Found to be clean
X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br
X-Archive-Number: 200604/240
X-Sequence-Number: 18324

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C65D82.E258A630
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

  Hi,

  I think this is an old question, but I want to know if it really is =
well worth to not create some foreign keys an deal with the referential =
integrity at application-level?????
  Specifically, the system we are developing is a server/cliente =
architecture that the server is the database and the fat client is an =
application developed in DELPHI!!!

  Thanks in advance!!
------=_NextPart_000_0010_01C65D82.E258A630
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1528" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>&nbsp; Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; I think this is an old question, =
but I want=20
to know if it really is well worth to not create <STRONG>some</STRONG> =
foreign=20
keys an deal with the referential integrity at=20
application-level?????</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Specifically, the system we are =
developing=20
is a server/cliente architecture that the server is the database and the =
fat=20
client is an application developed in DELPHI!!!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Thanks in=20
advance!!</FONT></DIV></BODY></HTML>

------=_NextPart_000_0010_01C65D82.E258A630--