2010/11/18 Robert Haas <[email protected]>: > On Thu, Nov 18, 2010 at 12:36 PM, Tom Lane <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
