2010/11/18 Robert Haas <robertmh...@gmail.com>: > On Thu, Nov 18, 2010 at 12:36 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> I would *much* rather we get the performance benefit by internal >> optimization, and forego inventing syntax. > > +1.
any optimization will be about 10-20% slower than direct access. See my tests: on large arrays isn't significant if you use a simple expression or full query. This is just overhead from building a "tuplestore" and access to data via cursor. And you cannot to change a SRF functions to returns just array. I would to see any optimization on this level, but I think so it's unreal expecting. Regards Pavel Stehule > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
