STABLE marker on functions with single select

From: Laszlo Hornyak <lhornyak(at)redhat(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: STABLE marker on functions with single select
Date: 2013-09-02 15:12:00
Message-ID: 1028130796.8334160.1378134720003.JavaMail.root@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

We have some plpgsql functions that return a setof rows from some tables by a single query, they are quite simple. Only the application invokes these functions to query the database, one at a time. e.g. select getFooById(1)
Do I correctly assume that marking the functions as STABLE will not have any effect on the performance in this case?

Thank you,
Laszlo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2013-09-02 15:41:51 Re: STABLE marker on functions with single select
Previous Message Adrian Klaver 2013-09-02 15:04:31 Re: psql --command option ignores --variable's