Re: Table locks

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dale Anderson <danderso(at)crystalsugar(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: Table locks
Date: 2000-10-09 18:47:33
Message-ID: 200010091847.OAA02137@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > No spinlock. I was going to just grab a snapshot as it existed. If it
> > changes while I am grabbing it, I just try again.
>
> Unless, of course, you follow a now-dangling pointer and cause a backend
> crash. But even without that, how do you know whether you grabbed a
> self-consistent snapshot or not?

Not sure, yet...

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2000-10-09 19:19:15 Re: snapshot: dot or dash?
Previous Message Martin A. Marques 2000-10-09 18:46:17 Re: Win98