Re: notification payloads - Mailing list pgsql-hackers

From Tom Lane
Subject Re: notification payloads
Date
Msg-id 4341.1174932460@sss.pgh.pa.us
Whole thread Raw
In response to Re: notification payloads  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: notification payloads
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Why have the name on each message?  Presumably names are going to be few
> compared to the total number of messages, so maybe store the names in a
> separate hash table and link them with a numeric identifier.  That gives
> you room for a lot more messages.

That can be done by the application, if its notify payloads are such
that that's a useful optimization.  However it seems entirely possible
to me that the payload strings might be nonrepeating and the overhead
of a separate table completely wasted.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: pg_index updates and SI invalidation
Next
From: Tom Lane
Date:
Subject: Re: pg_index updates and SI invalidation