Re: Problem with background worker - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Problem with background worker
Date
Msg-id 20130410163857.GO3751@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Problem with background worker  (Marc Cousin <cousinmarc@gmail.com>)
List 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 by date:

Previous
From: Dang Minh Huong
Date:
Subject: Re: [BUGS] replication_timeout not effective
Next
From: Alvaro Herrera
Date:
Subject: Re: Behaviour of bgworker with SIGHUP