Обсуждение: [PATCH] Partial indices final?

OK, I've changed the vacuum code now so your index doesn't get
departialised. The changes seem pretty obvious so they're probably right.
They certainly didn't seem to break my simple tests. How does one test that
VACUUM works properly?

I think it's time to send it to pgsql-patches now, unless someone spots a
serious problem.

http://svana.org/kleptog/pgsql/partial-indices-7.2.patch

Anyway, now it's time to think about after. I can think of:
* Complete the removal of EXTEND INDEX
* Allow IS NULL in the predicate

Anything else?
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.

Martijn van Oosterhout <kleptog@svana.org> writes:
> OK, I've changed the vacuum code now so your index doesn't get
> departialised. The changes seem pretty obvious so they're probably right.
> They certainly didn't seem to break my simple tests. How does one test that
> VACUUM works properly?

Since I'm just about to start doing some rearrangements of the VACUUM
code, I'll first go ahead and apply the changes to make VACUUM use
ExecOpenIndices.  I've wanted to make that change for quite awhile,
independently of partial-index considerations, but had not gotten around
to doing it.

The rest of this should probably be sent to pgsql-patches for more
review.

            regards, tom lane