Re: postgres 7.4 at 100%

От: Doug McNaught
Тема: Re: postgres 7.4 at 100%
Дата: ,
Msg-id: 87llia78dj.fsf@asmodeus.mcnaught.org
(см: обсуждение, исходный текст)
Ответ на: postgres 7.4 at 100%  (Chris Cheston)
Ответы: Re: postgres 7.4 at 100%  ("Joshua D. Drake")
Список: pgsql-performance

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

postgres 7.4 at 100%  (Chris Cheston, )
 Re: postgres 7.4 at 100%  (Richard Huxton, )
  Re: postgres 7.4 at 100%  (Chris Cheston, )
 Re: postgres 7.4 at 100%  (Doug McNaught, )
  Re: postgres 7.4 at 100%  ("Joshua D. Drake", )
   Re: postgres 7.4 at 100%  (Chris Cheston, )
    Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
     Re: postgres 7.4 at 100%  (Frank Knobbe, )
      Re: postgres 7.4 at 100%  (Tom Lane, )
       Re: postgres 7.4 at 100%  (Josh Berkus, )
        Re: postgres 7.4 at 100%  (Chris Cheston, )
         Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
          Re: postgres 7.4 at 100%  (Chris Cheston, )
           Re: postgres 7.4 at 100%  (Bruno Wolff III, )
           Re: postgres 7.4 at 100%  ("Gavin M. Roy", )
            Re: postgres 7.4 at 100%  (Chris Cheston, )
             Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
              Re: postgres 7.4 at 100%  (Chris Cheston, )
               Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
         Re: postgres 7.4 at 100%  (Tom Lane, )
      Re: postgres 7.4 at 100%  (Josh Berkus, )
       Re: postgres 7.4 at 100%  (Frank Knobbe, )
        Re: postgres 7.4 at 100%  (Josh Berkus, )
 Re: postgres 7.4 at 100%  (Duane Lee - EGOVX, )

Chris Cheston <> writes:

> shared_buffers = 40             # min 16, at least max_connections*2, 8KB each

This is ridiculously low for any kind of production server.  Try
something like 5000-10000 for a start.

-Doug


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

От: Tom Lane
Дата:
Сообщение: Re: How can one see what queries are running withing a
От: Chris Cheston
Дата:
Сообщение: Re: postgres 7.4 at 100%