Thread: Configuration starting point...

Configuration starting point...

From
Nathan Wilhelmi
Date:
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


Re: Configuration starting point...

From
Ben
Date:
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
>

Re: Configuration starting point...

From
Greg Smith
Date:
On Fri, 10 Aug 2007, Nathan Wilhelmi wrote:

> are the out of the box configs pretty good or are there any recommended
> changes I should be making to start with?

The out of the box configuration is wildly inappropriate for your system,
and there are few examples of something appropriate to point you at--much
of the information floating around is out of date for your class of
hardware.

See http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm for
something current to get you started.  That will lead you to additional
resources you can drill into from there, and includes some disclaimers
about what you should ignore in the guides that haven't been updated
recently.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD