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

Re: [GENERAL] Transaction logging

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: michael(dot)davis(at)prevuenet(dot)com (Michael Davis)
Cc: pgsql-general(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Transaction logging
Date: 1999-02-24 03:02:07
Message-ID: 199902240302.WAA02346@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
> What would it take to have transaction logging added to Postgres.  I am a
> c/c++ programmer and will consider contributing to the Postgres development
> effort.  I really like everything I see and read about Postgres.  As a
> result, I am strongly considering Postgres as the database engine for my
> Membership database application.  My customer is willing to invest in a
> commercial database, but most of the commercial databases I have briefly
> looked at fall a little short in one way or another.  I have several
> concerns/needs that I am willing to implement and/or support:
> 
> 	- Outer join support in views

In the works.  Perhaps for 6.5, probably not.

> 
> 	- Transaction logging
> 
> 	- Some form of mirroring, shadowing, or replication
> 
> 	- The current locking mechanism is of some concern.  I need to make
> sure that one user can read a record and then a second can read and update
> that same record.

MVCC locking in 6.5.  Will do what you need.
> 
> 	- If the first user attempts to update that record, what happens?

Hard to explain.  Will wait or update a copy while read's use an older
copy fo the row.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(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

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 1999-02-24 03:02:57
Subject: Re: [HACKERS] inet data type regression test fails
Previous:From: Daryl W. DunbarDate: 1999-02-24 01:39:09
Subject: RE: [HACKERS] postmaster failure with 2-23 snapshot

pgsql-general by date

Next:From: strawmanDate: 1999-02-24 04:29:17
Subject: timestamps
Previous:From: Peter T MountDate: 1999-02-23 22:12:27
Subject: Re: [GENERAL] Transaction logging

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