From: Claus Guttesen <kometen@gmail.com>
To: ezequias@fastcon.com.br <ezequias@fastcon.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: Setting high performance on huge server
Date: Wed, 4 Apr 2007 14:55:50 +0200
Message-ID: <b41c75520704040555j10ab95f5m580510bd2fc27e8@mail.gmail.com> (raw)
In-Reply-To: <web-48096307@correio2.docasdoporto.com.br>
References: <web-48096307@correio2.docasdoporto.com.br>
> 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."
Do you have some hardware-specifications, ie. how much ram, cpu-type etc.?
regards
Claus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kometen@gmail.com, ezequias@fastcon.com.br
Subject: Re: Setting high performance on huge server
In-Reply-To: <b41c75520704040555j10ab95f5m580510bd2fc27e8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox