Matthias Apitz <guru(at)unixarea(dot)de> writes:
> I encounter from time to time that one of our ESQL/C clients hangs with
> the details described below for ever, while accessing on startup a table
> 'sisisinst' which has only some 50 rows, all of CHAR columns. Other ESQL/C clients
> start up fine (they all check this table 'sisisinst' on startup to
> verify the correct version of our application) Also SQL works
> fine.
> What can I do to get to the source of the problem? Thanks
Can you get a stack trace from the connected backend? Or even just look
at what it's doing according to pg_stat_activity? (If it's a reasonably
modern server, the wait-condition fields would be interesting.)
regards, tom lane