| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | PgSql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] 'cost' and 'rows' for volitile function |
| Date: | 2009-06-08 17:16:41 |
| Message-ID: | 4A2D4779.9050303@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Mead | 2009-06-08 17:21:22 | Re: Adding the host name to the PgSQL shell |
| Previous Message | Ioana Danes | 2009-06-08 17:12:42 | Re: Duplicate key issue in a transaction block |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-06-08 17:34:03 | Re: 'cost' and 'rows' for volitile function |
| Previous Message | Rob Sargent | 2009-06-08 16:26:05 | 'cost' and 'rows' for volitile function |