Horton

Re: Event Triggers reduced, v1

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Dimitri Fontaine <dimitri@2ndquadrant.fr>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-07-03T16:18:47Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Replace int2/int4 in C code with int16/int32

Robert Haas <robertmhaas@gmail.com> writes:
> Yeah, I'm of two minds on that.  I thought that it made sense to use
> integer identifiers internally for speed, but now I'm worried that the
> effort to translate back and forth between strings and integers is
> going to end up being more than any speed we might save.

We do that for nodetags in stored query/expression trees, and I've never
seen any indication that it costs enough to notice.  It's definitely a
huge win for anything that changes regularly, which seems like it'll be
a pretty good description of event tags for at least the next few years.

			regards, tom lane