On Fri, May 17, 2013 at 10:22:59AM +0530, Amit Kapila wrote:
> > Yes, that would be user-visible, though we rarely add details like
> > that.
> > What queries are faster, that users would understand?
>
> Example:
> CREATE TABLE tbl_parent (c01 numeric, c02 int);
>
> CREATE TABLE tbl_child () INHERITS(tbl_parent);
>
> INSERT INTO tbl_child (SELECT floor(random() * 10000), n FROM
> generate_series(0, 10000000 - 1) n);
>
> SELECT * FROM tbl_parent;
>
> Any such cases where user is selecting more number of columns from parent
> table will improve a lot.
Sorry, I am still not seeing how this fits into the release notes.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +
