Re: tuning a function to insert/retrieve values from a reference table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: tuning a function to insert/retrieve values from a reference table
Date: 2007-07-10 15:41:20
Message-ID: 20267.1184082080@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> writes:
> Can I optimize this function with:

> a) remove the EXCEPTION clause (Is there an underlying lock that prevent
> concurrent inserts ?)

No.

> b) declare the function being IMMUTABLE ?

Certainly not --- it's got side-effects.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig James 2007-07-11 00:53:17 Equivalent queries produce different plans
Previous Message Marc Mamin 2007-07-10 15:03:40 tuning a function to insert/retrieve values from a reference table