On Mon, 8 Mar 2004, mlists wrote: > Can PostgreSQL use multiple processors if they are present in a > computer, and if so, how much will it speed up database server? Tnx in > advance.
Yes, Postgresql can use >1 CPU. Each process can use one, and only one CPU by itself. however, the OS can use another CPU, and another user can use another CPU. The difference it makes depends greatly on your load. If your database application is CPU intensive, and currently CPU bound, then yes, of course, the extra CPUS will help. If your application is I/O / memory BW bound, then no, extra CPUs won't help much. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
