Received: from femail1.sdc1.sfba.home.com (femail1.sdc1.sfba.home.com [24.0.95.81]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4I0JuA42044 for ; Thu, 17 May 2001 20:19:56 -0400 (EDT) (envelope-from fspam@home.com) Received: from bartok ([24.9.226.149]) by femail1.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with SMTP id <20010518001952.HUFI965.femail1.sdc1.sfba.home.com@bartok> for ; Thu, 17 May 2001 17:19:52 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Forest Wilkinson To: pgsql-sql@postgresql.org Subject: ON UPDATE CASCADE overhead? Date: Thu, 17 May 2001 17:19:52 -0700 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01051717195200.04161@bartok> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/186 X-Sequence-Number: 3003 If I add ON UPDATE CASCADE to my foreign key definitions, how much will it affect performance for queries that don't trigger the cascade? Cheers, Forest