Greg Stark wrote:
> Even on Solaris I'm sure parsing and preparing plans for all the queries,
> building up the system table cache for all the objects in the database, and so
> on are much much more expensive than fork(). I wouldn't be surprised if even
> on windows it was still a pretty close race.
Parsing/planning what queries? Regarding system caches, they are
populated from a cache file; they are not read from the catalogs each
time.
But while we don't see a patch implementing the idea, this is all very
theoretical and probably wrong.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support