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

From Craig Ringer
Subject Re: slow pg_connect()
Date
Msg-id 47E76087.3050901@postnewspapers.com.au
Whole thread Raw
In response to Re: slow pg_connect()  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
Craig Ringer wrote:
> firerox@centrum.cz wrote:
>> It takes more then 0.05s :(
>>
>> Only this function reduce server speed max to 20request per second.
>>
> If you need that sort of frequent database access, you might want to
> look into:
>
> - Doing more work in each connection and reducing the number of
> connections required;
> - Using multiple connections in parallel;
> - Pooling connections so you don't need to create a new one for every
> job;
> - Using a more efficient database connector and/or language;
> - Dispatching requests to a persistent database access provider that's
> always connected
>
Oh, I missed:

Use a UNIX domain socket rather than a TCP/IP local socket. Database
interfaces that support UNIX sockets (like psycopg) will normally do
this if you omit the host argument entirely.

--
Craig Ringer

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: slow pg_connect()
Next
From: "vincent"
Date:
Subject: Re: slow pg_connect()