agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedconcurrency control structures in Postgres
2+ messages / 2 participants
[nested] [flat]
* concurrency control structures in Postgres
@ 1970-01-01 00:00 MARCIN JANUCHTA (P.445) <MARTIN@kastor.ics.tup.edu.pl>
1994-04-26 02:37 ` Re: concurrency control structures in Postgres Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 1 reply; 2+ messages in thread
From: MARCIN JANUCHTA (P.445) @ 1970-01-01 00:00 UTC (permalink / raw)
To: ucb-postgres; +Cc: martin@pozn1v.tup.edu.pl; martin@kastor.ics.tup.edu.pl
I am supervising a project in extending Postgres to handle complex
event detection, monitoring other systems (like Oracle and Novell
netware) etc. It would be very valuable to provide a real-time
support for these tasks. First of all I need to adjust
the concurrency control to be priority sensitive.
Does anybody have the documentation concerning the lock table
structure and lock request/grant routines in Postgres code,
as well as the internal representation of transactions?
It is also very important to be able to abort a chosen transaction
by calling some "abort" function.
I hope that somebody (perhaps from the Postgres team) would be
so kind to enlighten me (if it's not a kind of trade secret...).
The documentation coming with the 4.1 or 4.2
does not cover the subject (except few lines at the end of am.ps).
Thank you very much in advance for your kind consideration.
Regards,
Marcin Januchta (martin@kastor.ics.tup.edu.pl, @pozn1v.tup.edu.pl)
Institute of Computing Science
Poznan Technical University
Poznan, Poland
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: concurrency control structures in Postgres
1970-01-01 00:00 concurrency control structures in Postgres MARCIN JANUCHTA (P.445) <MARTIN@kastor.ics.tup.edu.pl>
@ 1994-04-26 02:37 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1994-04-26 02:37 UTC (permalink / raw)
To: MARCIN JANUCHTA (P.445) <MARTIN@kastor.ics.tup.edu.pl>; +Cc: ucb-postgres; martin@pozn1v.tup.edu.pl
"MARCIN JANUCHTA (P.445)" <MARTIN@kastor.ics.tup.edu.pl> writes:
> Does anybody have the documentation concerning the lock table
> structure and lock request/grant routines in Postgres code,
> as well as the internal representation of transactions?
> I hope that somebody (perhaps from the Postgres team) would be
> so kind to enlighten me (if it's not a kind of trade secret...).
if it were a trade secret, we wouldn't give away the source, eh? :-)
the very little i know about the lock manager i acquired from
walking around with a TAGS-file. unfortunately there isn't much
in terms of documentation. there is a file
src/backend/storage/lmgr/README
that was a first attempt by jeff meredith at explaining some concepts
but it was never finished. there are also some comments in the source
that explain a few things. i believe the gray paper to which they
refer is:
%A J. N. Gray
%A R. A. Lorie
%A G. R. Putzolu
%A I. L. Traiger
%T Granularity of Locks and Degrees of Consistency in a Shared Data Base
%B Modelling in Data Base Management Systems
\fI(PROC IFIP Working CONF on Modelling in Data Base Management Systems, Freudenstadt, Germany, JAN 1976)\fP
%I North-Holland
%C Amsterdam, the Netherlands
%D 1976
%P 365-394
%O (Reprinted in: M. Stonebraker, \fIReadings in Database Systems, 2nd Ed.\fP, Morgan Kauffman, San Mateo, CA, 1993.)
(note that the recent gray/reuter book on transaction processing systems
has an improved version of the same discussion.)
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
===============================================================================
To add/remove yourself from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
===============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-04-26 02:37 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 concurrency control structures in Postgres MARCIN JANUCHTA (P.445) <MARTIN@kastor.ics.tup.edu.pl>
1994-04-26 02:37 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox