Re: Question about foreign key

On Wed, Nov 06, 2002 at 03:49:49AM -0800, Terence Leung wrote:
> Dear sir,
> Hi, I am Terence and using Postgresql 7.0 in linux
> server and the web server can connect the database.

You'll be wanting to upgrade that. 7.0 is old and has had several
bugs fixed.

> Can the added foreign key improve the above sql
> performance so that it can search faster
> or the foreign key can only maintain the data
> integrity but cannot make the search faster?

It is only an integrity contraint. It makes no difference to speed
(well, that's not true. It slows some other things down).

Is you are having a performance problem, all the usual questions
(vacuums, &c) apply. But do upgrade first. Among other things,
performance was much improved in 7.2.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110