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

From Thomas Pundt
Subject Re: slow pg_connect()
Date
Msg-id 47E7A10F.5060805@rp-online.de
Whole thread Raw
In response to slow pg_connect()  (<firerox@centrum.cz>)
Responses Re: slow pg_connect()  (Chris <dmagick@gmail.com>)
List pgsql-performance
Hi,

firerox@centrum.cz schrieb:
> Please, how long takes your connectiong to postgres?
>
> $starttimer=time()+microtime();
>
> $dbconn = pg_connect("host=localhost port=5432 dbname=xxx user=xxx password=xxx")
>     or die("Couldn't Connect".pg_last_error());
>
> $stoptimer = time()+microtime();
> echo "Generated in ".round($stoptimer-$starttimer,4)." s";
>
> It takes more then 0.05s :(
>
> Only this function reduce server speed max to 20request per second.

Two hints:
* Read about configuring and using persistent database connections
   (http://www.php.net/manual/en/function.pg-pconnect.php) with PHP
* Use a connection pooler such as pgpool-II
   (http://pgpool.projects.postgresql.org/)

Using both techniques together should boost your performance.

Ciao,
Thomas

pgsql-performance by date:

Previous
From: Tommy Gildseth
Date:
Subject: Re: slow pg_connect()
Next
From: "petchimuthu lingam"
Date:
Subject: waiting for harddisk