Tag Archives: database

Memory sizing for PostgreSQL

Posted on March 11, 2008 by kgorman

I needed to make an assessments of a linux server’s memory footprint consumed by postgresql, however, calculating the exact memory footprint of a postgresql database is not as straightforward as one might think. Since unix utilities like top, and ps … Continue reading →

Posted in Database Engineering, PostgreSQL | Tagged , | View Comments

Performance Tuning: Be Proactive

Posted on June 9, 2006 by kgorman

I see many articles out there talking about performance tuning using the Oracle waits interface. While I am not contending that technique; I believe it to be sound, and use this technique every day. What I am saying, is performance … Continue reading →

Posted in Oracle | Tagged | View Comments

The benefits of testing

Posted on May 9, 2006 by kgorman

I was recently involved on a problem for a critical production database that had slow response time for inserts. The batch job inserting was running at full tilt, and adding more processes (concurrency) was not helping. Ah, there must be … Continue reading →

Posted in Random | Tagged | View Comments