Re: Moving postgresql.conf tunables into 2003...

Список
Период
Сортировка
От Martin Foster
Тема Re: Moving postgresql.conf tunables into 2003...
Дата
Msg-id 3F08EC37.6020303@ethereal-realms.org
обсуждение исходный текст
Ответ на Re: Moving postgresql.conf tunables into 2003...  (Michael Pohl)
Список pgsql-performance
Дерево обсуждения
Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
 Re: Moving postgresql.conf tunables into 2003...  (Rod Taylor, )
  Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
 Re: Moving postgresql.conf tunables into 2003...  ("scott.marlowe", )
  Re: Moving postgresql.conf tunables into 2003...  (Brian Hirt, )
   Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
    Re: Moving postgresql.conf tunables into 2003...  (Matthew Hixson, )
  Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
   Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
    Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
 Re: Moving postgresql.conf tunables into 2003...  ("Michael Mattox", )
  Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
   Re: Moving postgresql.conf tunables into 2003...  (Martin Foster, )
   Re: Moving postgresql.conf tunables into 2003...  (Bruce Momjian, )
 Re: Moving postgresql.conf tunables into 2003...  (Ron, )
 Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
  Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
   Re: Moving postgresql.conf tunables into 2003...  (Rod Taylor, )
   Re: Moving postgresql.conf tunables into 2003...  (Manfred Koizar, )
    Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
     Re: Moving postgresql.conf tunables into 2003...  (Manfred Koizar, )
      Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
       Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
        Index correlation (was: Moving postgresql.conf tunables into 2003... )  (Manfred Koizar, )
     Use of multipart index with "IN"  (Rob Messer, )
      Re: Use of multipart index with "IN"  (Tom Lane, )
 Re: Moving postgresql.conf tunables into 2003...  (Josh Berkus, )
  Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
  Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
  Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
  Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
   Re: Moving postgresql.conf tunables into 2003...  (Josh Berkus, )
    Re: Moving postgresql.conf tunables into 2003...  (Sean Chittenden, )
     Re: Moving postgresql.conf tunables into 2003...  (Josh Berkus, )
   Re: Moving postgresql.conf tunables into 2003...  ("Matthew Nuzum", )
    Re: Moving postgresql.conf tunables into 2003...  (Michael Pohl, )
     Re: Moving postgresql.conf tunables into 2003...  (Martin Foster, )
     Re: Moving postgresql.conf tunables into 2003...  (Bruce Momjian, )
    Re: Moving postgresql.conf tunables into 2003...  (Chris Travers, )
     Re: Moving postgresql.conf tunables into 2003...  ("Jim C. Nasby", )
   Re: Moving postgresql.conf tunables into 2003...  (Andrew Sullivan, )
    Re: Moving postgresql.conf tunables into 2003...  ("Matthew Nuzum", )
     Re: Moving postgresql.conf tunables into 2003...  ("Michael Mattox", )
     Re: Moving postgresql.conf tunables into 2003...  (Tom Lane, )
      Re: Moving postgresql.conf tunables into 2003...  (Kaarel, )
       Re: Moving postgresql.conf tunables into 2003...  ("scott.marlowe", )
        Re: Moving postgresql.conf tunables into 2003...  (Martin Foster, )
  Re: Moving postgresql.conf tunables into 2003...  ("Matthew Nuzum", )
Michael Pohl wrote:
> On Sun, 6 Jul 2003, Matthew Nuzum wrote:
>
>
>>At the very least, if there is good documentation for these parameters,
>>maybe the conf file should provide a link to this info.
>
>
> I believe that is what Josh is proposing:
>
> http://archives.postgresql.org/pgsql-performance/2003-07/msg00102.php
>
>
>>[Apache httpd] uses a three phase (if not more) documentation level.
>>The .conf file contains detailed instructions in an easy to read and
>>not-to-jargon-ish structure.  The docs provide detailed tutorials and
>>papers that expand on configuration params in an easy to read format.
>>Both of these refer to the thorough reference manual that breaks each
>>possible option down into it's nitty gritty details so that a user can
>>get more information if they so desire.
>
>
> I agree that Apache's approach is primo.  Often the .conf comments are
> enough to jog my memory about a directive I haven't used for a while.  Or
> the comments are enough to let me know I don't need a directive, or that I
> need to go to the manual and read more.  I appreciate that.
>
> michael
>


One thing that may also help, is to include more sample .conf files.
For example, you could include settings that would be commonly seen for
decicated databases with generic specs and another with less resources
and not dedicated for use with Postgres.

This would allow users to see how certain setting changes will work.
The default .conf is great if you want to setup a small test bed, but
for a real life example chances are it won't exactly be what your
looking for.

    Martin Foster
    Creator/Designer Ethereal Realms
    


В списке pgsql-performance по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Moving postgresql.conf tunables into 2003...
Следующее
От: "Matthew Nuzum"
Дата:
Сообщение: Re: Moving postgresql.conf tunables into 2003...