Skip site navigation (1) Skip section navigation (2)

Re: What's faster?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: "Keith Bottner" <kbottner(at)comcast(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: What's faster?
Date: 2003-12-27 18:30:38
Message-ID: 12771.1072549838@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"D'Arcy J.M. Cain" <darcy(at)druid(dot)net> writes:
> We went through this recently.  One thing we found that may apply to you is 
> how many fields in the client record have a foreign key constraint.  We find 
> that tables with lots of FKeys are a lot more intensive on updates.

BTW, this should have gotten better in 7.3.4 and later --- there is
logic to skip checking an FKey reference if the referencing columns
didn't change during the update.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Sean ShannyDate: 2003-12-29 16:35:43
Subject: Question about difference in performance of 2 queries on large table
Previous:From: D'Arcy J.M. CainDate: 2003-12-27 10:52:07
Subject: Re: What's faster?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group