Re: PostgreSQL pre-fork speedup

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: PostgreSQL pre-fork speedup
Дата
Msg-id 878yg6x3xo.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: PostgreSQL pre-fork speedup  (Rod Taylor <pg@rbt.ca>)
Ответы Re: PostgreSQL pre-fork speedup
Список pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:

> Cutting that count down to 10 idlers in total by having PostgreSQL
> prefork a specific database would make a significant difference.

Well it would be 10 for each database. Since as has been pointed out before
loading the database is most of the delay.

If that's enough why not just run 10 apache processes instead of 100? 

I'm assuming the static non-database driven content is already separated onto
other servers. In which case running 100 apache processes, most of which are
idle is the source of the problem.

-- 
greg



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

Предыдущее
От: sdv mailer
Дата:
Сообщение: Re: PostgreSQL pre-fork speedup
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE TODO items