| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Cc: | "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>, PgSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Lock Modes (Documentation) |
| Date: | 2005-11-02 23:30:38 |
| Message-ID: | 200511022330.jA2NUcN02794@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jim C. Nasby wrote:
> On Wed, Nov 02, 2005 at 05:59:15PM -0500, Bruce Momjian wrote:
> > Actually, pre-8.1 used ROW EXCLUSIVE for foreign keys because we didn't
> > have ROW SHARE until 8.1. I actually can't find out how we are doing
> > that in the code, however. Analyzing the code is probably the only way
> > to get this detailed lock information.
>
> Would it be feasable to have the lock manager spew out info about lock
> aquisition and release? Not only would it make getting this information
> easy, but I suspect it could be a useful debugging tool.
Something like log_locks? That would be valuable.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Hatcher | 2005-11-02 23:39:24 | Data Dictionary generator? |
| Previous Message | Tom Lane | 2005-11-02 23:29:44 | Re: Clustered indexes - When to use them? |