Re: Would like to know how analyze works technically

On Wed, April 1, 2015 12:30 pm, Igor Neyman [via PostgreSQL] wrote:
>>
>> TonyS <[hidden email]</user/SendEmail.jtp?type=node&node=5844292&i=0>>
>> wrote:
>>
>>
>
> name,current_setting,source autovacuum,off,configuration file
> synchronous_commit,off,configuration file TimeZone,localtime,configuration
> file unix_socket_directories,/var/run/postgresql,configuration file
> wal_buffers,8MB,configuration file work_mem,1536MB,configuration file
>
>
> ---
>
>
> ? work_mem,1536MB,configuration file
>
>
>
> IIRC, your RAM is 8GB. Your work_mem is too high. Actual memory used
> for sorting, etc... could be multiples of work_mem setting.
>
> That could be the reason for your memory problems. I'd suggest to set it
> to 16MB, and see if you can avoid "on disk" sorting. If not - gradually
> increase work_mem.
>
> Regards,
>
>
> Igor Neyman
>

Thanks Igor,

I will try changing that. I pretty much just let pgtune set all of those
values for me.

--
View this message in context: http://postgresql.nabble.com/Would-like-to-know-how-analyze-works-technically-tp5844197p5844318.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.