Re: PostgreSQL pre-fork speedup

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL pre-fork speedup
Date: 2004-05-05 15:57:07
Message-ID: 878yg6x3xo.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Rod Taylor <pg(at)rbt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2004-05-05 16:06:20 Re: inconsistent owners in newly created databases?
Previous Message Bruce Momjian 2004-05-05 15:38:34 Re: ALTER TABLE TODO items