Re: how could select id=xx so slow? - Mailing list pgsql-performance

From Maciek Sakrejda
Subject Re: how could select id=xx so slow?
Date
Msg-id CAOtHd0Cq-hy1q1Mc8PW0MP8WMuztCsVHxGvU1z+B1xY5P6QkrA@mail.gmail.com
Whole thread Raw
In response to Re: how could select id=xx so slow?  (Yan Chunlu <springrider@gmail.com>)
List pgsql-performance
On Wed, Jul 11, 2012 at 5:47 PM, Yan Chunlu <springrider@gmail.com> wrote:
> I learnt a lot during the back and forth!

Great to hear.

>> 1, postgresql always have 400+ connections(dozens of python process using client pool)

Note that Postgres does not deal well with a large number of
connections[1]: consider shrinking the size of the pool.

[1]: http://wiki.postgresql.org/wiki/Number_Of_Database_Connections

pgsql-performance by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: how could select id=xx so slow?
Next
From: Craig Ringer
Date:
Subject: Re: DELETE vs TRUNCATE explanation