On Tue, 2005-10-18 at 16:35, Onyx wrote: > Hello Everyone, > Does anyone know if PostgreSQL supports running on dual processors, > and will efficiently utilize the dual processors for performance? > More specifically, will PostgreSQL utilize the dual processor > performance of using dual-core AMD chips? Any information would be > helpful... Yes. As long as it's on an OS that supports SMP, PostgreSQL can use >1 CPU. However, it each process can only use ONE CPU at at time, so if you only are running batch files or other single user type things, then the second CPU may not be as much use. OTOH, only certain data warehouse queries could really benefit from spreading a single query across multiple processors, so it's not a big deal for 95% of all postgresql installs. Note that there's usually plenty for the OS to do, so even in the case of datawarehousing, the second CPU often makes a marked difference in performance. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
