On Mon, Aug 02, 1999 at 12:01:03AM -0400, Tom Lane wrote:
>
> Well, I'm more interested in putting my effort into making the system
> do the right thing without help. Manual overrides are OK as long as
> you remember to revisit the settings whenever anything changes ...
> otherwise your manual optimization can become manual pessimization ...
>
Hey Tom -
Ran across this paper, about an interesting approach, pulling in the indices
to aid in selectivity estimates.
http://db.cs.berkeley.edu/papers/CSD-98-1021.pdf
I grabbed this from a link at:
http://db.cs.berkeley.edu/papers/
while looking at the Mariposa work ( http://mariposa.cs.berkeley.edu)
from the Sequoia2000 project. I've convinced my team to let me spend
a couple days analyzing what it would take to fold the remote access
features of Mariposa into the current PostgreSQL tree. I grabbed the
alpha-1 code (June 23, 1996) which seems to be based on an early version
of Postgres95. Interesting to see all the academic cruft you guys have
already cleaned out ;-)
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005