Re: invalidating cached plans - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: invalidating cached plans
Date
Msg-id 42363B88.3060908@familyhealth.com.au
Whole thread Raw
In response to Re: invalidating cached plans  (Michael Adler <adler@pobox.com>)
List 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


pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: invalidating cached plans
Next
From: Rod Taylor
Date:
Subject: Re: invalidating cached plans