X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 58D9ED1B51F for ; Sun, 7 Mar 2004 02:39:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76076-02 for ; Sat, 6 Mar 2004 22:39:44 -0400 (AST) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by svr1.postgresql.org (Postfix) with ESMTP id 11F0BD1B511 for ; Sat, 6 Mar 2004 22:39:40 -0400 (AST) Received: from lerlaptop.lerctr.org ([207.158.72.14]) by lerami.lerctr.org with asmtp (Exim 4.30) id 1AzoCc-0001w0-Ey; Sat, 06 Mar 2004 20:39:42 -0600 Date: Sat, 06 Mar 2004 20:39:38 -0600 From: Larry Rosenman To: John Siracusa , Postgres Performance Subject: Re: Feature request: smarter use of conditional indexes Message-ID: <32080000.1078627178@lerlaptop.lerctr.org> In-Reply-To: <41C473B6-6FDF-11D8-9156-000A95BA4506@mindspring.com> References: <41C473B6-6FDF-11D8-9156-000A95BA4506@mindspring.com> X-Mailer: Mulberry/3.1.2 (Linux/x86) X-PGP-Info: All other keys are old/dead. X-PGP-Key: 0x3c49bdd6 X-PGP-Fingerprint: D0D1 3C11 F42F 6B29 FA67 6BF3 AD13 4685 3C49 BDD6 MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="==========5B2F37D9C3BDA9B57E07==========" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/83 X-Sequence-Number: 5939 --==========5B2F37D9C3BDA9B57E07========== Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline --On Saturday, March 06, 2004 21:29:27 -0500 John Siracusa=20 wrote: > On 3/3/04 6:53 PM, Tom Lane wrote: >> John Siracusa writes: >>> Given an index like this: >>> CREATE UNIQUE INDEX i1 ON t1 (c1) WHERE c1 IS NOT NULL; >>> and a query like this: >>> SELECT * FROM t1 WHERE c1 =3D 123; >>> I'd like the planner to be smart enough to use an index scan using >>> i1. >> >> Send a patch ;-) Just a suggestion, please use diff -c format, as it makes it easier for the folks who apply the patches to do so. [snip] --=20 Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 --==========5B2F37D9C3BDA9B57E07========== Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD4DBQFASotsrRNGhTxJvdYRAoUNAJjlYvpK2RsxyyZfl4TLMDS0hRFfAJ9lzd7z K7ohm0b+2Ans6UvrttZFFw== =ceT7 -----END PGP SIGNATURE----- --==========5B2F37D9C3BDA9B57E07==========--