'cost' and 'rows' for volitile function

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: 'cost' and 'rows' for volitile function
Date: 2009-06-08 16:26:05
Message-ID: 4A2D3B9D.1040909@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-06-08 16:28:29 Re: Postgres's Performance degrades after heavy db operation
Previous Message Vick Khera 2009-06-08 16:25:08 Re: Postgres's Performance degrades after heavy db operation

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2009-06-08 17:16:41 Re: [SQL] 'cost' and 'rows' for volitile function
Previous Message Isaac Dover 2009-06-06 19:53:19 Xml Schemas