Sam Stearns <samtstearns@gmail.com> writes:
> I have a SELECT query that runs no problem standalone but when running
> within a perl script it intermittently core dumps. Random, no pattern
> to the timing of the core dumps. The perl script processes the rows
> from the query, if the rows satisfy a condition then the perl script
> adds the rows to another table. When the script works it runs for
> about a minute. If the script fails, it runs for about 5 minutes and
> core dumps. The core dump is in the perl error handling routines. We
> suspect the bug is related to how the perl postgres libraries interact
> with postgres.
Can you get a stack trace from one of the core dumps?
Also, exactly which perl version are you using, and with what build
options? ("perl -V" output would be a good answer here.)
BTW, this seems pretty off-topic for pgsql-performance.
regards, tom lane