BUG #3131: on win pg_connect() is very slow

Started by dallabout 19 years ago2 messagesbugs
Jump to latest
#1dall
maartins.j@gmail.com

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.

#2Magnus Hagander
magnus@hagander.net
In reply to: dall (#1)
Re: BUG #3131: on win pg_connect() is very slow

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