Re: notification payloads

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: notification payloads
Дата
Msg-id 4341.1174932460@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: notification payloads  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: notification payloads  (Hannu Krosing <hannu@skype.net>)
Список 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 по дате отправления:

Предыдущее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: pg_index updates and SI invalidation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_index updates and SI invalidation