From: | "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Greg Sabino Mullane <greg(at)turnstep(dot)com>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Database Caching |
Date: | 2002-08-26 01:35:24 |
Message-ID: | 1030325729.2626.176.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm not sure about query result caching or 'relation caching', since the
first would seem to run into problems with concurrent updates, and the
second is sort-of what the buffer cache does.
Query plan caching sounds like a really good idea though. Neil Conway's
PREPARE patch already does this for an individual backend. Do you think
it would be hard to make it use shared memory, and check if a query has
already been prepared by another backend? Maybe it could use something
like a whitespace insensitive checksum for a shared hash key.
Regards,
John Nield
On Sun, 2002-08-25 at 20:15, Bruce Momjian wrote:
>
> Do we want to add "query caching" to the TODO list, perhaps with a
> question mark?
>
> ---------------------------------------------------------------------------
>
> Greg Sabino Mullane wrote:
[snip]
>
--
J. R. Nield
jrnield(at)usol(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-08-26 01:41:34 | Re: [HACKERS] TODO Done. Superuser backend slot reservations |
Previous Message | Bruce Momjian | 2002-08-26 00:31:12 | Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? |