Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4418: Memory leak in query planner - Mailing list pgsql-bugs

From Jeff Davis
Subject Re: BUG #4418: Memory leak in query planner
Date
Msg-id 1221588751.6194.87.camel@dell.linuxdev.us.dell.com
Whole thread Raw
In response to BUG #4418: Memory leak in query planner  ("michael McMaster" <Michael.McMaster@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4418: Memory leak in query planner
Next
From: Michael McMaster
Date:
Subject: Re: BUG #4418: Memory leak in query planner