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

Re: Caching of Queries

From: Harald Fuchs <hf0722x(at)protecting(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Caching of Queries
Date: 2004-09-27 16:15:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
In article <1096261381(dot)25688(dot)741(dot)camel(at)localhost(dot)localdomain>,
Neil Conway <neilc(at)samurai(dot)com> writes:

> I think the conclusion of past discussions about this feature is that
> it's a bad idea. Last I checked, MySQL has to clear the *entire* query
> cache when a single DML statement modifying the table in question is
> issued.

Nope, it deletes only queries using that table.

> Not to mention that the feature is broken for non-deterministic
> queries (like now(), ORDER BY random(), or nextval('some_seq'), and so
> on).

Queries containing now(), rand(), or similar functions aren't cached by MySQL.

In response to

pgsql-performance by date

Next:From: Aaron WermanDate: 2004-09-27 16:43:38
Subject: Re: Caching of Queries
Previous:From: Bruce MomjianDate: 2004-09-27 14:17:56
Subject: Re: Caching of Queries

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