Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B82422E0164 for ; Mon, 10 Mar 2008 20:56:44 -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 93993-01 for ; Mon, 10 Mar 2008 20:56:35 -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 E4F312E01D5 for ; Mon, 10 Mar 2008 20:56:41 -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 m2ANv2Vr028756 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 10 Mar 2008 16:57:02 -0700 Date: Mon, 10 Mar 2008 16:56:41 -0700 From: "Joshua D. Drake" To: Miguel Arroz Cc: Greg Smith , pgsql-performance@postgresql.org Subject: Re: UPDATE 66k rows too slow Message-ID: <20080310165641.333d5a3e@commandprompt.com> In-Reply-To: References: <879F65BD-D1B0-4D15-BAE3-056305B84474@guiamac.com> <20080310162231.6f54c5cd@commandprompt.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:57:02 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.611 tagged_above=0 required=5 tests=AWL=-2.185, MIME_BASE64_TEXT=2.796 X-Spam-Level: X-Archive-Number: 200803/215 X-Sequence-Number: 29169 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBNb24s IDEwIE1hciAyMDA4IDIzOjQ2OjEwICswMDAwDQpNaWd1ZWwgQXJyb3ogPGFycm96QGd1aWFtYWMu Y29tPiB3cm90ZToNCiAgICAgICAgdHR5ICAgICAgICAgICAgIGFkNCAgICAgICAgICAgICAgYWQ2 ICAgICAgICAgICAgIGNwdQ0KPiAgIHRpbiB0b3V0ICBLQi90IHRwcyAgTUIvcyAgIEtCL3QgdHBz ICBNQi9zICB1cyBuaSBzeSBpbiBpZA0KPiAgICAgMCAgIDYwIDMzLjQ4IDQ0OSAxNC42NiAgIDAu MDAgICAwICAwLjAwICAxMSAgMCAgMyAgMCA4Ng0KPiAgICAgMCAgMTgwIDE2Ljg1IDU5OSAgOS44 NyAgIDAuMDAgICAwICAwLjAwICAgMSAgMCAgMSAgMCA5OA0KPiAgICAgMCAgIDYwIDU1LjM3IDQ1 NSAyNC41OCAgIDAuMDAgICAwICAwLjAwICAyNSAgMCAgNCAgMSA2OQ0KPiAgICAgMCAgIDYwIDQ5 LjgzIDM3NiAxOC4yOCAgIDAuMDAgICAwICAwLjAwICAxOCAgMCAgNSAgMSA3Ng0KPiAgICAgMCAg IDYwIDI5Ljg2IDM2MyAxMC41OCAgIDAuMDAgICAwICAwLjAwICAgMyAgMCAgMCAgMSA5Ng0KPiAg ICAgMCAgIDYwIDM2LjIxIDM2NSAxMi45MCAgIDAuMDAgICAwICAwLjAwICAxMiAgMCAgMyAgMSA4 NA0KPiAgICAgMCAgIDYwIDMzLjEzIDM1MyAxMS40MSAgIDAuMDAgICAwICAwLjAwICAgMiAgMCAg MiAgMCA5Ng0KPiAgICAgMCAgIDYwIDM5LjQ3IDM0NSAxMy4yOCAgIDAuMDAgICAwICAwLjAwICAx NiAgMCAgMyAgMCA4MA0KPiAgICAgMCAgIDYwIDQwLjQ4IDM2MyAxNC4zNCAgIDAuMDAgICAwICAw LjAwICAgOCAgMCAgMiAgMCA4OQ0KPiAgICAgMCAgIDYwIDMwLjkxIDM5NyAxMS45NyAgIDAuMDAg ICAwICAwLjAwICAgNSAgMCAgMiAgMCA5Mw0KPiAgICAgMCAgIDYwIDE4LjIxIDYwNCAxMC43NSAg IDAuMDAgICAwICAwLjAwICAgNSAgMCAgMiAgMCA5Mw0KPiAgICAgMCAgIDYwIDQ4LjY1IDM1OSAx Ny4wNCAgIDAuMDAgICAwICAwLjAwICAyMCAgMCAgNiAgMCA3NA0KPiAgICAgMCAgIDYwIDMyLjkx IDM3NSAxMi4wNCAgIDAuMDAgICAwICAwLjAwICAxMCAgMCAgNCAgMCA4Ng0KPiAgICAgMCAgIDYw IDM1LjgxIDMzOSAxMS44NCAgIDAuMDAgICAwICAwLjAwICAgMyAgMCAgMiAgMCA5Ng0KPiAgICAg MCAgIDYwIDMzLjM4IDM5NCAxMi44MyAgIDAuMDAgICAwICAwLjAwICAxMSAgMCAgNCAgMCA4NQ0K PiAgICAgMCAgIDYwIDM0LjQwIDMxMyAxMC41MSAgIDAuMDAgICAwICAwLjAwICAgNCAgMCAgMiAg MCA5Mw0KPiAgICAgMCAgIDYwIDQ1LjY1IDM1OCAxNS45NCAgIDAuMDAgICAwICAwLjAwICAxOSAg MCAgNyAgMCA3NA0KPiAgICAgMCAgIDYwIDM3LjQxIDMwOSAxMS4yOCAgIDAuMDAgICAwICAwLjAw ICAgMyAgMCAgMiAgMCA5NQ0KPiAgICAgMCAgIDYwIDMyLjYxIDQ0NyAxNC4yMiAgIDAuMDAgICAw ICAwLjAwICAxMCAgMCAgMyAgMSA4Ng0KPiAgICAgMCAgIDYwIDE3LjExIDUxNiAgOC42MyAgIDAu MDAgICAwICAwLjAwICAgMSAgMCAgMSAgMCA5OA0KPiANCj4gICAgVGhlcmUncyBzdXJlbHkgYSBs b3Qgb2YgZGlzayBhY3Rpdml0eSBnb2luZyBvbi4gV2l0aCB0aGlzDQo+IGZpZ3VyZXMsIEkgY291 bGQgaGF2ZSB3cml0dGVuIHNvbWUgaHVuZHJlZCBnaWdhYnl0ZXMgZHVyaW5nIHRoZQ0KPiBxdWVy eSBleGVjdXRpb24hIFNvbWV0aGluZyBpcyBkZWZpbml0ZWx5IG5vdCByaWdodCBoZXJlLg0KDQoN CldlbGwgdGhlIGFib3ZlIHNheXMgeW91IGFyZSBnZXR0aW5nIH4gMTAtMTVNQi9zIGEgc2Vjb25k IHBlcmZvcm1hbmNlLg0KV2hhdCBpcyB0aGUgZGlzayBzdWJzeXN0ZW0geW91IGhhdmUuIEFsc28g bm90ZSB0aGF0IHRoZSBkdXJhdGlvbg0KcHJvYmFibHkgd2VudCB1cCBiZWNhdXNlIHlvdSBkaWRu J3QgdmFjdXVtIGJldHdlZW4gdGVzdHMuDQoNCldoYXQgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMIChJ IG1pc3NlZCBpdCkuDQoNCkpvc2h1YSBELiBEcmFrZSANCg0KDQoNCi0gLS0gDQpUaGUgUG9zdGdy ZVNRTCBDb21wYW55IHNpbmNlIDE5OTc6IGh0dHA6Ly93d3cuY29tbWFuZHByb21wdC5jb20vIA0K UG9zdGdyZVNRTCBDb21tdW5pdHkgQ29uZmVyZW5jZTogaHR0cDovL3d3dy5wb3N0Z3Jlc3FsY29u ZmVyZW5jZS5vcmcvDQpEb25hdGUgdG8gdGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9hYm91dC9kb25hdGUNCiAgICAgIFBvc3RncmVTUUwgcG9saXRpY2Fs IHB1bmRpdCB8IE1vY2tlciBvZiBEb2xwaGlucw0KDQotLS0tLUJFR0lOIFBHUCBTSUdOQVRVUkUt LS0tLQ0KVmVyc2lvbjogR251UEcgdjEuNC42IChHTlUvTGludXgpDQoNCmlEOERCUUZIMWNxNUFU Yi96cWZaVVVRUkFoVnZBS0NmUWs0TWc2cUxOUWZjNnV5aUkyVEJTYmtUaEFDZUsvNWsNClRnYzls dHhvT3ZuVE16S0cyaEcvNExZPQ0KPVRtNE4NCi0tLS0tRU5EIFBHUCBTSUdOQVRVUkUtLS0tLQ0K