Tom Lane wrote:
Steve Clark <sclark@xxxxxxxxxxxxx> writes:
I have a program that worked fine in 7.4.19. I am in process of upgrading
to 8.3.1 and my program runs for a while and then hangs. I used gdb
to attach to the process and it shows the following backtrace which
shows it
going into the libpq library and getting stuck.
Well, gdb is lying to you to some extent (you'd probably get a better
backtrace if you had built libpq with debug symbols), but I think it's
simply waiting for a query response. Is the connected backend busy?
If the problem is that some query is taking way longer than you were
expecting, the first thought that comes to mind is "did you ANALYZE
your tables after reloading", and the second is "check for
configuration settings that you forgot to propagate into the new
installation".
regards, tom lane
Hi Tom,
I was testing with 8.2.6 before 8.3.0 came out and I don't think I saw
this problem.
I recompiled with debugging turned on and I'll do a closer inspection
when/if it happens
again.
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
