Re: Optimizing Read-Only Scalability

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Optimizing Read-Only Scalability
Дата
Msg-id 1242376259.3843.618.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Optimizing Read-Only Scalability  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Optimizing Read-Only Scalability  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Список pgsql-hackers
On Thu, 2009-05-14 at 16:21 -0700, Josh Berkus wrote:

> > So we can optimize away the scan through the procarray by doing two "if"
> > tests, one outside of the lock, one inside. In normal running, both will
> > be optimized away, though in read-only periods we would avoid much work.
> 
> How much work would it be to work up a test patch?

Not much. The most important thing is a place to test it and access to
detailed feedback. Let's see if Dimitri does this.

There are some other tuning aspects to be got right first also, but
those are already known.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add recovery_end_command option to recovery.conf.
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: New trigger option of pg_standby