Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E847F4BB8EB for ; Wed, 4 Apr 2012 11:11:24 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SFQvf-0001R3-NL for pgsql-admin@postgresql.org; Wed, 04 Apr 2012 14:11:24 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Wed, 04 Apr 2012 09:11:05 -0500 Message-Id: <4F7C10280200002500046B89@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Wed, 04 Apr 2012 09:11:04 -0500 From: "Kevin Grittner" To: "superman0920" , "pgsql-admin" Subject: Re: about multiprocessingmassdata References: <201204041359218166912@gmail.com> In-Reply-To: <201204041359218166912@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201204/14 X-Sequence-Number: 39350 superman0920 wrote: > i have a table which has 8500000 rows record, i run 30 threads to > update the record. > i find the database of processing data speed so slow, per thread > updating 1000 rows need take 260s > How to configure the database to make processing speed faster ? Performance issues are best addressed on the pgsql-performance list, not pgsql-admin. Before posting there, please read the following page so that you can post enough information for people to make useful suggestions: http://wiki.postgresql.org/wiki/SlowQueryQuestions For perspective, in benchmarks on my own machines I have seen complex data-modifying transactions running at 3000 transactions per second, and we have production systems applying millions of complex transactions per day against tables with hundreds of millions of rows while serving web applications running tens of millions of queries. So, my first thought is to wonder what the differences are in your environment, and which of them might be causing problems. To figure that out, I need to know more about your environment. -Kevin