Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3F476B5DC0D for ; Mon, 1 Aug 2011 04:31:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 05901-03 for ; Mon, 1 Aug 2011 07:31:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp170.dfw.emailsrvr.com (smtp170.dfw.emailsrvr.com [67.192.241.170]) by mail.postgresql.org (Postfix) with ESMTP id 2650DB5DC12 for ; Mon, 1 Aug 2011 04:31:32 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp7.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id 5380C2581AC; Mon, 1 Aug 2011 03:31:32 -0400 (EDT) X-Virus-Scanned: OK Received: by smtp7.relay.dfw1a.emailsrvr.com (Authenticated sender: adarsh.sharma-AT-orkash.com) with ESMTPSA id ACE82258095 for ; Mon, 1 Aug 2011 03:31:31 -0400 (EDT) Message-ID: <4E365652.9040406@orkash.com> Date: Mon, 01 Aug 2011 13:01:30 +0530 From: Adarsh Sharma User-Agent: Thunderbird 2.0.0.22 (X11/20090625) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: How to Speed up Insert from Multiple Connections Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/2 X-Sequence-Number: 44449 Dear all, I research a lot on Postgresql Performance Tuning and find some parameters to increase the select performance in postgresql. By increasing shared_buffers,effective_cache_size ,work_mem, maintainance etc , we can achieve performance in select queries. But In my application about 200 connections are made to DB server and insert into 2 tables occured. And it takes more than hours to complete. I understand the variable checkpoint_segments & want to know is there any more ways to increase the write performance. Thanks