Re: Problem with LIKE-Performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with LIKE-Performance
Дата
Msg-id 13458.1145373620@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with LIKE-Performance  ("Tarabas (Manuel Rorarius)" <tarabas@tarabas.de>)
Ответы Re: Problem with LIKE-Performance
Список pgsql-performance
"Tarabas (Manuel Rorarius)" <tarabas@tarabas.de> writes:
> I get the following explain and I am troubled by the very high
> "startup_cost" ... does anyone have any idea why that value is so
> high?

> {SEQSCAN
>    :startup_cost 100000000.00

You have enable_seqscan = off, no?

Please refrain from posting EXPLAIN VERBOSE unless it's specifically
requested ...

            regards, tom lane

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

Предыдущее
От: "Tarabas (Manuel Rorarius)"
Дата:
Сообщение: Re: Problem with LIKE-Performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SELECT FOR UPDATE performance is bad