From: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | RE: [HACKERS] Transaction logging |
Date: | 1999-02-24 04:31:44 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC1451E2@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Your getting me excited about 6.5. Is there a projected release date for
6.5? Is there any information on transaction logging? Is there anything I
can do to help? I am curious about these items because they will make my
life much easier in the upcoming months as I migrate my application to
Postgres. Working around these could be very difficulty or near impossible.
-----Original Message-----
From: Bruce Momjian [SMTP:maillist(at)candle(dot)pha(dot)pa(dot)us]
Sent: Tuesday, February 23, 1999 8:02 PM
To: Michael Davis
Cc: pgsql-general(at)postgreSQL(dot)org; pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Transaction logging
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-24 04:43:00 | Re: [HACKERS] Transaction logging |
Previous Message | Bruce Momjian | 1999-02-24 03:16:24 | Re: [HACKERS] inet data type regression test fails |