"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Every single piece of advice I've seen on shared_buffers comes from the
> 7.x era, when our buffer management was extremely simplistic. IMO all of
> that knowledge was made obsolete when 8.0 came out, and our handling of
> shared_buffers has improved eve
On Tue, Aug 08, 2006 at 08:20:01AM -0400, Christopher Browne wrote:
> I'm not aware of any actual evidence having emerged that it is of any
> value to set shared buffers higher than 1.
http://flightaware.com
They saw a large increase in how many concurrent connections they could
handle when t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
So ...
I have tried different values. The best one for one day sentences seems
to be 24576
IO in vmstat has the lowest values
"id" (idle) has the biggest values.
I have created an script that executes all day sentences to try that.
By the way, could
Quoth [EMAIL PROTECTED] (Ruben Rubio):
> Hi, I have a question with shared_buffer.
>
> Ok, I have a server with 4GB of RAM
> -
> # cat /proc/meminfo
> MemTotal: 4086484 kB
> [...]
> -
>
> So, if I want to, for example, shared_buffer to take 3 GB of RAM then
> shared_buffer would be 393
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I have a question with shared_buffer.
Ok, I have a server with 4GB of RAM
- -
# cat /proc/meminfo
MemTotal: 4086484 kB
[...]
- -
So, if I want to, for example, shared_buffer to take 3 GB of RAM then
shared_buffer would be 393216 (3 *
