Re: BUG #3131: on win pg_connect() is very slow - Mailing list pgsql-bugs

dall wrote:
> The following bug has been logged online:
>
> Bug reference:      3131
> Logged by:          dall
> Email address:      maartins.j@gmail.com
> PostgreSQL version: 8.2
> Operating system:   win
> Description:        on win pg_connect() is very slow
> Details:
>
> System: windows xp, PHP5.1.6, postgresql 8.2 - home pc
>
> When I call pg_connect() its 12x slower than on *nix servers.I think its
> postgreSQL falt not PHP.

Making new connections is known to be significantly slower on win32 than
on Unix, due to the fact that win32 lacks the fork() call. I'm not sure
if 12x slower is a representative figure, but it certainly could be.

You really should be using persistent connections, that will make the
problem almost go away.

//Magnus