Thread: Configuration starting point...
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
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 >
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