X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D46DA9DC896 for ; Mon, 9 Jan 2006 11:40:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87912-07 for ; Mon, 9 Jan 2006 11:40:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.196]) by postgresql.org (Postfix) with ESMTP id 9CC459DC83D for ; Mon, 9 Jan 2006 11:40:27 -0400 (AST) Received: by nproxy.gmail.com with SMTP id i2so245388nfe for ; Mon, 09 Jan 2006 07:40:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jLuQj8wz/7HWIvj5VbQ30b7kMhdMTWoICWSC9GncWrofkLJHRa4i7Ev0pkw+yYa+PbSunh16K0a8tqQA/bF/s9UezlRRSPbgiJNghzf4KYnQGStc14b8FGcAUoEB+hlDFW1xloBT+snAZNRNFOyCsK9/RyWSgbktnHGccfei00w= Received: by 10.48.218.8 with SMTP id q8mr118848nfg; Mon, 09 Jan 2006 07:40:31 -0800 (PST) Received: by 10.48.164.6 with HTTP; Mon, 9 Jan 2006 07:40:31 -0800 (PST) Message-ID: <45b42ce40601090740q29e441ffh6407c38f614d5b50@mail.gmail.com> Date: Mon, 9 Jan 2006 15:40:31 +0000 From: Harry Jackson To: pgsql-performance@postgresql.org Subject: Re: help tuning queries on large database In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <7.0.1.0.2.20060108160633.026bd358@earthlink.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200601/59 X-Sequence-Number: 16537 T24gMS85LzA2LCBLZWxseSBCdXJraGFydCA8a2VsbHkuYnVya2hhcnRAZ21haWwuY29tPiB3cm90 ZToKPiBPbiAxLzgvMDYsIFJvbiA8cmpwZWFjZUBlYXJ0aGxpbmsubmV0PiB3cm90ZToKPiA+IDxz bmlwPgo+ID4gQW1vbmcgdGhlIG90aGVyIHRyaWNrcyBoYXZpbmcgbG90cyBvZiBSQU0gYWxsb3dz Ogo+ID4gSWYgc29tZSBvZiB5b3VyIHRhYmxlcyBhcmUgUmVhZCBPbmx5IG9yIFZFUlkgcmFyZWx5 IHdyaXR0ZW4gdG8sIHlvdQo+ID4gY2FuIHByZWxvYWQgdGhlbSBhdCBib290IHRpbWUgYW5kIG1h a2UgdGhlbSBSQU0gcmVzaWRlbnQgdXNpbmcgdGhlCj4gPiAvZXRjL3RtcGZzIHRyaWNrLgo+Cj4g IFdoYXQgaXMgdGhlIC9ldGMvdG1wZnMgdHJpY2s/CgpJIHRoaW5rIGhlIG1lYW5zIHlvdSBjYW4g Y3JlYXRlIGEgZGlyZWN0b3J5IHRoYXQgbW91bnRzIGFuZCBhcmVhIG9mClJBTS4gSWYgeW91IHB1 dCB0aGUgdGFibGVzIG9uIGl0IHRoZW4gaXQgd2lsbCBiZSB2ZXJ5IGZhc3QuIEkgd291bGQKbm90 IHJlY29tbWVuZCBpdCBmb3IgYW55dGhpbmcgeW91IGNhbm5vdCBhZmZvcmQgdG8gbG9vc2UuCgpJ IGhhdmUgYWxzbyB0cmllZCBpdCBhbmQgZm91bmQgdGhhdCBpdCBkaWQgbm90IHByb2R1Y2UgYXMg Z29vZCBhcwpwZXJmb3JtYW5jZSBhcyBJIGV4cGVjdGVkLgoKLS0KSGFycnkKaHR0cDovL3d3dy5o amFja3Nvbi5vcmcKaHR0cDovL3d3dy51a2x1Zy5jby51awo=