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 E3DD79DC991 for ; Wed, 18 Jan 2006 11:41:57 -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 67563-03 for ; Wed, 18 Jan 2006 11:42:01 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.193]) by postgresql.org (Postfix) with ESMTP id 889269DC9AC for ; Wed, 18 Jan 2006 11:41:54 -0400 (AST) Received: by uproxy.gmail.com with SMTP id s2so372128uge for ; Wed, 18 Jan 2006 07:41:58 -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=I0xE1cMZstldul5Q+1+q15TO4Q0RAv4nAfdAdykBHk1q2KMw27n22Y7xMYPFMVOo3+sJG+j2EqaUXrHTntQTy2AYJifpmQm2LL2qA+TygfXxrY/pZBaNVop7F24GKYP2qGQF5qHSgGLWOtQ8sG2pS1nHmVPuhJE1S6RvKd1bXb4= Received: by 10.48.224.19 with SMTP id w19mr427115nfg; Wed, 18 Jan 2006 07:41:57 -0800 (PST) Received: by 10.48.164.6 with HTTP; Wed, 18 Jan 2006 07:41:57 -0800 (PST) Message-ID: <45b42ce40601180741q34553beeu134da075987e8232@mail.gmail.com> Date: Wed, 18 Jan 2006 15:41:57 +0000 From: Harry Jackson To: pgsql-performance@postgresql.org Subject: Re: Suspending SELECTs In-Reply-To: <43CE5AC7.50407@barettadeit.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <43CB71AC.20203@barettadeit.com> <9766.1137433907@sss.pgh.pa.us> <43CD4BD0.9090807@barettadeit.com> <20060117211259.GA13926@mark.mielke.cc> <43CE030E.1070707@barettadeit.com> <20060118143024.GA8402@mark.mielke.cc> <43CE5AC7.50407@barettadeit.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.159 required=5 tests=[AWL=-0.173, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.159 X-Spam-Level: * X-Archive-Number: 200601/297 X-Sequence-Number: 16775 WW91ciBleHBlcmltZW50IG1hZGUgZmFyIHRvbyBtYW55IGFzc3VtcHRpb25zIGFuZCB0aGUgZGF0 YSBkb2VzIG5vdApzdGFuZCB1cCB0byBzY3J1dGlueS4KCk9uIDEvMTgvMDYsIEFsZXNzYW5kcm8g QmFyZXR0YSA8YS5iYXJldHRhQGJhcmV0dGFkZWl0LmNvbT4gd3JvdGU6Cj4gUmVzdWx0czogSSds bCBvbWl0IHRoZSBudW1lcmljYWwgZGF0YSwgd2hpY2ggZXZlcnlvbmUgY2FuIGVhc2lseSBvYnRh aW4gaW4gb25seQo+IGEgZmV3IG1pbnV0ZXMsIHJlcGVhdGluZyB0aGUgZXhwZXJpbWVudC4gSSB1 c2VkIHNldmVyYWwgcXVlcnkgc3RyaW5ncyBjb250YWluaW5nCj4gdmVyeSBjb21tb24gd29yZHMg KCJsaW51eCBkZWJpYW4iLCAibGludXgga2VybmVsIiwgImxpbnV4IHR1eCIpLCBlYWNoIHlpZWxk aW5nCj4gbWlsbGlvbnMgb2YgcmVzdWx0cy4gSSBzZXQgR29vZ2xlIHRvIHJldHJpZXZlIDEwMCBy ZXN1bHRzIHBlciBwYWdlLiBUaGVuIEkgcmFuCj4gdGhlIHF1ZXJ5IGFuZCBwYWdlZCB0aHJvdWdo IHRoZSBkYXRhIHNldC4gVGhlIG9idmlvdXMgcmVzdWx0IGlzIHRoYXQgZXhlY3V0aW9uCj4gdGlt ZSBpcyBhIG1vbm90b25vdXNseSBncm93aW5nIGZ1bmN0aW9uIG9mIHRoZSBwYWdlIG51bWJlci4g VGhpcyBjbGVhcmx5Cj4gaW5kaWNhdGVzIHRoYXQgR29vZ2xlIGRvZXMgbm90IHVzZSBhbnkgYWxn b3JpdGhtIG9mIHRoZSBwcm9wb3NlZCBraW5kLCBidXQKPiByYXRoZXIgYW4gT0ZGU0VUL0xJTUlU IHN0cmF0ZWd5LCB0aHVzIGRpc3Byb3ZpbmcgdGhlIGh5cG90aGVzaXMuCgpJIGp1c3QgcmFuIHRo ZSBzYW1lIHRlc3QgYW5kIEkgZ290IGEgZGlmZmVyZW50IG91dGNvbWUgdGhhbiB5b3UuIFRoZQps YXN0IHBhZ2UgY2FtZSBiYWNrIHR3aWNlIGFzIGZhc3QgYXMgcGFnZSA0LiBJIG5vdGljZWQgbm8g dHJlbmQgaW4gdGhlCnNwZWVkIG9mIHRoZSByZXN1bHRzIGZyb20gZWFjaCBwYWdlLgoKT2YgY291 cnNlIGl0IGlzIHByb2JhYmx5IGluIGNhY2hlIGJlY2F1c2UgaXRzIHN1Y2ggYSBjb21tb24gdGhp bmcgdG8KYmUgc2VhcmNoZWQgb24gc28gdGhlIGV4cGVyaW1lbnQgaXMgcG9pbnRsZXNzLgoKWW91 IGNhbm5vdCBqdW1wIHRvIHlvdXIgY29uY2x1c2lvbnMgYmFzZWQgb24gYSBmZXcgc2VhcmNoZXMg b24gZ29vZ2xlLgoKPiBJdCBtdXN0IGFsc28gYmUgbm90ZWQgdGhhdCBHb29nbGUgcmVmdXNlcyB0 byByZXR1cm4gbW9yZSB0aGFuIDEwMDAgcmVzdWx0cyBwZXIKPiBxdWVyeSwgdGh1cyBpbmRpY2F0 aW5nIHRoYXQgdGhlIHN0cmF0ZWd5IHRoZSBhZG9wdGVkIHF1aXRlIGFwcGFyZW50bHkgY2Fubm90 Cj4gc2NhbGUgaW5kZWZpbml0ZWx5LCBmb3Igb24gYSBxdWVyeSByZXR1cm5pbmcgYSBwb3RlbnRp YWxseSBmbG9vZGluZyBkYXRhc2V0LCBhCj4gdXNlciBwYWdpbmcgdGhyb3VnaCB0aGUgZGF0YSB3 b3VsZCBleHBlcmllbmNlIGEgbGluZWFyIHNsb3dkb3duIG9uIHRoZSBudW1iZXIgb2YKPiBwYWdl cyBhbHJlYWR5IGZldGNoZWQsIGFuZCB0aGUgREJNUyB3b3JrbG9hZCB3b3VsZCBhbHNvIGJlIGxp bmVhciBvbiB0aGUgbnVtYmVyCj4gb2YgZmV0Y2hlZCBwYWdlcy4KClRoZXJlIGFyZSB2YXJpb3Vz IHJlYXNvbiB3aHkgZ29vZ2xlIG1pZ2h0ICB3YW50IHRvIGxpbWl0IHRoZSBzZWFyY2gKcmVzdWx0 IHJldHVybmVkIGllIHRvIGVuY291cmFnZSBwZW9wbGUgdG8gbmFycm93IHRoZWlyIHNlYXJjaC4g UHJldmVudApzY3JlZW4gc2NyYXBlcnMgZnJvbSBoaXR0aW5nIHRoZW0gcmVhbGx5IGhhcmQgYmxh aCBibGFoLiBQZXJoYXBzIGxlc3MKdGhhbiAwLjAwMDAwMDAxJSBvZiByZWFsIHVzZXJzIChub3Qg c2NyYXBlcnMpIGFjdHVhbGx5IGRpZyBkb3duIHRvIHRoZQoxMHRoIHBhZ2Ugc28gd2hhdHMgdGhl IHBvaW50LgoKVGhlcmUgYXJlIG51bWVyb3VzIG1ldGhvZHMgdGhhdCB5b3UgY2FuIHVzZSB0byBn aXZlIHNlcGFyYXRlIHJlc3VsdApwYWdlcyBzb21lIG9mIHdoaWNoIGluY2x1ZGUgZ29pbmcgYmFj ayB0byB0aGUgZGF0YWJhc2UgYW5kIHNvbWUgZG9uJ3QuCkkgcHJlZmVyIG5vdCB0byBnbyBiYWNr IHRvIHRoZSBkYXRhYmFzZSBpZiBJIGNhbiBhdm9pZCBpdCBhbmQgaWYgYWxsCnlvdSB3YW50IHRv IGRvIGlzIHByb3ZpZGUgYSBmZXcgbGlua3MgdG8gZnVydGhlciBwYWdlcyBvZiByZXN1bHRzIHRo ZW4KZ29pbmcgYmFjayB0byB0aGUgZGF0YWJhc2UgYW5kIHVzaW5nIG9mZnNldHMgaXMgYSB3YXN0 ZSBvZiBJTy4KCi0tCkhhcnJ5Cmh0dHA6Ly93d3cuaGphY2tzb24ub3JnCmh0dHA6Ly93d3cudWts dWcuY28udWsK