Re: severe performance issue with planner

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: severe performance issue with planner
Дата
Msg-id 40512394.2050506@familyhealth.com.au
обсуждение исходный текст
Ответ на severe performance issue with planner  ("Eric Brown" <bigwhitecow@hotmail.com>)
Список pgsql-performance
> if i first do prepare blah as SELECT ....., then run execute blah, the
> time goes down to about 275ms  (i had been running this query a lot, and
> did a vacuum update before all this).

If you make it an SQL stored procedure, you get the speed up of the
PREPARE command, without having to prepare manually all the time.

Chris


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

Предыдущее
От: "Eric Brown"
Дата:
Сообщение: severe performance issue with planner
Следующее
От: Tom Lane
Дата:
Сообщение: Re: severe performance issue with planner