[Pgpool-general] Query Cache for Specific Tables?

[Taiki Yamaguchi]

Hi,

On Mon, 24 Sep 2007 23:03:52 -0700
David Jantzen <david.jantzen at comcast.net> wrote:

> Hi All,
> 
> Is it possible to cache query results only for specific queries or
> tables, or does caching work on all queries and tables?

pgpool-II caches all SELECT queries to all tables.
 
> If it's not possible to cache particular query results, is a feasible
> workaround to run two pgpool processes, one doing caching, one not?

You should be able to run two pgpool-II on different ports one with
caching, one not. Be aware that dead-locks could happen if you are not
careful enough about locking.

> 
> Thanks,
> David
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general


--
Taiki Yamaguchi
< yamaguchi @ sraoss.co.jp >