Re: COPY and Volatile default expressions

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: COPY and Volatile default expressions
Дата
Msg-id 20130416135817.GG5343@momjian.us
обсуждение исходный текст
Ответ на Re: COPY and Volatile default expressions  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: COPY and Volatile default expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Apr 16, 2013 at 02:37:33PM +0100, Simon Riggs wrote:
> On 16 April 2013 13:57, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
> 
> > You still need to check the args, if the function is nextval, otherwise you
> > incorrectly perform the optimization for something like
> > "nextval(myvolatilefunc())".
> 
> Guess so. At least its an easy change.

I found Simon's nextval()/COPY timings without this patch sobering.  I
assume he can apply this for 9.3, right?  I believe it is a fix for a
new 9.3 feature.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: COPY and Volatile default expressions
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Enabling Checksums