DB Performance Tuning

From: nilesh khode <nilesh_khode(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: DB Performance Tuning
Date: 2006-09-05 15:08:53
Message-ID: 20060905150853.20091.qmail@web60521.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I am working on database performace tuning on Postgresql 8.1 database build on Suse 10 Linux dedicated server. I am having 32 GB of RAM and 8 CPUs.

I have made minimum recommended settings under postgresql.conf (i.e shared_buffer, work_mem, and effective cache_size also kernel.shmmax)

I have run SQL queries using pg-admin, the query execution + retrieval time is 80% reduced over existing server.
But same I tested with JDBC, the query requires more time as compared with existing server.

Please help me out in this performance tuning.

Regards,
Nilesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message romje 2006-09-05 15:24:31 Re: DB Performance Tuning
Previous Message Magnus Hagander 2006-09-05 14:42:02 Re: Automating pg-admin