Re: Compressing the AFTER TRIGGER queue
От
Tom Lane
Тема
Re: Compressing the AFTER TRIGGER queue
Дата
Msg-id
27705.1312219882@sss.pgh.pa.us
Ответ на
Re: Compressing the AFTER TRIGGER queue (Dean Rasheed)
Список
Дерево обсуждения
Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Tom Lane <tgl@sss.pgh.pa.us>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Tom Lane <tgl@sss.pgh.pa.us>
Re: Compressing the AFTER TRIGGER queue Robert Haas <robertmhaas@gmail.com>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Robert Haas <robertmhaas@gmail.com>
Re: Compressing the AFTER TRIGGER queue Tom Lane <tgl@sss.pgh.pa.us>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Tom Lane <tgl@sss.pgh.pa.us>
Re: Compressing the AFTER TRIGGER queue Simon Riggs <simon@2ndQuadrant.com>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Simon Riggs <simon@2ndQuadrant.com>
Re: Compressing the AFTER TRIGGER queue Jim Nasby <jim@nasby.net>
Re: Compressing the AFTER TRIGGER queue Alvaro Herrera <alvherre@commandprompt.com>
Re: Compressing the AFTER TRIGGER queue Robert Haas <robertmhaas@gmail.com>
Re: Compressing the AFTER TRIGGER queue "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Compressing the AFTER TRIGGER queue Jim Nasby <jim@nasby.net>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Compressing the AFTER TRIGGER queue Tom Lane <tgl@sss.pgh.pa.us>
Re: Compressing the AFTER TRIGGER queue Dean Rasheed <dean.a.rasheed@gmail.com>
Dean Rasheed writes: > On 1 August 2011 17:49, Tom Lane wrote: >> Ummm ... I only read the data structure comments, not the code, but I >> don't see where you store the second CTID for an update event? > Ah yes, I forgot to mention that bit. I'm using > &(tuple1.t_data->t_ctid) to get the second CTID from the old tuple. Is > that safe? Hmmmm ... not sure. It seems a bit scary, but on the other hand we should be able to assume that the updating subtransaction hasn't been rolled back (else surely we shouldn't be firing the trigger). So in principle it seems like the t_ctid link can't have been replaced. This will foreclose any ideas about collapsing t_ctid link chains, if anyone had it in mind to do that. regards, tom lane
В списке pgsql-hackers по дате отправления