Re: Problem with background worker

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Problem with background worker
Дата
Msg-id 20130410163857.GO3751@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Problem with background worker  (Marc Cousin <cousinmarc@gmail.com>)
Список pgsql-hackers
Marc Cousin escribió:
> On 20/03/2013 16:33, Alvaro Herrera wrote:

> >Ah.  The reason for this problem is that the statement start time (which
> >also sets the transaction start time, when it's the first statement) is
> >set by postgres.c, not the transaction-control functions in xact.c.  So
> >you'd need to add a SetCurrentStatementStartTimestamp() call somewhere
> >in your loop.
> >
>
> Yes, that works. Thanks a lot !
>
> Maybe this should be added to the worker_spi example ?

Done in
http://git.postgresql.org/pg/commitdiff/e543631f3c162ab5f6020b1d0209e0353ca2229a

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dang Minh Huong
Дата:
Сообщение: Re: [BUGS] replication_timeout not effective
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Behaviour of bgworker with SIGHUP