Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 505776408B0 for ; Thu, 10 Jun 2010 17:13:56 -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 82544-02 for ; Thu, 10 Jun 2010 20:13:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from joeconway.com (wsip-72-214-29-243.sd.sd.cox.net [72.214.29.243]) by mail.postgresql.org (Postfix) with ESMTP id 1957164089A for ; Thu, 10 Jun 2010 17:13:47 -0300 (ADT) Received: from [192.168.4.40] (account jconway HELO dev.joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 9807024; Thu, 10 Jun 2010 13:13:46 -0700 Message-ID: <4C11477A.5020909@joeconway.com> Date: Thu, 10 Jun 2010 13:13:46 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.5.0.12-3.fc6 pango-text Thunderbird/1.5.0.12 Mnenhy/0.7.5.666 MIME-Version: 1.0 To: Anne Rosset CC: Craig James , pgsql-performance@postgresql.org Subject: Re: Need to increase performance of a query References: <4C1125F0.8090101@collab.net> <4C112B19.6080908@krogh.cc> <4C113098.5040105@collab.net> <98414706.20100610212211@erwied.eu> <4C113E2F.6000305@collab.net> <4C11413B.8080107@emolecules.com> <4C114381.3030900@collab.net> <4C11469A.8000706@joeconway.com> In-Reply-To: <4C11469A.8000706@joeconway.com> X-Enigmail-Version: 1.0.1 OpenPGP: id=B699434A Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig1717A62EC38BBEDE62ED86E2" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.981 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201006/187 X-Sequence-Number: 39043 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig1717A62EC38BBEDE62ED86E2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 06/10/2010 01:10 PM, Joe Conway wrote: > try: >=20 > create index item_rank_null_idx on item_rank(pf_id) > where rank IS NOT NULL AND pf_id IS NULL; oops -- that probably should be: create index item_rank_null_idx on item_rank(project_id) where rank IS NOT NULL AND pf_id IS NULL; Joe --------------enig1717A62EC38BBEDE62ED86E2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iQIcBAEBCAAGBQJMEUd6AAoJEDfy90M199hlqiQQAJB5oNzlW1611r4RaVYtEIJI n433e3jZYgqSIlvIxoem82YDWXjqzCa+5H5vG+S91ai94SZg61b3UxfToMr0vQeL l7muaHrx1jF1gG7CmBT9cFlwJbuYFWccc7NGvQPrVVgPJFjoTjRSx4za5nbMCn/B ghaH+hSJWEpiSX6wPZ/bl5Cli99lwj41y5Klag0vz+O5BhZQNVDGGOt+YbCOwmq5 di9EXIEeWxXrk6mz9P1SbkoywDIog6q9dyn6g5QDLYzIvwAtltU7szneN2A1cft9 fl7f/xU4Bi26WdKj2E9x0TIwNe5J7yc3m1Ky/+Zsrj+JtoHMAKBYBhET3C1kX54S qA9DmI5M75xUOZTEN6vL9+QPAQfwVNmem20UyhWEGzOZYq0rXBKLde16+T5QzpoC UFX/+3EFok4ik0pWzcvpWaXqzImgC+/65R5ZasoQiWYRCxkeJ43m5Ey0mrOwfB4e veBOCeqhIl23sulh30AK+69nM80XYtJ5ve9v4EKS/d8OhCT9FT5jueF+FX+BaeOT LQ5i/RL8SePiCjEGOY2QHba7IsgR97LASSlRY0lsVvvGxy52L9itsboDxHgb7acF 70AKwUOrwNOozCQt2/uEuPQbtvy294ILrY4RbTe9EY82jaN527rmpmob/Esz8KoN DulSLddmjiKRUdfse+JC =ff4Q -----END PGP SIGNATURE----- --------------enig1717A62EC38BBEDE62ED86E2--