Re: select count() out of memory

> this is my config
>
> checkpoint_segments = 96
> effective_cache_size = 128000
> shared_buffers = 430000
> max_fsm_pages = 208000
> max_fsm_relations = 10000
>
> max_connections = 1000
>
> autovacuum = off # enable autovacuum subprocess?
>
> fsync = on # turns forced synchronization on
> or off
> #full_page_writes = on # recover from partial page writes
> wal_sync_method = fdatasync
> wal_buffers = 256
>
> commit_delay = 5
> #commit_siblings = 5 # range 1-1000

Now that you hopefully understand more about the server i am building,
does anybody got any suggestions on improvements of the config? I could
certainly reduce the max_connections to 1/10. but are there other
configurations that could either be reduced or increased or even set to a
non default value?

regards

thomas