From: | "Private" <onion(at)taxi(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PostgreSQL pre-fork speedup |
Date: | 2004-04-29 18:35:24 |
Message-ID: | c6rhta$31cg$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I know the issue of pre-fork PostgreSQL has been discussed previously.
Someone mentionned pre-fork can be implemented when schemas become available
in PostgreSQL because there will be less of the need to run multiple
databases.
I think Oracle 7 uses pre-forking and it helps speed up the startup time
considerably. Often, there are cases where connection pooling or persistent
connection cannot be used efficiently (e.g. replicated or splitted databases
over hundreds of machines or where persistent connection opens up too many
idle connections). Instead, there's a big need to create a new connection on
every query and with PostgreSQL needing to fork on every incoming connection
can be quite slow.
Any chance of that happening for 7.5?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2004-04-29 18:38:27 | Re: PITR Phase 2 - Design Planning |
Previous Message | Simon Riggs | 2004-04-29 18:34:47 | Re: PITR logging control program |