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 B087F9DCC10 for ; Fri, 16 Dec 2005 09:38:30 -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 22041-04 for ; Fri, 16 Dec 2005 09:38:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.200]) by postgresql.org (Postfix) with ESMTP id 2E8579DCBBD for ; Fri, 16 Dec 2005 09:38:26 -0400 (AST) Received: by nproxy.gmail.com with SMTP id o63so248462nfa for ; Fri, 16 Dec 2005 05:38:25 -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=CH06uw5m04NoqciMLwpnSe//WTYnohDyTgZB1ilSUV1D7GDcfLQkJGW0z+f0Yh0jKgM7AxOBfmXVQq1wkK4adSOk+CSLGgAVfA7mlnYWeKe+Figfybjt/aSE0D4WrWScEtoSRsMBhFVt57k010/eXs/jTYbuBvXw1k1kLfyqIHs= Received: by 10.48.225.15 with SMTP id x15mr11945nfg; Fri, 16 Dec 2005 05:38:24 -0800 (PST) Received: by 10.48.164.6 with HTTP; Fri, 16 Dec 2005 05:38:24 -0800 (PST) Message-ID: <45b42ce40512160538n7b77a2aexe9d13616f6c25a69@mail.gmail.com> Date: Fri, 16 Dec 2005 13:38:24 +0000 From: Harry Jackson To: pgsql-performance@postgresql.org Subject: Re: Crashing DB or Server? In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/393 X-Sequence-Number: 16214 T24gMTIvMTYvMDUsIE1vcml0eiBCYXllciA8bW9yaXR6LmJheWVyQGdvb2dsZW1haWwuY29tPiB3 cm90ZToKPiAgVGhpcyBpcyByZWFsbHkgd2VpcmQsIGp1c3QgYSBmZXcgaG91cnMgYWdvIHRoZSBt YWNoaW5lIHJ1biB2ZXJ5IHNtb290aAo+IHNlcnZpbmcgdGhlIGRhdGEgZm9yIGEgYmlnIHBvcnRh bC4KCkNhbiB5b3UgbG9nIHRoZSBzdGF0ZW1lbnRzIHRoYXQgYXJlIHRha2luZyBhIGxvbmcgdGlt ZSBhbmQgcG9zdCB0aGVtCnRvIHRoZSBsaXN0IHdpdGggdGhlIHRhYmxlIHN0cnVjdHVyZXMgYW5k IGluZGV4ZXMgZm9yIHRoZSB0YWJsZXMgYmVpbmcKdXNlZC4KClRvIGRvIHRoaXMgdHVybiBvbiBs b2dnaW5nIGZvciBzdGF0ZW1lbnRzIHRha2luZyBhIGxvbmcgdGltZSwgZWRpdApwb3N0Z3Jlc3Fs LmNvbmYgZmlsZSBhbmQgY2hhbmdlIHRoZSBmb2xsb3dpbmcgdHdvIHBhcmFtZXRlcnMuCgpsb2df bWluX2R1cmF0aW9uX3N0YXRlbWVudCA9IDIwMDAgIyAyIHNlY29uZHMKCllvdXIgbG9nIHNob3Vs ZCBub3cgYmUgY2F0Y2hpbmcgdGhlIHN0YXRlbWVudHMgdGhhdCBhcmUgc2xvdy4gVGhlbiB1c2UK dGhlIHN0YXRlbWVudHMgdG8gZ2V0IHRoZSBleHBsYWluIHBsYW4gaWUKCmRibmFtcj0jIGV4cGxh aW4gW3NxbCB0aGF0cyB0YWtpbmcgYSBsb25nIHRpbWVdCgpXZSB3b3VsZCBhbHNvIG5lZWQgdG8g c2VlIHRoZSB0YWJsZSBzdHJ1Y3R1cmVzLgoKZGJuYW1lPSMgXGQgW3RhYmxlIG5hbWUgb2YgZWFj aCB0YWJsZSBpbiBhYm92ZSBleHBsYWluIHBsYW5dCgo+ICBIYXMgYW55Ym9keSBhbiBpZGVhIHdo YXQgbWlnaHQgaGF2ZSBoYXBwZW5lZCBoZXJlPwo+ICBJIG5lZWQgYSBxdWljayBzb2x1dGlvbiwg c2luY2UgSSdtIHRhbGtpbmcgYWJvdXQgYW4gbGl2ZSBzZXJ2ZXIgdGhhdCBzaG91bGQKPiBiZSBy dW5uaW5nIDI0IGhvdXJzIGEgZGF5LgoKSXQgbWF5IGJlIHRoYXQgdGhlIHBsYW5uZXIgaGFzIHN0 YXJ0ZWQgdG8gcGljayBhIGJhZCBwbGFuLiBUaGlzIGNhbgpoYXBwZW4gaWYgdGhlIGRhdGFiYXNl IGlzIHJlZ3VsYXJseSBjaGFuZ2luZyBhbmQgdGhlIHN0YXRzIGFyZSBub3QgdXAKdG8gZGF0ZS4g SSBiZWxpZXZlIGl0IGNhbiBoYXBwZW4gZXZlbiBpZiB0aGUgc3RhdHMgYXJlIHVwIHRvIGRhdGUg YnV0CmlzIG11Y2ggbGVzcyBsaWtlbHkgdG8gZG8gc28uCgpJdCBtaWdodCBhbHNvIGJlIGFuIGlk ZWEgdG8gdmFjdXVtIHRoZSBkYXRhYmFzZS4KCmRibmFtZT0jIFZBQ1VVTSBBTkFMWVpFOwoKVGhp cyB3aWxsIGxvYWQgdGhlIHNlcnZlciB1cCBmb3IgYSB3aGlsZSB0aG91Z2guCgotLQpodHRwOi8v d3d3LmhqYWNrc29uLm9yZwpodHRwOi8vd3d3LnVrbHVnLmNvLnVrCg==