pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting high performance on huge server
2+ messages / 2 participants
[nested] [flat]
* Setting high performance on huge server
@ 2007-04-04 12:49 ezequias@fastcon.com.br
0 siblings, 1 reply; 2+ messages in thread
From: ezequias@fastcon.com.br @ 2007-04-04 12:49 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Setting high performance on huge server
@ 2007-04-04 12:55 Claus Guttesen <kometen@gmail.com>
parent: ezequias@fastcon.com.br
0 siblings, 0 replies; 2+ messages in thread
From: Claus Guttesen @ 2007-04-04 12:55 UTC (permalink / raw)
To: ezequias@fastcon.com.br <ezequias@fastcon.com.br>; +Cc: pgsql-sql
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-04 12:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-04 12:49 Setting high performance on huge server ezequias@fastcon.com.br
2007-04-04 12:55 ` Claus Guttesen <kometen@gmail.com>
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