Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 16EB92E0139 for ; Mon, 10 Mar 2008 20:22:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 83031-04 for ; Mon, 10 Mar 2008 20:22:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 29CD72E0250 for ; Mon, 10 Mar 2008 20:22:31 -0300 (ADT) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m2ANMqHL026025 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 10 Mar 2008 16:22:52 -0700 Date: Mon, 10 Mar 2008 16:22:31 -0700 From: "Joshua D. Drake" To: Miguel Arroz Cc: Greg Smith , pgsql-performance@postgresql.org Subject: Re: UPDATE 66k rows too slow Message-ID: <20080310162231.6f54c5cd@commandprompt.com> In-Reply-To: References: <879F65BD-D1B0-4D15-BAE3-056305B84474@guiamac.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 10 Mar 2008 16:22:53 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.609 tagged_above=0 required=5 tests=AWL=-2.187, MIME_BASE64_TEXT=2.796 X-Spam-Level: X-Archive-Number: 200803/213 X-Sequence-Number: 29167 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBNb24s IDEwIE1hciAyMDA4IDIzOjE3OjU0ICswMDAwDQpNaWd1ZWwgQXJyb3ogPGFycm96QGd1aWFtYWMu Y29tPiB3cm90ZToNCg0KPiBIaSENCj4gDQo+ICAgIEkgcmVhZCBhbmQgZGlkIG1hbnkgc3R1ZmYg eW91IHBvaW50ZWQgbWUgdG9vLiBSYWlzZWQgc2hhcmVkDQo+IGJ1ZmZlcnMgdG8gMTgwIE1CLCBh bmQgdHJpZWQgYWdhaW4uIFNhbWUgcmVzdWx0cy4NCj4gDQo+ICAgIEkgZGVsZXRlZCB0aGUgREIs IGNyZWF0ZWQgYSBuZXcgb25lIGFuZCBnZW5lcmF0ZWQgbmV3IHRlc3QgZGF0YS4NCj4gSSBrbm93 IGhhdmUgNzJrIHJvd3MsIGFuZCB0aGUgc2FtZSBxdWVyeSBmaW5pc2hlcyBpbi4uLiA5IHNlY29u ZHMuDQo+IA0KPiAgICBJJ20gdG90YWxseSBjbHVlbGVzcy4gQW55d2F5LCB0d28gcXVlc3Rpb25z Og0KPiANCj4gICAgMSkgTXkgd29ya2luZ19tZW0gaXMgMiBNQi4gRG9lcyBhbiBVUERBVEUgcXVl cnkgbGlrZSBtYWluIGRlcGVuZA0KPiBvbiB3b3JraW5nX21lbT8NCj4gDQo+ICAgIDIpIEkgc3Rp bGwgZmVlbCB0aGlzIGlzIGFsbCB2ZXJ5IHRyaWFsLWFuZC1lcnJvci4gQ2hhbmdlIHZhbHVlLA0K PiBydW4gcXVlcnksIGhvcGUgaXQgc29sdmVzIHRoZSBwcm9ibGVtLiBXZWxsLCB0aGUgREIgaXRz ZWxmIGtub3dzIHdoYXQNCj4gaXMgZG9pbmcuIElzbid0IHRoZXJlIGFueSB3YXkgdG8gbWFrZSBp dCB0ZWxsIHVzIHRoYXQ/IExpa2UgInRoZQ0KPiB3b3JraW5nIG1lbSBpcyB0b28gbG93IiBvciBh bnl0aGluZyBlbHNlLiBJIGtub3cgdGhlIHByb2JsZW0gaXMgbm90DQo+IHRoZSBjaGVja3BvaW50 cywgYXQgbGVhc3Qgbm90aGluZyBhcHBlYXJzIG9uIHRoZSBsb2cgcmVsYXRlZCB0byB0aGF0Lg0K PiBCdXQgaXQgaXJyaXRhdGVzIG1lIHRvIGJlIGluIGZyb250IG9mIGEgc3VjaCBjb21wbGV4IHN5 c3RlbSBhbmQgbm90DQo+IGJlaW5nIGFibGUgdG8ga25vdyB3aGF0J3MgZ29pbmcgb24uDQoNCldo YXQgZG9lcyBpb3N0YXQgLWsgMSB0ZWxsIHlvdSBkdXJpbmcgdGhlIDkgc2Vjb25kcyB0aGUgcXVl cnkgaXMNCnJ1bm5pbmc/DQoNCkpvc2h1YSBELiBEcmFrZQ0KDQoNCg0KLSAtLSANClRoZSBQb3N0 Z3JlU1FMIENvbXBhbnkgc2luY2UgMTk5NzogaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS8g DQpQb3N0Z3JlU1FMIENvbW11bml0eSBDb25mZXJlbmNlOiBodHRwOi8vd3d3LnBvc3RncmVzcWxj b25mZXJlbmNlLm9yZy8NCkRvbmF0ZSB0byB0aGUgUG9zdGdyZVNRTCBQcm9qZWN0OiBodHRwOi8v d3d3LnBvc3RncmVzcWwub3JnL2Fib3V0L2RvbmF0ZQ0KICAgICAgUG9zdGdyZVNRTCBwb2xpdGlj YWwgcHVuZGl0IHwgTW9ja2VyIG9mIERvbHBoaW5zDQoNCi0tLS0tQkVHSU4gUEdQIFNJR05BVFVS RS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkgxY0sz QVRiL3pxZlpVVVFSQWhsbEFKOUM5YUw5by80aHpxOXZaeVJhWThKNkRrblA1UUNlUERmUw0KQnhK L3VtclZBclN0VUpnRzNvRllzU0U9DQo9bjB1Qw0KLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0t DQo=