Re: Configuration starting point... - Mailing list pgsql-general

From Ben
Subject Re: Configuration starting point...
Date
Msg-id Pine.LNX.4.64.0708100958150.27105@localhost.localdomain
Whole thread Raw
In response to Configuration starting point...  (Nathan Wilhelmi <wilhelmi@ucar.edu>)
List pgsql-general
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 by date:

Previous
From: "Peter Marius"
Date:
Subject: CREATE RULE on VIEW with INSERT after UPDATE does not work
Next
From: Tom Lane
Date:
Subject: Re: CREATE RULE on VIEW with INSERT after UPDATE does not work