Josh Berkus wrote:

Forget hyperthreading. Look at their postgresql.conf settings. 8mb shared

mem, 16mb sort mem per connection for 512 connections, default effective_cache_size.

Umm...its 64Mb shared buffers isn't it ?

However agree completely with general thrust of message.... particularly the 16Mb of sort mem / connection - a very bad idea unless you are running a data warehouse box for only a few users (not 512 of them...)



---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to