[PATCH] Partial indicies almost working (I think)

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема [PATCH] Partial indicies almost working (I think)
Дата
Msg-id 20010703233541.A4320@svana.org
обсуждение исходный текст
Ответы Re: [PATCH] Partial indicies almost working (I think)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hmm, not much a response to the last email. No matter, I've made some more
progress.

* The planner now correctly determines that the index is usable without
  segfaulting.

Really wasn't that hard. The code that deals with checking the predicate
when inserting still worked fine.

So, as far as I can tell, partial indecies would be completely usable, *if*
I could get the planner to use them. I'm pretty sure it goes wrong in
create_index_paths. The pred_test works fine but somewhere in the lines
below it doesn't realise it can use the index. Since I can't quite work out
what those functions are supposed to do I'm don't see how to fix it either.

Could somebody look into it?

I have a sneaking suspicion the cost estimator will need to be fixed too,
but I havn't got to that yet.

The patch is against 7.1release.
--
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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re:
Следующее
От: Philip Molter
Дата:
Сообщение: Determining scan types