Re: [GENERAL] INHERITS and planning

2005-06-15 Thread Simon Riggs
On Thu, 2005-06-09 at 21:30 -0400, Edmund Dengler wrote: > We have 2 base tables, and use INHERITS to partition the data. When we get > around 2000-2200 sub-tables (approx 1000-1100 per base table), planning a > SELECT statement on the base table (ie, to search all sub-tables) will > start slowing

Re: [GENERAL] INHERITS and planning

2005-06-09 Thread Tom Lane
Edmund Dengler <[EMAIL PROTECTED]> writes: > Is there an issue when a large number of INHERITS tables exist for > planning? Well, there are a number of issues whenever a single query references a whole lot of tables in any fashion. It's only with Neil Conway's rewrite of the List package in 8.0 t