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
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 d
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 ha
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 of
