Re: Perfomance decreasing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Alexander Loginov <sas(at)mplik(dot)ru>, pgsql-general(at)postgresql(dot)org
Subject: Re: Perfomance decreasing
Date: 2001-08-17 04:07:11
Message-ID: 28513.998021231@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Inoue 2001-08-17 04:20:46 Re: Perfomance decreasing
Previous Message Hiroshi Inoue 2001-08-17 04:04:41 Re: Perfomance decreasing