Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres, DB design, and object IDs (of any ilk) - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Postgres, DB design, and object IDs (of any ilk)
Date
Msg-id 2f4958ff0905211043r1182fbf1wd9be48d246760826@mail.gmail.com
Whole thread Raw
In response to Postgres, DB design, and object IDs (of any ilk)  (Kenneth Tilton <kentilton@gmail.com>)
List pgsql-general
Tree view 
I wouldn't trust OIDs, because they are 32bits for once.
Secondly, Watch for index size. That's the main reason why (big)int as
a key reference is a win over other types - at least in my general
practice.

And third advice, try different approaches, and queries - to figureout
what would suit the solution. Anyone who says, that this is always
win, and something else is not - is a lier.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Postgres, DB design, and object IDs (of any ilk)
Next
From: "Keith D. Evans"
Date:
Subject: Re: running postgresql on a private machine accessing it from public web pages