On Thu, 2002-02-07 at 19:13, mlw wrote:
> Justin Clift wrote:
>
> Also:
>
> Think of file handles. In a threaded version of postgreSQL, all
> connections will be competing for file handles. I think the limit in
> Linux is 1024.
From what I've seen we are more likely to hit the per-system file handle
limit when all separate forks open the same files over and over again,
so as the number of processes grows we will be worse off than usin the
same file handles for all connections in threaded mode.
> I think threading connections is a VERY bad idea. I am dubious that the
> amount of work will result in a decent return on investment.
This whole thread started with a notion that this has already been done
once and the idea was to investigate what could be brought over to main
forked-only (the threaded version could be forked at the same time)
codebase.
----------------
Hannu