Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F33F82E3238 for ; Wed, 9 Jan 2008 12:46:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 03550-01 for ; Wed, 9 Jan 2008 12:46:45 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 0E8362E322E for ; Wed, 9 Jan 2008 12:46:45 -0400 (AST) 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 m09GkpGJ022858 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 9 Jan 2008 08:46:51 -0800 Date: Wed, 9 Jan 2008 08:50:58 -0800 From: "Joshua D. Drake" To: Alan Hodgson Cc: pgsql-performance@postgresql.org Subject: Re: big database performance Message-ID: <20080109085058.7be38287@commandprompt.com> In-Reply-To: <200801090816.48859@hal.medialogik.com> References: <4784835A.8070604@careerjunction.co.za> <47848575.8000007@commandprompt.com> <4784C3B5.9060108@careerjunction.co.za> <200801090816.48859@hal.medialogik.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]); Wed, 09 Jan 2008 08:46:52 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/43 X-Sequence-Number: 28282 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBXZWQs IDkgSmFuIDIwMDggMDg6MTY6NDggLTA4MDANCkFsYW4gSG9kZ3NvbiA8YWhvZGdzb25Ac2lta2lu LmNhPiB3cm90ZToNCg0KPiBPbiBXZWRuZXNkYXkgMDkgSmFudWFyeSAyMDA4LCBBZHJpYW4gTW9p c2V5DQo+IDxhZHJpYW5AY2FyZWVyanVuY3Rpb24uY28uemE+IHdyb3RlOg0KPiA+DQo+ID4gQWxz bywgd2UncmUgcnVubmluZyB0aGUgZGIgb24gZXh0MyB3aXRoIG5vYXRpbWUuICAgU2hvdWxkIEkg bG9vayBhdA0KPiA+IGNoYW5naW5nIG9yIGdldHRpbmcgcmlkIG9mIGpvdXJuYWxpbmcgPw0KPiAN Cj4gTm8gKHVubGVzcyB5b3UgbGlrZSByZWFsbHkgbG9uZyBmc2NrIHRpbWVzKS4gZGF0YT13cml0 ZWJhY2sgaXMgc2FmZQ0KPiB3aXRoIFBvc3RncmVTUUwsIHRob3VnaC4NCj4gDQoNCkV4Y2VwdCA6 KS4uLiBmb3IgcGdfeGxvZy4gSWYgeW91IGhhdmUgcGdfeGxvZyBvbiBhIGRpZmZlcmVudCBwYXJ0 aXRpb24sDQpmZWVsIGZyZWUgdG8gcnVuIGV4dDIgZm9yIGl0Lg0KDQpKb3NodWEgRC4gRHJha2UN Cg0KPiANCj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKGVuZCBvZg0KPiBicm9hZGNhc3Qp LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tIFRJUCA3OiBZb3UgY2FuIGhlbHAgc3VwcG9ydCB0 aGUNCj4gUG9zdGdyZVNRTCBwcm9qZWN0IGJ5IGRvbmF0aW5nIGF0DQo+IA0KPiAgICAgICAgICAg ICAgICAgaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9hYm91dC9kb25hdGUNCj4gDQoNCg0KLSAt LSANClRoZSBQb3N0Z3JlU1FMIENvbXBhbnk6IFNpbmNlIDE5OTcsIGh0dHA6Ly93d3cuY29tbWFu ZHByb21wdC5jb20vIA0KU2FsZXMvU3VwcG9ydDogKzEuNTAzLjY2Ny40NTY0ICAgMjR4Ny9FbWVy Z2VuY3k6ICsxLjgwMC40OTIuMjI0MA0KRG9uYXRlIHRvIHRoZSBQb3N0Z3JlU1FMIFByb2plY3Q6 IGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvYWJvdXQvZG9uYXRlDQpTRUxFQ1QgJ1RyYWluaW5n JywgJ0NvbnN1bHRpbmcnIEZST00gdmVuZG9yIFdIRVJFIG5hbWUgPSAnQ01EJw0KDQoNCi0tLS0t QkVHSU4gUEdQIFNJR05BVFVSRS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51 eCkNCg0KaUQ4REJRRkhoUHR5QVRiL3pxZlpVVVFSQWszMkFLQ1R2SlBCQ3ZIdGI0SldNdTcreHd4 UVpkQS9aUUNnbjNLMg0KcENtY1VYQWlBaWJMa1RnRXdHVlhQeVE9DQo9SDJiSw0KLS0tLS1FTkQg UEdQIFNJR05BVFVSRS0tLS0tDQo=