2013/10/2 Andres Freund <and...@2ndquadrant.com> > Hi, > > On 2013-10-02 18:56:51 +0200, Pavel Stehule wrote: > > Hello > > > > this proposal is related to reported issue > > > http://www.postgresql.org/message-id/e1vquta-0007y4...@wrigleys.postgresql.org > > > > > > We can directly modify any fields of int, float, double arrays (when > result > > size will be immutable). This trick is used now for acceleration of some > > aggregates. > > > > Ideas, comments? > > A specific array might be located directly on a buffer - starting to > manipulate them inplace will lead to havoc in such scenarios. I don't > think we have the infrastructure for detecting such cases. >
If you can do a update of some array in plpgsql now, then you have to work with local copy only. It is a necessary precondition, and I am think it is valid. Pavel > > Greetings, > > Andres Freund > > -- > Andres Freund http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >