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

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Postgres, DB design, and object IDs (of any ilk)
Дата
Msg-id 2f4958ff0905211043r1182fbf1wd9be48d246760826@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres, DB design, and object IDs (of any ilk)  (Kenneth Tilton <kentilton@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Postgres, DB design, and object IDs (of any ilk)
Следующее
От: "Keith D. Evans"
Дата:
Сообщение: Re: running postgresql on a private machine accessing it from public web pages