plperl vs. bytea

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Theo Schlossnagle <jesus(at)omniti(dot)com>
Subject: plperl vs. bytea
Date: 2007-05-06 01:46:11
Message-ID: 463D3363.8070900@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I have been talking with Theo some more about his recent problem with
bytea arguments and results (see recent discussion on -bugs and also
recent docs patch), what he needs is a way to have bytea (and possibly
other unknown types) passed as binary data to and from plperl. The
conversion overhead is too big both computationally and in increased
memory usage. After discussing some possibilities, we decided that maybe
the best approach would be to allow a custom GUC variable that would
specify a list of types to be passed in binary form with no conversion, e.g.

plperl.pass_as_binary = 'bytea, other-type'

This would affect function args, trigger data, return results, and I
think it should also apply to arguments for SPI prepared queries and to
SPI returned results.

If this seems like a good idea maybe it should go on the TODO list in
whatever is the current incarnation.

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-05-06 01:49:54 Re: Integer datetimes
Previous Message Bruce Momjian 2007-05-06 01:28:30 Re: Integer datetimes