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

From Florian G. Pflug
Subject Re: [RFC] GSoC Work on readonly queries done so far
Date
Msg-id 4666EC75.1040000@phlo.org
Whole thread Raw
In response to Re: [RFC] GSoC Work on readonly queries done so far  ("Matthew T. O'Connor" <matthew@tocr.com>)
List pgsql-hackers
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.

Yes - everything that get wal-logged on the master gets replicated to
the slave. In my design, it isn't possible to do "analyze" on the slave,
because all datafiles are strictly readonly (well, with the small
exception of hit-bit updates actually).

greetings, Florian Pflug




pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [RFC] GSoC Work on readonly queries done so far
Next
From: "Florian G. Pflug"
Date:
Subject: Re: [RFC] GSoC Work on readonly queries done so far