Re: Configuration starting point...

Поиск
Список
Период
Сортировка
Искать
От
Ben
Тема
Re: Configuration starting point...
Дата
Msg-id
Pine.LNX.4.64.0708100958150.27105@localhost.localdomain
Ответ на
Список
Дерево обсуждения
Configuration starting point... Nathan Wilhelmi <wilhelmi@ucar.edu>
Re: Configuration starting point... Greg Smith <gsmith@gregsmith.com>
Re: Configuration starting point... Ben <bench@silentmedia.com>
The out-of-the-box configs are pretty awful for you. Read some 
list archives (from this list and pgsql-performance) and also take a look 
at http://www.powerpostgresql.com/Downloads/annotated_conf_80.html


On Fri, 10 Aug 2007, Nathan Wilhelmi wrote:

> Hello - Just installed 8.2.4 on a Solaris 9 box. It's an 8-way (15000 MHz 
> sparc) with 32GB of ram. We don't know the exact table structure yet or 
> access patterns, although the first thing that will be looked at is a Sesame 
> triple store DB. I would expect that this DB will be more skewed to reads 
> than writes. Based on this, are the out of the box configs pretty good or are 
> there any recommended changes I should be making to start with?
>
> Thanks!
>
> -Nate
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>              http://www.postgresql.org/docs/faq
>
В списке pgsql-general по дате отправления
От: Peter Marius
Дата:
От: Tom Lane
Дата:
FAQ