Re: [RFC] GSoC Work on readonly queries done so far

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [RFC] GSoC Work on readonly queries done so far
Дата
Msg-id 1181166078.26886.121.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: [RFC] GSoC Work on readonly queries done so far  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [RFC] GSoC Work on readonly queries done so far
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: [RFC] GSoC Work on readonly queries done so far