I tried out the new CHECK NO INHERIT feature for inherited tables.
There seems to be an opportunity to generate slightly better query
plans sometimes. E.g. when I do
SELECT * FROM base WHERE partition_id = 3
and there exists only one child table for which partition_id = 3 is
true I guess the query plan could just do a seq/index/whatever scan on
that table. Right now the query plan has an intermediate "Append"
node. This seems only useful if the results of multiple child tables
would need to be included.
pgsql-hackers by date
|Next:||From: Albe Laurenz||Date: 2012-08-30 07:04:04|
|Subject: Re: HEAD crashes on windows when doing VACUUM ANALYZE|
|Previous:||From: Matthias||Date: 2012-08-30 05:56:10|
|Subject: HEAD crashes on windows when doing VACUUM ANALYZE|