Re: Index not used in functions in 7.0?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index not used in functions in 7.0?
Дата
Msg-id 21401.958492203@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Index not used in functions in 7.0?  (Kyle Bateman <kyle@actarg.com>)
Ответы Re: Index not used in functions in 7.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Kyle Bateman <kyle@actarg.com> writes:
> I dumped the log (-d 9) from the postmaster and the plan confirms that
> the scan is sequential when called from within the function but indexed
> when the SQL is called directly.

Yikes, that does sound like a bug.

> I'd be happy to provide a dump of the data, do other testing or whatever
> would help.  I'm not sure who on the team is best to look at this.

How big would the dump file be?  I'm willing to look at this, and if the
dump isn't very large then it'd be easier to just install your DB here
instead of trying to gin up my own test case.
        regards, tom lane


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

Предыдущее
От: Kyle Bateman
Дата:
Сообщение: Index not used in functions in 7.0?
Следующее
От: mig@utdt.edu
Дата:
Сообщение: Re: pattern matching operator