From: | Theo Schlossnagle <jesus(at)omniti(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Theo Schlossnagle <jesus(at)omniti(dot)com> |
Subject: | The enormous s->childXids problem |
Date: | 2006-09-16 03:26:07 |
Message-ID: | 3834E576-2265-4B75-9F94-4D7156EEB373@omniti.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.xs stuff to do plperl_return_next
which is wrapped in a PG_TRY block. I see the value of the try block
to kick back sensible errors to perl, but creating childXids for
every row of a setof seems wildly excessive. What's the harm in
simply not TRY'ing around there?
I ask with respect to the suitability as general solution and as the
suitability for my acute issue (of a 5 million row setof returned
from that). Will it break anything?
Best regards,
Theo
// Theo Schlossnagle
// CTO -- http://www.omniti.com/~jesus/
// OmniTI Computer Consulting, Inc. -- http://www.omniti.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Drake | 2006-09-16 03:32:02 | Re: polite request about syntax |
Previous Message | Gregory Stark | 2006-09-16 02:01:36 | Re: Reducing data type space usage |