Re: Mnogosearch (Was: Re: website doc search is ... )

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.
>
>	
>  
>