Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5DF471337B61 for ; Sat, 23 Apr 2011 12:45:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 34265-01 for ; Sat, 23 Apr 2011 15:44:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com [209.85.216.46]) by mail.postgresql.org (Postfix) with ESMTP id 7647B1337B47 for ; Sat, 23 Apr 2011 12:44:59 -0300 (ADT) Received: by qwk3 with SMTP id 3so558181qwk.19 for ; Sat, 23 Apr 2011 08:44:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:date:subject:message-id:from:to:content-type :content-transfer-encoding; bh=wD6seW5J6tXzhlIRAo+W9/wV+LmR6XEIajTepT8fPb0=; b=bPlzm3w1PdiKKeIqlntTYvMzLVFdVJj3log+NjLIWwIcGZGFD2fDI8DgZowgp6FMiX tOlR1ux//4soaNFEPkCP8CVvZmA8sqFXEQqdZb49jkk4Mb3jPNcNrbEBLMNrXc6rySX+ ujIBGpVteJ4HRlWzPXFCzDNRopUW18MaKRBlw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=date:subject:message-id:from:to:content-type :content-transfer-encoding; b=BUBMY1DswSga/cYrDPSHi3k7mw0EtEAI0YQa1ffYtkjqbIH8aZWeKhPq55IFdrnCuO rncVVb4CsYYLW2jrwn5JCntMMFr0p4G6AtJvshSg3Ex344sL+rBlEx7ja4z74RJl4prO i8kT4gtav745zOhtkpZpvx5geMiNGHmKN/7fA= Received: by 10.229.75.196 with SMTP id z4mr1588809qcj.277.1303573498499; Sat, 23 Apr 2011 08:44:58 -0700 (PDT) Received: from localhost ([200.108.109.161]) by mx.google.com with ESMTPS id f5sm2795452qck.8.2011.04.23.08.44.53 (version=SSLv3 cipher=OTHER); Sat, 23 Apr 2011 08:44:56 -0700 (PDT) Date: Sat, 23 Apr 2011 10:48:35 -0500 Subject: Re: not using partial index Message-ID: From: Henry To: Willy-Bas Loos , pgsql-performance@postgresql.org Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.345 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/330 X-Sequence-Number: 43392 CgpXaWxseS1CYXMgTG9vcyA8d2lsbHliYXNAZ21haWwuY29tPiB3cm90ZToKCj5IaSwKPgo+SSdt IHVzaW5nIFBvc3RncmVTUUwgOC40IChhbmQgYWxzbyA4LjMpLgo+Cj5BIHBhcnRpYWwgaW5kZXgg bGlrZSB0aGlzOgo+Q1JFQVRFIElOREVYIHRhYmxlMl9maWVsZDFfaWR4Cj4gIE9OIHRhYmxlMiAo ZmllbGQxKQo+IFdIRVJFIE5PVCBmaWVsZDEgSVNOVUxMOwo+Cj5XaWxsIG5vdCBiZSB1c2VkIHdo ZW4gc2VsZWN0IG9uZSByZWNvcmQgZnJvbSAxMDBLIHJlY29yZHM6Cj4KPmV4cGxhaW4gc2VsZWN0 ICogZnJvbSB0YWJsZTIgd2hlcmUgZmllbGQxID0gMjU2OTg4Cj4nU2VxIFNjYW4gb24gdGFibGUy ICAoY29zdD0wLjAwLi4xNjkzLjAxIHJvd3M9MSB3aWR0aD00KScKPicgIEZpbHRlcjogKGZpZWxk MSA9IDI1Njk4OCknCj4KPkJ1dCBpdCBXSUxMIGJlIHVzZWQgbGlrZSB0aGlzOgo+Cj5leHBsYWlu IHNlbGVjdCAqIGZyb20gdGFibGUyIHdoZXJlIGZpZWxkMSA9IDI1Njk4OCBhbmQgbm90IGZpZWxk MSBpc251bGwKPidJbmRleCBTY2FuIHVzaW5nIHRhYmxlMl9maWVsZDFfaWR4IG9uIHRhYmxlMiAg KGNvc3Q9MC4wMC4uOC4yOCByb3dzPTEKPndpZHRoPTQpJwo+JyAgSW5kZXggQ29uZDogKGZpZWxk MSA9IDI1Njk4OCknCj4KPgo+QnV0LCB3aGVuIGkgY2hhbmdlIHRoZSBpbmRleCBmcm9tIk5PVCBm aWVsZDEgSVNOVUxMICIgdG8gImZpZWxkMSBOT1ROVUxMIiwKPnRoZW4gdGhlIGluZGV4IFdJTEwg YmUgdXNlZCBpbiBib3RoIHF1ZXJpZXM6Cj4KPmV4cGxhaW4gc2VsZWN0ICogZnJvbSB0YWJsZTEg d2hlcmUgZmllbGQxID0gMjU2OTg4Cj4nSW5kZXggU2NhbiB1c2luZyB0YWJsZTFfZmllbGQxX2lk eCBvbiB0YWJsZTEgIChjb3N0PTAuMDAuLjguMjggcm93cz0xCj53aWR0aD00KScKPicgIEluZGV4 IENvbmQ6IChmaWVsZDEgPSAyNTY5ODgpJwo+Cj4nSW5kZXggU2NhbiB1c2luZyB0YWJsZTFfZmll bGQxX2lkeCBvbiB0YWJsZTEgIChjb3N0PTAuMDAuLjguMjggcm93cz0xCj53aWR0aD00KScKPicg IEluZGV4IENvbmQ6IChmaWVsZDEgPSAyNTY5ODgpJwo+JyAgRmlsdGVyOiAoTk9UIChmaWVsZDEg SVMgTlVMTCkpJwo+Cj4KPkFueSBpZGVhcyB3aHkgdGhpcyBtaWdodCBiZT8KPgo+Cj5DaGVlcnMs Cj4KPldCTAo+Cj5Db2RlIGJlbG93Ogo+Cj4tLWRyb3AgdGFibGUgdGFibGUxOwo+Y3JlYXRlIHRh YmxlIHRhYmxlMShmaWVsZDEgaW50ZWdlcik7Cj5DUkVBVEUgSU5ERVggdGFibGUxX2ZpZWxkMV9p ZHgKPiAgT04gdGFibGUxIChmaWVsZDEpCj4gIFdIRVJFIGZpZWxkMSBOT1ROVUxMOwo+aW5zZXJ0 IGludG8gdGFibGUxIHZhbHVlcyhudWxsKTsKPmluc2VydCBpbnRvIHRhYmxlMSBzZWxlY3QgZ2Vu ZXJhdGVfc2VyaWVzKDEsMTAwMDAwKTsKPgo+dmFjdXVtIGFuYWx5emUgdGFibGUxOwo+Cj5leHBs YWluIHNlbGVjdCAqIGZyb20gdGFibGUxIHdoZXJlIGZpZWxkMSA9IDI1Njk4OAo+ZXhwbGFpbiBz ZWxlY3QgKiBmcm9tIHRhYmxlMSB3aGVyZSBmaWVsZDEgPSAyNTY5ODggYW5kIG5vdCBmaWVsZDEg aXNudWxsCj4KPgo+LS1kcm9wIHRhYmxlIHRhYmxlMjsKPmNyZWF0ZSB0YWJsZSB0YWJsZTIoZmll bGQxIGludGVnZXIpOwo+Q1JFQVRFIElOREVYIHRhYmxlMl9maWVsZDFfaWR4Cj4gIE9OIHRhYmxl MiAoZmllbGQxKQo+ICBXSEVSRSBOT1QgZmllbGQxIElTTlVMTDsKPmluc2VydCBpbnRvIHRhYmxl MiB2YWx1ZXMobnVsbCk7Cj5pbnNlcnQgaW50byB0YWJsZTIgc2VsZWN0IGdlbmVyYXRlX3Nlcmll cygxLDEwMDAwMCk7Cj4KPnZhY3V1bSBhbmFseXplIHRhYmxlMjsKPgo+ZXhwbGFpbiBzZWxlY3Qg KiBmcm9tIHRhYmxlMiB3aGVyZSBmaWVsZDEgPSAyNTY5ODgKPmV4cGxhaW4gc2VsZWN0ICogZnJv bSB0YWJsZTIgd2hlcmUgZmllbGQxID0gMjU2OTg4IGFuZCBub3QgZmllbGQxIGlzbnVsbAo+Cj4K Pi0tIAo+IlBhdHJpb3Rpc20gaXMgdGhlIGNvbnZpY3Rpb24gdGhhdCB5b3VyIGNvdW50cnkgaXMg c3VwZXJpb3IgdG8gYWxsIG90aGVycwo+YmVjYXVzZSB5b3Ugd2VyZSBib3JuIGluIGl0LiIgLS0g R2VvcmdlIEJlcm5hcmQgU2hhdwo=