Skip site navigation (1) Skip section navigation (2)

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: dall <maartins(dot)j(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3131: on win pg_connect() is very slow
Date: 2007-03-12 19:00:22
Message-ID: 45F5A346.7090508@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
dall wrote:
> The following bug has been logged online:
> 
> Bug reference:      3131
> Logged by:          dall
> Email address:      maartins(dot)j(at)gmail(dot)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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-03-13 01:08:47
Subject: Re: BUG #3110: Online Backup introduces Duplicate OIDs
Previous:From: Randy IsbellDate: 2007-03-12 18:46:35
Subject: Re: BUG #3110: Online Backup introduces Duplicate OIDs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group