While you are in there - consider looking at effective_cache_size too.
Set it to something like your average buffer cache memory.
As I understand this, it only effects the choices of possible plans - so
with the default (1000) some good ones that use more memory may be
ignored (mind you - some really bad ones may be ignored too).
best wishes
Mark
Tom Lane wrote:
>
>
>>is this something that can be set database wide,
>>
>>
>
>Yeah, see default_statistics_target in postgresql.conf.
>
>
>
>
