Tuesday, September 16, 2008

Re: [BUGS] BUG #4418: Memory leak in query planner

On Tue, 2008-09-16 at 00:37 +0000, michael McMaster wrote:
> I intend on creating a view over a large number of tables (possibly > 1000).
> Each table in the view has a CHECK constraint that partitions the data by a
> time range.

You may try using the inheritance mechanism rather than a UNION ALL
view.

Regards,
Jeff Davis


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

No comments: