Re: how could select id=xx so slow?

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: how could select id=xx so slow?
Дата
Msg-id CAOtHd0Cq-hy1q1Mc8PW0MP8WMuztCsVHxGvU1z+B1xY5P6QkrA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how could select id=xx so slow?  (Yan Chunlu <springrider@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Yan Chunlu
Дата:
Сообщение: Re: how could select id=xx so slow?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: DELETE vs TRUNCATE explanation