On a running production machine, we have 900M configured on a 16G-memory Linux
host. The db size for all dbs combined is about 50G. There are many
transactions going on all the times (deletes, inserts, updates). We do not have
a testing environment that has the same setup and the same amount
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
On Sat, Jul 12, 2008 at 5:30 AM, Jessica Richard [EMAIL PROTECTED] wrote:
On a running production machine, we have 900M configured on a 16G-memory
Linux host. The db size for all dbs combined is about 50G. There are many
transactions going on all the times (deletes, inserts, updates). We do
On Sat, 12 Jul 2008, Jessica Richard wrote:
On a running production machine, we have 900M configured on a 16G-memory Linux host. The
db size for all dbs combined is about 50G. There are many transactions going on all the
times (deletes, inserts, updates). We do not have a testing environment