Re: [HACKERS] The enormous s->childXids problem

2006-09-29 Thread Robert Treat
On Saturday 16 September 2006 20:34, Tom Lane wrote: > Gregory Stark <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> writes: > >> The real question is why does the subtransaction actually assign itself > >> an XID --- a simple RETURN NEXT operation ought not do that, AFAICS. > > > > I

Re: [HACKERS] The enormous s->childXids problem

2006-09-16 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> The real question is why does the subtransaction actually assign itself >> an XID --- a simple RETURN NEXT operation ought not do that, AFAICS. > I suspect the answer to that is the same as the answer to what's act

Re: [HACKERS] The enormous s->childXids problem

2006-09-16 Thread Gregory Stark
Tom Lane <[EMAIL PROTECTED]> writes: > The real question is why does the subtransaction actually assign itself > an XID --- a simple RETURN NEXT operation ought not do that, AFAICS. > What is it you're doing in there that changes the database? I suspect the answer to that is the same as the answ

Re: [HACKERS] The enormous s->childXids problem

2006-09-16 Thread Tom Lane
Theo Schlossnagle <[EMAIL PROTECTED]> writes: > The select function is dbi-link's remote_select. > remote_select will perform the query and then for each row > return_next which calls the SPI.xs stuff to do plperl_return_next > which is wrapped in a PG_TRY block. I see the value of the try

Re: [HACKERS] The enormous s->childXids problem

2006-09-15 Thread Gregory Stark
Theo Schlossnagle <[EMAIL PROTECTED]> writes: > I've tracked the problem I mentioned earlier with my 4.5 million node linked > list of s->childXids down. We use plperl to connect to Oracle over DBI. The > select function is dbi-link's remote_select. remote_select will perform the > query and

[HACKERS] The enormous s->childXids problem

2006-09-15 Thread Theo Schlossnagle
I've tracked the problem I mentioned earlier with my 4.5 million node linked list of s->childXids down. We use plperl to connect to Oracle over DBI. The select function is dbi-link's remote_select. remote_select will perform the query and then for each row return_next which calls the SPI