Re: Postgres, DB design, and object IDs (of any ilk)

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Kenneth Tilton <kentilton(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres, DB design, and object IDs (of any ilk)
Date: 2009-05-21 17:43:33
Message-ID: 2f4958ff0905211043r1182fbf1wd9be48d246760826@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keith D. Evans 2009-05-21 17:49:15 Re: running postgresql on a private machine accessing it from public web pages
Previous Message Merlin Moncure 2009-05-21 17:29:11 Re: Postgres, DB design, and object IDs (of any ilk)