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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Sergey Samokhin <prikrutil(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What approach should I use instead of creating tables on the fly?
Date: 2009-08-24 02:00:42
Message-ID: 1251079242.22238.78.camel@wallace.localnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-24 02:21:32 Re: "Could not open relation XXX: No such file or directory"
Previous Message Craig Ringer 2009-08-24 01:59:36 Re: libpq performance