Re: Postgresql and multithreading

From: "Steve Wolfe" <nw(at)codon(dot)com>
To: "PostgresSQL Hackers Mailing List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgresql and multithreading
Date: 2002-10-18 19:11:16
Message-ID: 009a01c276da$27963a20$7192f6cc@nervegas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On the recurring debate of threading vs. forking, I was giving it a fwe
thoughts a few days ago, particularly with concern to Linux's memory model.

On IA32 platforms with over 4 gigs of memory, any one process can only
"see" up to 3 or 4 gigs of that. Having each postmaster fork off as a new
process obviously would allow a person to utilize very copious quantities of
memory, assuming that (a) they were dealing with concurrent PG sessions, and
(b) PG had reason to use the memory.

I'm not entirely clear on threading in Linux - would it provide the same
benefits, or would it suddenly lock you into a 3-gig memory space?

steve

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jason Tishler 2002-10-18 19:39:31 Re: Postgres Windows Native Port
Previous Message Tom Lane 2002-10-18 18:51:12 Re: ECPG and bison