next up previous
Next: Checkpoints Up: PostgreSQL Hardware Performance Tuning Previous: File Systems

Multiple CPUs

POSTGRESQL uses a multi-process model, meaning each database connection has its own Unix process. Because of this, all multi-cpu operating systems can spread multiple database connections among the available CPUs. However, if only a single database connection is active, it can only use one CPU. POSTGRESQL does not use multi-threading to allow a single process to use multiple CPUs.


Bruce Momjian
2003-01-27