Re: slow pg_connect() - Mailing list pgsql-performance

From vincent
Subject Re: slow pg_connect()
Date
Msg-id 24238.194.109.235.253.1206347744.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to slow pg_connect()  (<firerox@centrum.cz>)
List pgsql-performance
>
> It takes more then 0.05s :(
>
> Only this function reduce server speed max to 20request per second.

First, benchmarking using only PHP is not very accurate, you're probably
also measuring some work that PHP needs to do just to get started in the
first place.

Second, this 20r/s is not requests/sec but connections per second per PHP
script. One pageview in PHP needs one connection, so it will delay the
pageview by 0.05 seconds.

If you need raw speed, you can use pg_pconnect(), but be VERY carefull
because that will keep one databaseconnection open for every database for
every webserverprocess. If you have 10 databasedriven websites running on
the same webserver and that server is configured to run 100 processes at
the same time, you will get 10x100=1000 open connections, which eats more
RAM than you have.


pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: slow pg_connect()
Next
From: "petchimuthu lingam"
Date:
Subject: increasing shared buffer slow downs query performance.