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

Re: The mystery of concurrent access

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: The mystery of concurrent access
Date: 2001-10-05 20:26:58
Message-ID: web-142736@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
P.V.,

> When 2 processes/people are simultaneously working on a table
> 
> * does Postgres automatically enforce some sort of locking?
> * do the changes made by process A become visible to process B
> immediately 
> (of course, the result of a SELECT wouldn't change dynamically, but
> suppose 
> process B did another SELECT, would it access process A's records?)

Please read:

http://www.postgresql.org/idocs/index.php?mvcc.html

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh(at)agliodbs(dot)com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

In response to

pgsql-novice by date

Next:From: Jason EarlDate: 2001-10-05 21:52:05
Subject: Re: The mystery of concurrent access
Previous:From: Tom LaneDate: 2001-10-05 19:08:34
Subject: Re: How to find out that a record has been updated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group