Re: Howto Increased performace ?

От: Iain
Тема: Re: Howto Increased performace ?
Дата: ,
Msg-id: 00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb
(см: обсуждение, исходный текст)
Ответ на: Howto Increased performace ?  ("Amrit Angsusingh")
Список: 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", )

Hi,

> #sort_mem = 1024 # min 64, size in KB
> sort_mem = 60000

I think this might be too much. You are using 60000KB _per connection_ here
= 10GB for your maximum of 180 connections.

By comparison, I am specifiying 4096 (subject to adjustment) for a machine
with a similar spec to yours.

regards
Iain






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

От: "Iain"
Дата:
Сообщение: Re: Howto Increased performace ?
От: "Iain"
Дата:
Сообщение: Re: Howto Increased performace ?