Re: ALTER TABLE ... NOREWRITE option

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: ALTER TABLE ... NOREWRITE option
Дата
Msg-id
20121205225618.GA27424@awork2.anarazel.de
Ответ на
Re: ALTER TABLE ... NOREWRITE option (Simon Riggs)
Список
Дерево обсуждения
ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option Noah Misch <noah@leadboat.com>
Re: ALTER TABLE ... NOREWRITE option Hannu Krosing <hannu@krosing.net>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Noah Misch <noah@leadboat.com>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option "Petr Jelinek" <pjmodos@pjmodos.net>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option John R Pierce <pierce@hogranch.com>
Re: ALTER TABLE ... NOREWRITE option Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Robert Haas <robertmhaas@gmail.com>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option Robert Haas <robertmhaas@gmail.com>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Robert Haas <robertmhaas@gmail.com>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option "Petr Jelinek" <pjmodos@pjmodos.net>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option "Petr Jelinek" <pjmodos@pjmodos.net>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Robert Haas <robertmhaas@gmail.com>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Simon Riggs <simon@2ndQuadrant.com>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option Josh Berkus <josh@agliodbs.com>
Re: ALTER TABLE ... NOREWRITE option Andres Freund <andres@2ndquadrant.com>
Re: ALTER TABLE ... NOREWRITE option "Petr Jelinek" <pjmodos@pjmodos.net> 
On 2012-12-05 22:41:21 +0000, Simon Riggs wrote:
> On 5 December 2012 22:21, Dimitri Fontaine  wrote:
> > Simon Riggs  writes:
> >>> CREATE EVENT TRIGGER my_event_trigger
> >>>     ON table_rewrite
> >>>     EXECUTE PROCEDURE consider_whether_to_throw_an_error();
> >>
> >> +1, I was just thinking that myself.
> >
> > +1, and I think that can happen for 9.3, as soon as we agree on the list
> > of code points where we want that event to fire. ALTER TABLE variants
> > that are rewriting the heap, sure. CLUSTER? VACUUM FULL? TRUNCATE?
>
> Events needed
> * Table rewrite
> * Index rebuild

Those should be fairly easy.

> * Relation scan (index/table/toast etc)
> * AccessExclusiveLock

I am worried about the overhead of looking for triggers for those two
though. Especially for RelationScans.

Greetings,

Andres Freund

--Andres Freund	                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления
Предыдущее
От: Dimitri Fontaine
Дата:
Следующее
От: Robert Haas
Дата:
FAQ