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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general