Re: What approach should I use instead of creating tables on the fly?

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: What approach should I use instead of creating tables on the fly?
Дата
Msg-id 1251079242.22238.78.camel@wallace.localnet
обсуждение исходный текст
Ответ на What approach should I use instead of creating tables on the fly?  (Sergey Samokhin <prikrutil@gmail.com>)
Ответы Re: What approach should I use instead of creating tables on the fly?
Список pgsql-general
On Mon, 2009-08-24 at 00:31 +0400, Sergey Samokhin wrote:

> Unfortunatelly there is one disadvantage coming with this solution
> which I don't like: features aimed to control reference integrity
> (like REFERENCES constraint) are no longer my friends.
>
> Is there a way that mixes the advantages (reference integrity + good
> performance) of those ones I listed above?

Table partitioning and table inheritance. See the manual and the list
archives.

--
Craig Ringer


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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: libpq performance
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: "Could not open relation XXX: No such file or directory"