Setting high performance on huge server

From: <ezequias(at)fastcon(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Setting high performance on huge server
Date: 2007-04-04 12:49:52
Message-ID: web-48096307@correio2.docasdoporto.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi list,

Could someone give me a little help with my settings ?

How do I increase my performance knowing that my server is a huge server.

Here some parameters I suppose are important on this settings:

"shared_buffers";"8000kB";"Sets the number of shared memory buffers used by
the server."
"max_connections";"100";"Sets the maximum number of concurrent connections."
"work_mem";"1MB";"Sets the maximum memory to be used for query workspaces."

--
Ezequias Rodrigues da Rocha

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Claus Guttesen 2007-04-04 12:55:50 Re: Setting high performance on huge server
Previous Message ezequias 2007-04-04 12:36:02 CPU statistics