Performance Tuning Best Practices for 8 - Mailing list pgsql-general

From Gregory Youngblood
Subject Performance Tuning Best Practices for 8
Date
Msg-id 357EA5F8-85F7-4DCC-A158-E713AD711239@netio.org
Whole thread Raw
List pgsql-general
I've been using postgres off and on since about 1997/98. While I have
my personal theories about tuning, I like to make sure I stay
current. I am about to start a rather thorough, application specific
evaluation of postgresql 8, running on a Linux server (most likely
the newly release Debian Stable).

While I have been running 7.4.x for a while, I have not had much of
an opportunity to really look at 8. Are there any significant
differences or gotchas tuning 8 as compared to 7.4 or older versions?

I was hoping those that have 8 in production environments might share
some of their tuning experiences with me, or point me to useful web
sites or books. Most of the websites and books I've seen on this
topic are from 2003 and 2004, so I was hoping to find something a
little more current.

Thanks,
Greg

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: automating backup ?
Next
From: Michael Fuhr
Date:
Subject: Re: Generate a list of (days/hours) between two dates