Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Dead Space Map



Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:

> Greg Stark wrote:
> > 
> > If you commit each update then your tuple might well be visible to other
> > transactions, how would you check that?
> 
> You check the xmin/xmax using standard visibility rules.

Would that really find anything? Even putting aside your own transaction
wouldn't it pick up any older transaction that started before yours and is
still running? They can't really see it but short of actually looking at their
snapshots I don't think you can determine that.

-- 
greg




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group