Re: [SQL] 'cost' and 'rows' for volitile function

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: [SQL] 'cost' and 'rows' for volitile function
Дата
Msg-id 4A2D4779.9050303@archonet.com
обсуждение исходный текст
Список pgsql-general
Old fool that I am - forgot to cc: the list.

Richard Huxton wrote:
> Rob Sargent wrote:
>> pg-admin is showing 'COST 100' and 'ROWS 1000' for my explicitly
>> VOLATILE functions.  Is one hundred the new ninety-nine? and therefore
>> these values are ignored by the planner?
>
> No, they're the default expected cost and number of rows returned when
> calling your functions. What do you think VOLATILE should be doing to them?
>
> http://www.postgresql.org/docs/8.3/interactive/sql-createfunction.html


--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Madison Kelly
Дата:
Сообщение: Adding the host name to the PgSQL shell
Следующее
От: Ioana Danes
Дата:
Сообщение: Re: Duplicate key issue in a transaction block