Re: Postgres performance comments from a MySQL user

On Thu, Jun 12, 2003 at 10:15:32AM -0300, Martin Marques wrote:
> You can't expect to have a good DB server if you didn't take the time to
> read the performance tips on the PostgreSQL Administration Guide, and
> gone through the postgresql.conf file.
> The same goes for any server, httpd, MTA, etc. For small load a default
> Apache, or default Postfix will work OK, but on heavy load you have to
> make tuning, or the system will fall to pieces.

Is there a performance section in the *Admin* guide? I only see one in
the user's guide.

Also, something that would be very helpful to document for the
performance settings is: what are the trade-offs? (It would also be
better if there was more documentation on exactly what each setting
did). It's very hard to know if I should up my FSM settings, for
example, because I don't know what the memory trade-off is. In fact,
unless I RTFS, I have very little idea of how FSM even works.

I've added a comment (actually 2, thanks to an errant reload button
click) to
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=runtime-config.html,
hopefully this will help a bit.
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"