Re: invalidating cached plans

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: Michael Adler <adler@pobox.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Neil Conway <neilc@samurai.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2005-03-15T01:34:00Z

Lists: pgsql-hackers

> This may be totally irrelevant:
> 
> Our current load distributors, like pgpool, have no way of knowing the
> side effects of backend functions. It would be interesting if the
> client could send each potential query to the master saying, "execute
> this query if there are side effects, otherwise do no operation and
> and let me execute this read-only query on a replicated copy."

You can go 'SET TRANSACTION READ ONLY;' or something...

Chris