Understanding how partial indexes work?

From: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Understanding how partial indexes work?
Date: 2007-12-06 07:44:36
Message-ID: b0a3bf780712052344n5b6b8d46tac80a0f1ee4944ab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a query on a table:-

X between k1 and k2 or X < k1 and Y <> k3

where k1, k2, k3 are constants.

How would this query work, if I created an index on X and a partial
index on X where Y <> k3?

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles.Hou 2007-12-06 08:26:36 autovacuum is stopping automatically....
Previous Message Ken Johanson 2007-12-06 07:26:53 Statement.executeUpdate(String sql, int columnIndexes[]) via RETURNING clause?