"Stephen Denne" <[EMAIL PROTECTED]> writes:
> The custom variable class can also be used to aggregate the deltas within a
> transaction, though there are some minor difficulties:
> 1) They only store text
> 2) You can only find out that a value has not been set by catching an
> exception
> 3) There is no way to list the settings.
As for 2) and 3), can't you look into the pg_settings view?
> The time to create them for the first time for a connection seems to
vary a bit, between 200 and 1000 per minute.
Yeah, that path is not optimized at all because it was never considered
performance-critical. Updating an existing variable should be cheaper.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
