Neil Conway wrote:
>On Fri, 2004-11-19 at 17:15 +1300, Dru wrote:
>
>
>>Ok rules out that possibility also. Is there any stress testing
>>software for postgresql to find out how and when it breaks?
>>
>>
>
>Try contrib/pgbench.
>
>
>
>>The website uses php,
>>the problem could be in the wrapper code for PHP though. I havnt
>>got much luck asking php developers about the problem though.
>>
>>
>
>pgbench uses libpq (i.e. the native C client interface to PostgreSQL) --
>if you encounter connection failures using it, that will narrow down the
>set of possible culprits. Since you don't get an error message in the
>PostgreSQL logs when a connection is refused, it seems that the
>connection attempt doesn't even make it as far as the postmaster, so I
>would be skeptical of the software between the client and the backend
>(e.g. PHP, perhaps some kernel/TCP weirdness, etc.).
>
>-Neil
>
>
I'll have a look around for kernel limits regarding socket opening etc.
It could be that thats causing the problems.
