Postgres Pro
Downloads
Home   >   mailing lists

Re: tuning a function to insert/retrieve values from a reference table - Mailing list pgsql-performance

From Tom Lane
Subject Re: tuning a function to insert/retrieve values from a reference table
Date
Msg-id 20267.1184082080@sss.pgh.pa.us
Whole thread Raw
In response to tuning a function to insert/retrieve values from a reference table  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-performance
Tree view 
"Marc Mamin" <M.Mamin@intershop.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

pgsql-performance by date:

Previous
From: "Marc Mamin"
Date:
Subject: tuning a function to insert/retrieve values from a reference table
Next
From: Craig James
Date:
Subject: Equivalent queries produce different plans