Adam Haberlach <[EMAIL PROTECTED]> 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 Linux BSD... ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly