Re: Listen / Notify - what to do when the queue is full

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: Listen / Notify - what to do when the queue is full
Дата
Msg-id
1265761835.17112.47.camel@monkey-cat.sm.truviso.com
Ответ на
Список
Дерево обсуждения
Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full "Greg Sabino Mullane" <greg@turnstep.com>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Greg Stark <gsstark@mit.edu>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full Josh Berkus <josh@agliodbs.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: Listen / Notify - what to do when the queue is full "Greg Sabino Mullane" <greg@turnstep.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full "Florian G. Pflug" <fgp@phlo.org>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full "Florian G. Pflug" <fgp@phlo.org>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full "Florian G. Pflug" <fgp@phlo.org>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Greg Smith <greg@2ndquadrant.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Robert Haas <robertmhaas@gmail.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Andrew Dunstan <andrew@dunslane.net>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Andrew Dunstan <andrew@dunslane.net>
Re: Listen / Notify - what to do when the queue is full Alvaro Herrera <alvherre@commandprompt.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Robert Haas <robertmhaas@gmail.com>
Re: Listen / Notify - what to do when the queue is full Alvaro Herrera <alvherre@commandprompt.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Simon Riggs <simon@2ndQuadrant.com>
Re: Listen / Notify - what to do when the queue is full Josh Berkus <josh@agliodbs.com>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full "Greg Sabino Mullane" <greg@turnstep.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Robert Haas <robertmhaas@gmail.com>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Jeff Davis <pgsql@j-davis.com>
Re: Listen / Notify - what to do when the queue is full Arnaud Betremieux <arnaud.betremieux@keyconsulting.fr>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full "Greg Sabino Mullane" <greg@turnstep.com>
Re: Listen / Notify - what to do when the queue is full Peter Eisentraut <peter_e@gmx.net>
Re: Listen / Notify - what to do when the queue is full Arnaud Betremieux <arnaud.betremieux@keyconsulting.fr>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Arnaud Betremieux <arnaud.betremieux@keyconsulting.fr>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Merlin Moncure <mmoncure@gmail.com>
Re: Listen / Notify - what to do when the queue is full Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Andrew Chernow <ac@esilo.com>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
Re: Listen / Notify - what to do when the queue is full Joachim Wieland <joe@mcknight.de>
Re: Listen / Notify - what to do when the queue is full Tom Lane <tgl@sss.pgh.pa.us>
On Tue, 2010-02-09 at 19:02 -0500, Andrew Chernow wrote:
> Wouldn't binary payloads be an alternative?  NOTE: I may have missed this 
> discussion.  Sorry if it has already been covered.

The Notify struct has a "char *" field, which can't hold embedded NULL
bytes, so it can't really be binary. But it can't be arbitrary text,
because it has to be encoded in a way that works for every possible
client encoding (otherwise there's a possibility of an error, and no way
to handle it).

Also, the query starts out as text, so we need a way to interpret the
text in an encoding-independent way.

So, I think ASCII is the natural choice here.

Regards,Jeff Davis


В списке pgsql-hackers по дате отправления
От: Marko Tiikkaja
Дата:
От: Tom Lane
Дата:
FAQ