Re: Perfomance decreasing - Mailing list pgsql-general

From Tom Lane
Subject Re: Perfomance decreasing
Date
Msg-id 28513.998021231@sss.pgh.pa.us
Whole thread Raw
In response to Re: Perfomance decreasing  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-general
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Where do I release the lock ?

I'd say you shouldn't release it at all.  Let it be held until end of
transaction.

    rel = heap_open(relid, AccessExclusiveLock);
    ...
    heap_close(rel, NoLock);  /* close rel, keep lock till end of xact */

            regards, tom lane

pgsql-general by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Perfomance decreasing
Next
From: Hiroshi Inoue
Date:
Subject: Re: Perfomance decreasing