Re: My only post with regard to query caching

Adam Haberlach <adam@newsnipple.com> writes:

> MySQL is doing some things right.  They are providing useful
> documentation.  They are adding features that target the web market
> (they may be adding them incorrectly, however).  If we expect
> PostgreSQL to beat MySQL in anything but "My database is
> transactionally secure" and "We have a GECO optimizer" pissing wars,
> we'll need to start becoming a little more competitive in the raw
> speed arena.  I feel that this optimization, while it may not be
> trivial, is fairly low-hanging fruit that can help.  I may even try
> to implement it, but I make no guarantees.

Looks like the onus is on you and mlw to come up with a design for the
query cache mechanism, based on knowledge of PG internals, that
intelligently addresses ACID and MVCC issues, and propose it.  I think
the core developers would certainly be willing to look at such a
design proposal.  Then, if they like it, you get to implement it.  ;)

In other words, and I say this in the nicest possible way, talk is
cheap.

-Doug
-- 
Doug McNaught       Wireboard Industries      http://www.wireboard.com/
     Custom software development, systems and network consulting.     Java PostgreSQL Enhydra Python Zope Perl Apache
LinuxBSD...