| From: | Ben <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Nathan Wilhelmi <wilhelmi(at)ucar(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Configuration starting point... |
| Date: | 2007-08-10 17:00:55 |
| Message-ID: | Pine.LNX.4.64.0708100958150.27105@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-10 17:10:04 | Re: CREATE RULE on VIEW with INSERT after UPDATE does not work |
| Previous Message | Peter Marius | 2007-08-10 16:53:51 | CREATE RULE on VIEW with INSERT after UPDATE does not work |