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" <[email protected]>
To: "Rod Taylor" <[email protected]>
Cc: "Hannu Krosing" <[email protected]>; "Dann Corbit"
<[email protected]>; "Greg Sabino Mullane" <[email protected]>;
<[email protected]>
Sent: Monday, March 04, 2002 4:50 PM
Subject: Re: [HACKERS] Database Caching
> "Rod Taylor" <[email protected]> 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
>
