| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Glen Parker <glenebob(at)nwlink(dot)com>, PgSql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Locking to restrict rowcounts. |
| Date: | 2009-05-20 08:21:00 |
| Message-ID: | 4A13BD6C.4090002@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Just realised I didn't cc: the list on this. Was obviously having a good
evening.
Richard Huxton wrote:
> Glen Parker wrote:
> > I still don't think it will work. Two concurrent transactions could
>> still screw the data up.
>>
>> Before: 9 rows.
>> Tx 1: See 9 rows, issue insert, see 10 rows.
>> Tx 2: See 9 rows, issue insert, see 10 rows.
>> After: 11 rows.
>
> True, and well corrected.
>
> Serves me right for posting at the end of a long day. Particularly
> irritating as its almost identical to the example I've used myself when
> showing the limitations of PG's low-locking MVCC model.
>
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-05-20 08:29:58 | Re: [Windows] Feedback on PG? |
| Previous Message | Richard Huxton | 2009-05-20 08:20:15 | Re: [Windows] Feedback on PG? |