Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9AE2564FD2A for ; Mon, 3 Nov 2008 21:30:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76737-02 for ; Mon, 3 Nov 2008 21:30:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by mail.postgresql.org (Postfix) with ESMTP id 193F964FD14 for ; Mon, 3 Nov 2008 21:30:52 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id j4so1545181wah.19 for ; Mon, 03 Nov 2008 17:30:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=aT+FdVhdGy4RqEShXSl/o01oswWnpoS2SSQTFy7qpMQ=; b=j0TpSiWQw2+gw62wXnHRx2aVfqB6Zu3+/nhEhF/D4hAnCHswYzavMZlq1IXnsZCNXD YwnhoK76nPREq9dgH9oGzeNRG8QDqtpPe7Lck5+LF603cjurU4D2wMT6Pvujk9vGezKS 7vRE669TcgyEmg1NwT2u95piaVHYLyeqnNDxs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=gaTpo40mvaF92aWL6NIRKETjDmZ6pJLZTHnLso6vIiJEmjwYHiPkd7N0vbmITUjT5H dSm1b3qp35CH21Cy0qKYHFRhBeQax4o+QKXyFt94dlIutNyg+4BqMflKGNDnqwQBkhUT JUA6BeWwHUKP4xpPO0APIKqXH6WsyT1eJBlks= Received: by 10.114.95.1 with SMTP id s1mr500724wab.221.1225762251505; Mon, 03 Nov 2008 17:30:51 -0800 (PST) Received: by 10.114.113.11 with HTTP; Mon, 3 Nov 2008 17:30:51 -0800 (PST) Message-ID: <8a547c840811031730g63edfd2dse6a3a369eefe1700@mail.gmail.com> Date: Mon, 3 Nov 2008 17:30:51 -0800 From: "Tory M Blue" To: "=?UTF-8?B?0JLRltGC0LDQu9GW0Lkg0KLQuNC80YfQuNGI0LjQvQ==?=" Subject: Re: Index bloat, reindex weekly, suggestions etc? Cc: pgsql-performance@postgresql.org In-Reply-To: <331e40660810180000x63b7116dkb2bfbebac4787c2@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <8a547c840810170905m7323dbd8x90de7dd004abc7d4@mail.gmail.com> <331e40660810180000x63b7116dkb2bfbebac4787c2@mail.gmail.com> X-Archive-Number: 200811/1 X-Sequence-Number: 31732 T24gRnJpLCBPY3QgMTcsIDIwMDggYXQgMTE6MDAgUE0sINCS0ZbRgtCw0LvRltC5INCi0LjQvNGH 0LjRiNC40L0gPHRpdnYwMEBnbWFpbC5jb20+IHdyb3RlOgo+Cj4KPiAyMDA4LzEwLzE3IFRvcnkg TSBCbHVlIDx0bWJsdWVAZ21haWwuY29tPgo+Pgo+PiBUaGUgcmVhbCBpc3N1ZSBpcyBteSBpbmRl eCBncm93dGggYW5kIG15IHJlcXVpcmVtZW50IGZvciB3ZWVrbHkKPj4gcmUtaW5kZXhpbmcgICh3 aGljaCBibG9ja3MgYW5kIHRoZXJlZm9yZSBpcyBtb3JlIG9yIGxlc3MgYSBtYW51YWwKPj4gcHJv Y2VzcyBpbiBhIGxpdmUgcHJvZHVjdGlvbiBlbnZpcm9ubWVudCAoZmFpbCBvdmVyLCBjaGFuZ2lu ZyB2aXBzCj4+IGV0YykuCj4KPiBCVFc6IENhbid0IHlvdSBzaW1wbHkgcmVjcmVhdGUgaW5kZXhl cyBvbmxpbmU/IFNpbmNlIHBvc3RncmVzcWwgYWNjZXB0cwo+IG11bHRpcGxlIGluZGV4ZXMgb2Yg c2FtZSBkZWZpbml0aW9uLCB0aGlzIG1heSBsb29rIGxpa2U6Cj4gMSkgY3JlYXRlIGluZGV4IGNv bmN1cnJlbnRseSBpbmRleF9hbHQKPiAyKSBhbmFseXplIGluZGV4X2FsdAo+IDMpIGRyb3AgaW5k ZXhfb3JpZwo+IEJvdGggaW5kZXhfYWx0IGFuZCBpbmRleF9vcmlnIGhhdmluZyBzYW1lIGRlZmlu aXRpb24KClNvcnJ5IGZvciB0aGUgbGF0ZSByZXNwb25zZS4gQWZ0ZXIgc29tZSB0ZXN0aW5nLCB0 aGlzIGlzIGluIGZhY3QgYQpzb2x1dGlvbiB0aGF0IHdpbGwgYW5kIGRvZXMgd29yay4gSXQncyBy ZWFsbHkgbXVjaCBzaW1wbGVyIHRoYW4gZG9pbmcKc3dpdGNoIG92ZXJzIGFuZCB0YWtpbmcgc3lz dGVtcyBkb3duIHRvIHJlIGluZGV4LgoKVGhhbmtzIGZvciB0aGUgY2x1ZSBzdGljayBvdmVyIHRo ZSBoZWFkLCBJIGtub3cgd2UgbG9va2VkIGludG8gdGhpcyBpbgp0aGUgcGFzdCBhbmQgaXQgd2Fz IGEgbm9uIHN0YXJ0ZXIsIGJ1dCBpdCBzZWVtcyB0byBiZSB3b3JraW5nIGp1c3QKZmluZSEhCgpU aGFua3MKClRvcnkuCg==