[Pgpool-general] pgpool-II: Query cache expire time
Taiki Yamaguchi
yamaguchi at sraoss.co.jp
Mon May 21 02:01:00 UTC 2007
Hi,
On Sat, 19 May 2007 19:22:52 -0300
Arthur Turrini <atgnbk at gmail.com> wrote:
> Hi,
>
> I have the following scenario, "Client A" connecting through
> pgpool-II and "Client B" connecting directly:
>
> Client A: SELECT * FROM sasl.people; (it
> returns 30 records and get cached by pgpool) Client B: SELECT * FROM
> sasl.people; (it returns the same 30 records)
> Client B: INSERT INTO sasl.people VALUES (....); (inserts one
> record) Client B: SELECT * FROM sasl.people;
> (it now return 31 records) Client A: SELECT * FROM
> sasl.people; (it stills returns 30 records :( )
>
> How I can avoid that ? There's a way to set an expire time to
> pgpool's query cache?
Unfortunately, the only way to avoid this in the current version of
pgpool-II is to delete the cache by hand. We are planning on improving
the query cache function in the future.
--
Taiki Yamaguchi
>
> Regards,
>
> ---
> Arthur Turrini.
>
> PS: pgpool is a great product! keep the good job!
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
More information about the Pgpool-general
mailing list