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

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: BUG #3131: on win pg_connect() is very slow
Дата
Msg-id 45F5A346.7090508@hagander.net
обсуждение исходный текст
Ответ на BUG #3131: on win pg_connect() is very slow  ("dall" <maartins.j@gmail.com>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Randy Isbell
Дата:
Сообщение: Re: BUG #3110: Online Backup introduces Duplicate OIDs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3110: Online Backup introduces Duplicate OIDs