Josh Berkus wrote:
Forget hyperthreading. Look at their postgresql.conf settings. 8mb sharedUmm...its 64Mb shared buffers isn't it ?
mem, 16mb sort mem per connection for 512 connections, default effective_cache_size.
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...)
regards
Mark
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend