Skip site navigation (1) Skip section navigation (2)

Re: eWeek Poll: Which database is most critical to your

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: eWeek Poll: Which database is most critical to your
Date: 2002-02-26 23:03:35
Message-ID: 1014764615.369.6.camel@jiro (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-announcepgsql-generalpgsql-hackers
On Tue, 2002-02-26 at 15:30, Zak Greant wrote:
> Good Day All,
> 
> eWeek has posted a poll that asks which database server is most critical
> to your organization.

The article mentions a MySQL feature which apparently improved
performance considerably:

//
MySQL 4.0.1's new, extremely fast query cache is also quite notable, as
no other database we tested had this feature. If the text of an incoming
query has a byte-for-byte match with a cached query, MySQL can retrieve
the results directly from the cache without compiling the query, getting
locks or doing index accesses. This query caching will be effective only
for tables with few updates because any table updates that clear the
cache to guarantee correct results are always returned.
//

My guess is that it would be relatively simple to implement. Any
comments on this?

If I implemented this, any chance this would make it into the tree? Of
course, it would be:

    - disabled by default
    - enabled on a table-by-table basis (maybe an ALTER TABLE command)

Cheers,

Neil

-- 
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC


In response to

Responses

pgsql-announce by date

Next:From: Hannu KrosingDate: 2002-02-27 05:38:36
Subject: Re: eWeek Poll: Which database is most critical to your
Previous:From: Zak GreantDate: 2002-02-26 20:30:41
Subject: eWeek Poll: Which database is most critical to your organization?

pgsql-hackers by date

Next:From: Dann CorbitDate: 2002-02-26 23:20:17
Subject: Re: eWeek Poll: Which database is most critical to your
Previous:From: Bruce MomjianDate: 2002-02-26 22:33:09
Subject: Re: Please, apply patch for contrib/tsearch

pgsql-advocacy by date

Next:From: Hannu KrosingDate: 2002-02-27 05:38:36
Subject: Re: eWeek Poll: Which database is most critical to your
Previous:From: Zak GreantDate: 2002-02-26 20:30:41
Subject: eWeek Poll: Which database is most critical to your organization?

pgsql-general by date

Next:From: Bill McGonigleDate: 2002-02-26 23:25:32
Subject: Re: Is there a drawback when changing NAMEDATALEN to 64?
Previous:From: Bill McGonigleDate: 2002-02-26 23:00:02
Subject: Re: pg_dumpall storing multiple copies of DB's?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group