Re: [PERFORM] Optimizing FK & PK performance...

2003-12-16 Thread Christopher Kings-Lynne
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, namevarchar(40), PRIMARY KEY(did) ); CREATE TABLE distribu

Re: [PERFORM] Optimizing FK & PK performance...

2003-12-16 Thread Neil Conway
"Sean P. Thomas" <[EMAIL PROTECTED]> writes: > 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, > namev

[PERFORM] Optimizing FK & PK performance...

2003-12-16 Thread Sean P. Thomas
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/