Hi,
Have a major reliability problem with out postgres installation here.
Basically the backends seem to "hang" when the server is under
non-trivial load. It can cope with ~200 concurrent connections (max is
1024) but anything over that and all the backends start to hang. By hang
I mean they answe
Tom,
Thanks for your reply.
> [...]
> > UID PID DBLOCK SIZE COMM PATHNAME
> > 103 687 W 120384 98304 postgres
> > /export/data/pgsql/data/global/pgstat.tmp.687
>
> Hmm. That's the stats collector creating a new current-stats file,
> which it does every half second or so
> [...]
> Right, the file is fully written under a temp name, and then
> rename()'d
This makes sense and is almost certainly not the cause of the problem.
Although there is a lot more data being written to that file than I
would have thought.
One of Sun's kernel engineers has come up with a solu
