"D. Dante Lorenso" <[EMAIL PROTECTED]> writes: > I'm running PostgreSQL 7.4 on a quad Xeon attached to a > beefy disk array. However, I am begining to wonder if this is > a waste of CPU power. > > I think I read somewhere that PostgreSQL is NOT multi-threaded. > But, will it be able to take advantage of multiple CPUs? Will > I have to run separate postmaster instances to get the advantage?
PG uses a separate backend process for each connection, so if you have multiple simultaneous connections they will use different CPUs. Single queries will not be split across CPUs. -Doug ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])