On Wed, Mar 12, 2008 at 9:22 AM, Greg Sabino Mullane <greg@turnstep.com> wrote:
ommits.
>
> Are you sure you are calling DBI->connect *after* the Apache children
> are created?
Yes.
Major problems like this can happen if not. The use of
> prepare_cached() may be adding to the problem as well, especially if
> you are using temp tables.
The tables its failing on happen to not be temp tables (I only have 1
temp table and only do 1 insert into it for the entire transaction).
>In DBD::Pg, prepared statements are not
> actually prepared (in most cases) until just before the first execute,
> to account for late bindings and to be more efficient. Some related
> DBD::Pg attribs to look at are pg_server_prepare and pg_prepare_now.
Hrm, well i dont ever prepare them in mass, I only prepare them and
when im going to be calling execute right afterwords. But ill try
turning on autovac and setting pg_prepare_now to 1 and see what
happens.