From: | James Rogers <jamesr(at)best(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Architecture Roadmap? |
Date: | 2003-10-06 22:48:08 |
Message-ID: | 1065480488.26229.177.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I've been going through the source tree (pretty nice, BTW) and have
found a number of things I'd like to work on. My primary interest is in
adding performance and scalability features to the underlying engine.
However, one thing I haven't found is a roadmap/schedule for major
architectural features i.e. while some of the features could be
incrementally hacked into the current source pretty transparently,
others might generate a bigger footprint. I guess what I am wondering
is whether there is any kind of quasi-official mechanism for putting
certain features in certain future versions depending on the nature and
significance of implementing those features and the number of things it
touches.
Features I am interested in working on in the relative short-term:
* Buffer Management
- A more optimal/adaptive cache replacement algorithm
- Use of fine-grained adaptive latching to increase efficiency on
SMP systems (particularly 4+ processor systems)
- Add a background cache writer process to opportunistically flush
dirty buffers
* Heap Organization
- Hash partitioned heaps
- BTree organized heaps
While these should generate some performance improvements on smaller
databases, more important to me is that it will go along way to making
it scale more like Oracle when dealing with very large and active
systems (my current problem). It has been a few years, but I've done
implementations of most of these features in software before.
So I guess I have two questions:
1) Does anyone object to me working on these two areas?
2) What version target should I realistically be shooting for?
Cheers,
-James Rogers
jamesr(at)best(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-06 22:52:44 | Disabling function validation |
Previous Message | Peter Eisentraut | 2003-10-06 22:36:18 | Re: psql italian translation |