Re: Increasing GROUP BY CHAR columns speed

От: Andrus
Тема: Re: Increasing GROUP BY CHAR columns speed
Дата: ,
Msg-id: 8553B7AAE7294B4BAB18B759978ECD24@andrusnotebook
(см: обсуждение, исходный текст)
Ответ на: Re: Increasing GROUP BY CHAR columns speed  (Scott Carey)
Список: pgsql-performance

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

Increasing GROUP BY CHAR columns speed  ("Andrus", )
 Re: Increasing GROUP BY CHAR columns speed  (Scott Carey, )
  Re: Increasing GROUP BY CHAR columns speed  ("Andrus", )
   Re: Increasing GROUP BY CHAR columns speed  ("Scott Marlowe", )
    Re: Increasing GROUP BY CHAR columns speed  (Scott Carey, )
     Re: Increasing GROUP BY CHAR columns speed  ("Andrus", )
     Re: Increasing GROUP BY CHAR columns speed  ("Andrus", )
     Re: Increasing GROUP BY CHAR columns speed  ("Scott Marlowe", )
     Re: Increasing GROUP BY CHAR columns speed  ("Andrus", )
      Re: Increasing GROUP BY CHAR columns speed  ("Greg Stark", )
 Re: Increasing GROUP BY CHAR columns speed  ("Andrus", )

Application should work with any server starting at 8.1 with any RAM size
(probably starting at 1 GB).

How to find safe value which does not cause error in SET work_mem command ?

If I use 2 GB maybe this can cause excaption when running in server with 1
GB RAM where this setting may be not allowed.

Andrus.



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

От: "Kevin Grittner"
Дата:
Сообщение: Re: Memory Allocation
От: "Andrus"
Дата:
Сообщение: Re: Increasing GROUP BY CHAR columns speed