Re: Database Caching

Sorry, NOTIFY -- not NOTICE  (damn keyboard...)

Right now we're required to do a select against the database
periodically which means a test is required before hitting any cached
elements.  By the time you select true, might as well do the real
select anyway (normally simple index lookup).

The ability to receive one without making a query first would be very
advantageous.
--
Rod Taylor

This message represents the official view of the voices in my head

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Rod Taylor" <rbt@zort.ca>
Cc: "Hannu Krosing" <hannu@krosing.net>; "Dann Corbit"
<DCorbit@connx.com>; "Greg Sabino Mullane" <greg@turnstep.com>;
<pgsql-hackers@postgresql.org>
Sent: Monday, March 04, 2002 4:50 PM
Subject: Re: [HACKERS] Database Caching


> "Rod Taylor" <rbt@zort.ca> writes:
> > Rather than result caching, I'd much rather see an asynchronous
NOTICE
> > telling my webservers which have RULES firing them off when a
table is
> > modified.
>
> LISTEN/NOTIFY?
>
> regards, tom lane
>