From: Sean P. Thomas <spt@ulanji.com>
To: pgsql-performance@postgresql.org
Subject: Optimizing FK & PK performance...
Date: Thu, 11 Dec 2003 11:38:10 -0500
Message-ID: <3FD89D72.8080508@ulanji.com> (raw)
I am working on migrating to postgres and had some questions regarding
optimization that I could not find references in the documentation:
1. Is there any performance difference for declaring a primary or
foreign key a column or table contraint? From the documentation, which
way is faster and/or scales better:
CREATE TABLE distributors (
did integer,
name varchar(40),
PRIMARY KEY(did)
);
CREATE TABLE distributors (
did integer PRIMARY KEY,
name varchar(40)
);
2. Is DEFERRABLE and INITIALLY IMMEDIATE or INITIALLY DEFERRABLE
perferred for performance? We generally have very small transactions
(web app) but we utilize a model of:
view (limit scope for security) -> rules -> before triggers (validate
permissions and to set proper permissions) -> tables.
I know there were some issues with deferring that was fixed but does it
benefit performance or cause any reliability issues?
Thank you for your assistance and let me know if I can offer additional
information.
--spt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spt@ulanji.com
Subject: Re: Optimizing FK & PK performance...
In-Reply-To: <3FD89D72.8080508@ulanji.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox