X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6BA9F9FB34D for ; Tue, 5 Sep 2006 12:09:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21268-07 for ; Tue, 5 Sep 2006 12:08:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60521.mail.yahoo.com (web60521.mail.yahoo.com [209.73.178.169]) by postgresql.org (Postfix) with SMTP id ED0719FB361 for ; Tue, 5 Sep 2006 12:08:54 -0300 (ADT) Received: (qmail 20093 invoked by uid 60001); 5 Sep 2006 15:08:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=4y5C2NFeK7t8LC6NVMXEKW4m4Ma4zA6BfV+Nqi0SbhJmmwXr0GROYxMJ5nJQ6roUIyhR3Lc/Uzp21zTysSVGwKdY0Lbd256ubtaG28LCTbfh8zswE98F52MIHtHYy7rjE6C+gZMjxj67KJn9ZUP9UBi2NRrRcwCAJ3M7smFmDB8= ; Message-ID: <20060905150853.20091.qmail@web60521.mail.yahoo.com> Received: from [59.95.40.66] by web60521.mail.yahoo.com via HTTP; Tue, 05 Sep 2006 08:08:53 PDT Date: Tue, 5 Sep 2006 08:08:53 -0700 (PDT) From: nilesh khode Reply-To: nilesh khode Subject: DB Performance Tuning To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-337277415-1157468933=:19734" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.926 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200609/25 X-Sequence-Number: 22939 --0-337277415-1157468933=:19734 Content-Type: text/plain; charset=us-ascii 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 --0-337277415-1157468933=:19734 Content-Type: text/html; charset=us-ascii

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
--0-337277415-1157468933=:19734--