server optimisation

Started by YannicKover 19 years ago3 messagesgeneral
Jump to latest
#1YannicK
yforums@1st-affiliation.com

I'm look for documentation about server optimization.
the only thing I find is QUERY optimization.
there are a lot of parameter in postgresql.conf
no site explain which value is better

#2Richard Huxton
dev@archonet.com
In reply to: YannicK (#1)
Re: server optimisation

YannicK wrote:

I'm look for documentation about server optimization.
the only thing I find is QUERY optimization.
there are a lot of parameter in postgresql.conf
no site explain which value is better

This is a good place to start.
http://www.powerpostgresql.com/PerfList

--
Richard Huxton
Archonet Ltd

#3John Purser
jmpurser@gmail.com
In reply to: Richard Huxton (#2)
Re: server optimisation

On Mon, 07 Aug 2006 11:14:53 +0100
Richard Huxton <dev@archonet.com> wrote:

YannicK wrote:

I'm look for documentation about server optimization.
the only thing I find is QUERY optimization.
there are a lot of parameter in postgresql.conf
no site explain which value is better

This is a good place to start.
http://www.powerpostgresql.com/PerfList

--
Richard Huxton
Archonet Ltd

---------------------------(end of
broadcast)--------------------------- TIP 5: don't forget to increase
your free space map settings

Richard,

EXCELLENT resource. Thank you very much.

John Purser
--
The abuse of greatness is when it disjoins remorse from power.
-- William Shakespeare, "Julius Caesar"