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

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: [RFC] GSoC Work on readonly queries done so far
Дата
Msg-id 46673AD2.30403@tocr.com
обсуждение исходный текст
Ответ на Re: [RFC] GSoC Work on readonly queries done so far  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [RFC] GSoC Work on readonly queries done so far
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: How do we create the releases?