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

From Simon Riggs
Subject Re: [RFC] GSoC Work on readonly queries done so far
Date
Msg-id 1181166078.26886.121.camel@silverbirch.site
Whole thread Raw
In response to Re: [RFC] GSoC Work on readonly queries done so far  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Wed, 2007-06-06 at 17:14 -0400, 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).

Many things will need to work radically differently.

Best we think of this as Research rather than Development.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [RFC] GSoC Work on readonly queries done so far
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: [RFC] GSoC Work on readonly queries done so far