Re: BUG #4418: Memory leak in query planner

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: michael McMaster <Michael(dot)McMaster(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4418: Memory leak in query planner
Date: 2008-09-16 18:12:31
Message-ID: 1221588751.6194.87.camel@dell.linuxdev.us.dell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael McMaster 2008-09-16 20:23:48 Re: BUG #4418: Memory leak in query planner
Previous Message Tom Lane 2008-09-16 13:54:38 Re: BUG #4418: Memory leak in query planner