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...)
regards
Mark