Re: Why does plpython delay composite type resolution?

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why does plpython delay composite type resolution?
Date: 2016-12-21 07:55:08
Message-ID: 46410e71-5858-5984-48de-550953e819b2@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/21/2016 04:14 AM, Jim Nasby wrote:
> Why do functions that accept composite types delay type resolution until
> execution? I have a naive patch that speeds up plpy.execute() by 8% by
> caching interred python strings for the dictionary key names (which are
> repeated over and over). The next step is to just pre-allocate those
> strings as appropriate for the calling context, but it's not clear how
> to handle that for input arguments.

Does your patch handle "ALTER TYPE name ADD ATTRIBUTE ..."? My immediate
guess would be that it could be a cache invalidation thing.

Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-12-21 08:02:15 Re: [PATCH] Transaction traceability - txid_status(bigint)
Previous Message Ants Aasma 2016-12-21 07:40:09 Re: Replication slot xmin is not reset if HS feedback is turned off while standby is shut down