Hi All;
We're talking with a HW / Data Center company about scaling up our DB
servers... Below are some questions they asked relaed to moving to SSD's
or maybe a Fusion IO drive.
Anyone have any thoughts, specifically on the queue depth question?
Thanks in advance...
/So our question I thi
The doc "PostgreSQL Hardware Performance Tuning" by Bruce Momjian, 16th
January 2003 says: "As a start for tuning, use 25% of RAM for cache size,
and 2-4% for sort size.", and "The default POSTGRESQL conguration allocates
64 shared buffers. Each buffer is 8 kilobytes.".
Have I understood it corr
I need to update that. 7.4 will use many more shared buffers by
default.
Yes, they are very small because we want to start even on small machines.
---
Knut P. Lehre wrote:
> The doc "PostgreSQL Hardware Performance Tuning"
