Home > mailing lists

ToDo: fast update of arrays with fixed length fields for PL/pgSQL - Mailing list pgsql-hackers

From	Pavel Stehule
Subject	ToDo: fast update of arrays with fixed length fields for PL/pgSQL
Date	October 2, 2013 19:57:37
Msg-id	CAFj8pRAKuDU_0md-dg6Ftk0wSupvMLyrV1PB+HyC+GUBZz346w@mail.gmail.com Whole thread Raw
Responses	Re: ToDo: fast update of arrays with fixed length fields for PL/pgSQL
List	pgsql-hackers

Tree view

Hello

this proposal is related to reported issue http://www.postgresql.org/message-id/E1VQuta-0007Y4-Ip@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?

Regards

Pavel

pgsql-hackers by date:

From: Merlin Moncure
Date: 02 October 2013, 19:08:14
Subject: Re: Who is pgFoundery administrator?

From: Andres Freund
Date: 02 October 2013, 20:01:59
Subject: Re: ToDo: fast update of arrays with fixed length fields for PL/pgSQL

ToDo: fast update of arrays with fixed length fields for PL/pgSQL - Mailing list pgsql-hackers

Previous

Next