Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 Jan 2007 11:05:03 +0100
> What are Oracle and EnterpriseDB recommending for shmmax these days? According to Oracle "set to a value half the size of physical memory". [http://www.oracle.com/technology/tech/linux/validated-configurations/ht ml/vc_dell6850-rhel4-cx500-1_1.html] 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 [http://www.enterprisedb.com/documentation/kernel-resources.html] // John
- References:
- Tuning
- From: John Parnefjord
- Re: Tuning
- From: Josh Berkus
- Re: Tuning
- From: Ron
- Tuning
- Prev by Date: Re: Querying distinct values from a large table
- Next by Date: Re: Partitioning
- Previous by thread: Re: Tuning
- Next by thread: Seqscan/Indexscan still a known issue?
- Indexes: