Re: [HACKERS] Selectivity estimates paper, and Mariposa - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Selectivity estimates paper, and Mariposa
Date
Msg-id 199908022044.QAA09235@candle.pha.pa.us
Whole thread Raw
In response to Selectivity estimates paper, and Mariposa  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
Responses Re: [HACKERS] Mariposa
List pgsql-hackers
> 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 ;-)

We still have a directory called tioga which is also related to
Mariposa.  Basically, at the time, no one understood the academic stuff,
and we had tons of bugs in general areas.  We just didn't see any reason
to keep around unusual features while our existing code was so poorly
maintained from Berkeley.

The mariposa remote access features looked like they were heavily done
in the executor directory.  This makes sense assuming they wanted the
access to be done remotely.  They also tried to fix some things while
doing Mariposa.  A few of those fixes have been added over the years.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Selectivity estimates paper, and Mariposa
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Any 6.5.2 activities ?