Re: Using EXPLAIN in regressions?

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Using EXPLAIN in regressions?
Дата
Msg-id 1153435887.5476.3.camel@localhost
обсуждение исходный текст
Ответ на Re: Using EXPLAIN in regressions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 2006-07-20 at 18:19 -0400, Tom Lane wrote:
> About the best bet is to make sure that's the *only* available index,
> and set enable_seqscan = off to be sure.

Another approach would be to define a UDF that takes a query string,
runs the parser, rewriter, and planner on the string and then checks
various properties of the resulting Plan (e.g. that it includes a GiST
index scan).

-Neil




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using EXPLAIN in regressions?
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [PATCHES] 8.2 features?