| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Anil Menon *EXTERN*" <gakmenon(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance question |
| Date: | 2014-11-21 09:16:40 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17DA3923@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Anil Menon wrote:
> I would like to ask from your experience which would be the best "generic" method for checking if row
> sets of a certain condition exists in a PLPGSQL function.
>
> I know of 4 methods so far (please feel free to add if I missed out any others)
[...]
Are you aware that all of these methods have a race condition unless
you use isolation level READ STABILITY or better?
It may be that rows are added or removed between the check and the
corresponding action.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anil Menon | 2014-11-21 10:32:40 | Re: Performance question |
| Previous Message | Albe Laurenz | 2014-11-21 09:05:01 | Re: pgdump (9.2.4) not dumping all tables |