Re: Caching of Queries

From: Matt Clark <matt(at)ymogen(dot)net>
To: Mitch Pirtle <mitch(dot)pirtle(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Caching of Queries
Date: 2004-09-27 20:19:12
Message-ID: 415875C0.3010805@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>Basically you set a default in seconds for the HTML results to be
>cached, and then have triggers set that force the cache to regenerate
>(whenever CRUD happens to the content, for example).
>
>Can't speak for Perl/Python/Ruby/.Net/Java, but Cache_Lite sure made a
>believer out of me!
>
>
>
Nice to have it in a library, but if you want to be that simplistic then
it's easy in any language. What if a process on server B modifies a n
important value that server A has cached though? Coherency (albeit that
the client may choose to not use it) is a must for a general solution.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2004-09-27 20:30:31 Re: Caching of Queries
Previous Message Aaron Werman 2004-09-27 20:11:53 Re: Caching of Queries