Skip site navigation (1) Skip section navigation (2)

Re: Tuning

From: "John Parnefjord" <John(dot)Parnefjord(at)kib(dot)ki(dot)se>
To: "Ron" <rjpeace(at)earthlink(dot)net>, <pgsql-performance(at)postgresql(dot)org>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>
Subject: Re: Tuning
Date: 2007-01-30 10:05:03
Message-ID: 76C73999206F3145A2E3046A5C32A103F02EA1@kibmail.kib.local (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> What are Oracle and EnterpriseDB recommending for shmmax these days?

According to Oracle "set to a value half the size of physical memory".

I've been talking to an Oracle DBA and he said that they are setting
this to something between 70-80% on a dedicated database server. As long
as one doesn't run other heavy processes and leave room for the OS.

EnterpriseDB advocates: 250 KB + 8.2 KB * shared_buffers + 14.2 kB *
max_connections up to infinity

// John

In response to


  • Re: Tuning at 2007-01-31 17:25:12 from Mischa Sandberg

pgsql-performance by date

Next:From: Rigmor UkuheDate: 2007-01-30 10:21:38
Subject: Re: Partitioning
Previous:From: Richard HuxtonDate: 2007-01-30 10:02:33
Subject: Re: Querying distinct values from a large table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group