Alvaro Herrera <alvherre(at)commandprompt(dot)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
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2007-03-26 18:15:39|
|Subject: Re: pg_index updates and SI invalidation |
|Previous:||From: Pavan Deolasee||Date: 2007-03-26 18:01:20|
|Subject: Re: pg_index updates and SI invalidation|