Re: [RFC] GSoC Work on readonly queries done so far - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: [RFC] GSoC Work on readonly queries done so far
Date
Msg-id 46673AD2.30403@tocr.com
Whole thread Raw
In response to Re: [RFC] GSoC Work on readonly queries done so far  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> Simon Riggs wrote:
>> On Wed, 2007-06-06 at 12:17 -0400, Matthew T. O'Connor wrote:
>>> Florian G. Pflug wrote:
>>>> Work done so far:
>>>> -----------------
>>>>  .) Don't start autovacuum and bgwriter. 
>>> Do table stats used by the planner get replicated on a PITR slave?  I 
>>> assume so, but if not, you would need autovac to do analyzes.
>> The replication is an exact block-level replication of the master. We
>> can't write very much at all on the slave.
> 
> Hmm, something to keep in mind is forcing cache invals when the master
> causes them (for example relation cache, catalog caches and plan
> caches).


Perhaps if you are as PITR master and you have active readonly slaves 
then there should be a WAL record to note plan invalidations, etc?


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [RFC] GSoC Work on readonly queries done so far
Next
From: "Marc G. Fournier"
Date:
Subject: Re: How do we create the releases?