Re: Query with "like" is really slow

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: Query with "like" is really slow
Дата
Msg-id fbrp3t$rdn$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Query with "like" is really slow  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Query with "like" is really slow  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Дерево обсуждения 
<<Actually it's quite possible that
that extra overhead in nested loop is largely gettimeofday() calls for the
explain analyze. Does the query take less time run without explain analyze
than it does run with it?
>>

Do you mean that an EXPLAIN ANALYZE that runs longer than the actual query
is a symptom of time being lost to a function call?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Security Advances in Postgresql over other RDBMS