question about partial index

From: Yu Zhao <yzhao81(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: question about partial index
Date: 2014-03-18 21:26:27
Message-ID: CABWNxfHx1Eb7r_GdO1C8enAOeLZ4gUAAK1BHCUk1oCsgO1Q+-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In PostgreSQL 9.3.3 Documentation 11.8. Partial Indexes Example 11-2
(http://www.postgresql.org/docs/9.3/interactive/indexes-partial.html)
the partial index is created

CREATE INDEX orders_unbilled_index ON orders (order_nr) WHERE billed
is not true;

And the suggested use mode is

SELECT * FROM orders WHERE billed is not true AND order_nr < 10000;

My question is after an update to the billed column is done, will PG
automatically add or remove records whose billed are just set to false
or true to/from the b-tree?

Thanks in advance.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2014-03-18 21:51:26 Re: question about partial index
Previous Message Vincent 2014-03-18 21:20:26 Re: Help me understand why my subselect is an order of magnitude faster than my nested joins