Re: Howto Increased performace ?

От: Cosimo Streppone
Тема: Re: Howto Increased performace ?
Дата: ,
Msg-id: 41CFF3D2.3090305@team2k.net
(см: обсуждение, исходный текст)
Ответ на: Re: Howto Increased performace ?  ("Iain")
Список: pgsql-performance

Скрыть дерево обсуждения

Howto Increased performace ?  ("Amrit Angsusingh", )
 Re: Howto Increased performace ?  (Ragnar Hafstað, )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )
  Re: Howto Increased performace ?  (Cosimo Streppone, )
 Re: Howto Increased performace ?  (Ragnar Hafstað, )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )

Iain wrote:

> sort_mem 4096 (=400MB RAM for 100 connections)

If I understand correctly, memory usage related to `sort_mem'
is per connection *and* per sort.
If every client runs a query with 3 sorts in its plan, you are
going to need (in theory) 100 connections * 4Mb * 3 sorts,
which is 1.2 Gb.

Please correct me if I'm wrong...

--
Cosimo



В списке pgsql-performance по дате сообщения:

От: Bruno Wolff III
Дата:
Сообщение: Re: Why so much time difference with a same query/plan?
От: amrit@health2.moph.go.th
Дата:
Сообщение: Low Performance for big hospital server ..