On Wed, 16 May 2007 06:09:15 +0200, camb <[EMAIL PROTECTED]> wrote:
Hey all,
I'm sorta new to PG and am just wondering, when I create a foreign key
is it automatically set as an indexed column or do I need to also set
that manually?
Primary key creates unique index.
Foreign keys do not create any indexes, it is up to you to decide if you
need indexes or not.
Say :
CREATE TABLE items ( ... category_id REFERENCES categories( id ) )
if you want cascaded deletes/updates to your items table to be fast, or
you need it for other reasons, create an index on category_id.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
