pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

best starting points....
2+ messages / 2 participants
[nested] [flat]

* best starting points....
@ 2008-07-12 12:03 Jessica Richard <rjessil@yahoo.com>
  2008-07-15 17:22 ` Re: best starting points.... Fernando Ike de Oliveira <fernando.ike@b2br.com.br>
  0 siblings, 1 reply; 2+ messages in thread

From: Jessica Richard @ 2008-07-12 12:03 UTC (permalink / raw)
  To: pgsql-admin

On a new system with 64G memory, what is the best starting points for
shmmax on OS and shared_buffers for Postgres. All databases combined
are about 50G.

I want to evaluate this with the two following scenarios:

1. this machine is running only  Postgres, no other applications

2. this machine has postgres plus some other things (such as web server, etc).

What are the dangers for shmmax and shared_buffers to be confiugred very big for each of the two scenarios?

In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up Postgres (loading almost all dbs into memeory)? 

Thanks,
Jessica


      

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: best starting points....
  2008-07-12 12:03 best starting points.... Jessica Richard <rjessil@yahoo.com>
@ 2008-07-15 17:22 ` Fernando Ike de Oliveira <fernando.ike@b2br.com.br>
  0 siblings, 0 replies; 2+ messages in thread

From: Fernando Ike de Oliveira @ 2008-07-15 17:22 UTC (permalink / raw)
  To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin

Em Sáb, 2008-07-12 às 05:03 -0700, Jessica Richard escreveu:
> On a new system with 64G memory, what is the best starting points for
> shmmax on OS and shared_buffers for Postgres. All databases combined
> are about 50G.
> 
> I want to evaluate this with the two following scenarios:
> 
> 1. this machine is running only  Postgres, no other applications
> 
> 2. this machine has postgres plus some other things (such as web
> server, etc).
> 
> What are the dangers for shmmax and shared_buffers to be confiugred
> very big for each of the two scenarios?
> 
> In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up
> Postgres (loading almost all dbs into memeory)? 
 
   If to use virtually all memory to shared memory, you have concurrency
others process of the SO. Generally webserver is concurrency with
PostgreSQL in Shared Memory, if possible use in other server.


   To initial point, recommends to use 25-40% to shared memory and
shared_buffers with value initial 25%.


   Recommends visit:


- http://wiki.postgresql.org/wiki/Performance_Optimization



Best Regards,
-- 
Fernando Ike de Oliveira <fernando.ike@b2br.com.br>



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-07-15 17:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-12 12:03 best starting points.... Jessica Richard <rjessil@yahoo.com>
2008-07-15 17:22 ` Fernando Ike de Oliveira <fernando.ike@b2br.com.br>

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