Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 7DA844BB8E5
	for <pgsql-admin@postgresql.org>; Wed,  4 Apr 2012 02:59:47 -0300 (ADT)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <superman0920@gmail.com>) id 1SFJFw-0001Xg-IC
	for pgsql-admin@postgresql.org; Wed, 04 Apr 2012 05:59:46 +0000
Received: by dadz9 with SMTP id z9so582983dad.33
	for <pgsql-admin@postgresql.org>; Tue, 03 Apr 2012 22:59:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=date:from:to:reply-to:subject:x-priority:x-guid:x-has-attach
	:x-mailer:mime-version:message-id:content-type;
	bh=OslCD6wPX2/n+4MWKTUlIFWa3ZAEki153S2ybCgobYU=;
	b=kkcqdCxfgpRtOiCjbdhn+kCxp88dHTcmtHq52neikGssFu+JIkY2m9G7PQRK8aucWs
	P9ohrmLPdw40fkgv+34OiUS4Dnawz/z3qDFyBAcZqhOcEKAI/qsW5xRFHxbY5B2tXY3u
	QGJtAcHQcXUrwPkIaH5papk5fXNdxS4rrr/iz/F86ybTZmBvtCnX//4aCdyUfMLK3h92
	ybJWAKfGxxqp2qQiPm1H9m2ZVMOnip4gomDMVLjlpyaZsgqWkFKK3Bvh/itNo6F9EyCX
	63dg0lRfk/ZkMdxZbIp+6Qh/FcDW5n2BZ2fVJOcUeqS+uFEr/f0tb9L196Jy4HU7r1x1
	EdRQ==
Received: by 10.68.219.225 with SMTP id pr1mr3560232pbc.63.1333519170788;
	Tue, 03 Apr 2012 22:59:30 -0700 (PDT)
Received: from imsuperman-PC ([113.224.202.112])
	by mx.google.com with ESMTPS id z1sm17891368pbc.38.2012.04.03.22.59.24
	(version=SSLv3 cipher=OTHER); Tue, 03 Apr 2012 22:59:30 -0700 (PDT)
Date: Wed, 4 Apr 2012 13:59:30 +0800
From: superman0920 <superman0920@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Reply-To: superman0920 <superman0920@gmail.com>
Subject: about multiprocessingmassdata
X-Priority: 3
X-GUID: AD2E2813-814A-48FE-B123-7C3C8B89AD33
X-Has-Attach: no
X-Mailer: Foxmail 7.0.1.88[cn]
Mime-Version: 1.0
Message-ID: <201204041359218166912@gmail.com>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart462157512730_=----"
X-Pg-Spam-Score: -2.4 (--)
X-Archive-Number: 201204/9
X-Sequence-Number: 39345

This is a multi-part message in MIME format.

------=_001_NextPart462157512730_=----
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: base64

aGkgDQppIGhhdmUgYSB0YWJsZSB3aGljaCBoYXMgODUwMDAwMCByb3dzIHJlY29yZCwgaSBydW4g
MzAgdGhyZWFkcyB0byB1cGRhdGUgdGhlIHJlY29yZC4NCmkgZmluZCB0aGUgZGF0YWJhc2Ugb2Yg
cHJvY2Vzc2luZyBkYXRhIHNwZWVkIHNvIHNsb3csIHBlciB0aHJlYWQgdXBkYXRpbmcgMTAwMCBy
b3dzIG5lZWQgdGFrZSAyNjBzDQpIb3cgdG8gY29uZmlndXJlIHRoZSBkYXRhYmFzZSB0byBtYWtl
IHByb2Nlc3Npbmcgc3BlZWQgZmFzdGVyID8gDQpQbGVhc2UgaGVscCB+fg0KDQoNCg0KDQpzdXBl
cm1hbjA5MjA=

------=_001_NextPart462157512730_=----
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dgb2312" http-equiv=3DContent-Type>
<STYLE>
BLOCKQUOTE {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
P {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
BODY {
	LINE-HEIGHT: 1.5; FONT-FAMILY: =CE=A2=C8=ED=D1=C5=BA=DA; COLOR: #000000; =
FONT-SIZE: 10.5pt
}
</STYLE>

<META name=3DGENERATOR content=3D"MSHTML 9.00.8112.16441"></HEAD>
<BODY style=3D"MARGIN: 10px">
<DIV>hi </DIV>
<DIV>i have a table which has 8500000 rows record, i run 30 threads to upd=
ate=20
the record.</DIV>
<DIV>i find the database of processing data speed so slow, per thread upda=
ting=20
1000 rows need take 260s</DIV>
<DIV>How to configure the database to make processing speed faster ? </DIV=
>
<DIV>Please help ~~</DIV>
<DIV>&nbsp;</DIV>
<HR style=3D"WIDTH: 210px; HEIGHT: 1px" align=3Dleft color=3D#b5c4df SIZE=
=3D1>

<DIV><SPAN>superman0920</SPAN></DIV></BODY></HTML>

------=_001_NextPart462157512730_=------