Postgres Pro
Downloads
Home   >   mailing lists

Re: What approach should I use instead of creating tables on the fly? - Mailing list pgsql-general

From Craig Ringer
Subject Re: What approach should I use instead of creating tables on the fly?
Date
Msg-id 1251079242.22238.78.camel@wallace.localnet
Whole thread Raw
In response to What approach should I use instead of creating tables on the fly?  (Sergey Samokhin <prikrutil@gmail.com>)
Responses Re: What approach should I use instead of creating tables on the fly?
List pgsql-general
Tree view 
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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: libpq performance
Next
From: Alvaro Herrera
Date:
Subject: Re: "Could not open relation XXX: No such file or directory"