pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-performance@postgresql.org
Subject: Re: unexpected stable function behavior
Date: Tue, 15 Mar 2011 10:12:13 +0200
Message-ID: <4D7F1F5D.4010709@nsoft.lt> (raw)
In-Reply-To: <12872.1300123053@sss.pgh.pa.us>
References: <4D78FB98.7090609@nsoft.lt>
	<AANLkTimTR_f98H4+h57iW6-S=BjZaMTSQ6VznRgXU5Ly@mail.gmail.com>
	<4D7DD5CF.4080502@nsoft.lt>
	<12872.1300123053@sss.pgh.pa.us>

Thank you, Tom for you answer

2011.03.14 19:17, Tom Lane rašė:
> That function property*allows*  the optimizer to
> invoke the function fewer times than would happen in an un-optimized
> query.  It does not*require*  it to do so.
Thank you for clearing that for me. I think these 2 sentences in 
documentation 
(http://www.postgresql.org/docs/current/interactive/xfunc-volatility.html) 
would prevent misunderstandings in the future.

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

view thread (8+ messages)

Message-ID: <4D7F1F5D.4010709@nsoft.lt>
Permalink:  ../4D7F1F5D.4010709@nsoft.lt/
Also on:    postgresql.org/message-id/4D7F1F5D.4010709@nsoft.lt

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: julius@nsoft.lt
  Subject: Re: unexpected stable function behavior
  In-Reply-To: <4D7F1F5D.4010709@nsoft.lt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox