Re: PostgreSQL pre-fork speedup - Mailing list pgsql-hackers

From Greg Stark
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 878yg6x3xo.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (Rod Taylor <pg@rbt.ca>)
Responses Re: PostgreSQL pre-fork speedup  (Rod Taylor <pg@rbt.ca>)
List 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 by date:

Previous
From: sdv mailer
Date:
Subject: Re: PostgreSQL pre-fork speedup
Next
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE TODO items