sql - Cache size and sort size in postgreSQL -
reading the article posgtresql effective settings, came across cache size
, sort size
concepts. there said, these 2 sizes don't depend on each other.
both cache size , sort size affect memory usage, cannot maximize 1 without affecting other
googling didn't useful results. far got, cache size can viewed
select current_setting('shared_buffers') shared_buffers
this returns size of shared buffers (i.e. cache). sort size?
sort_mem parameter, mentioned in bruce's artice, same work_mem (e.g. http://postgresql.nabble.com/sort-mem-param-of-postgresql-conf-td1910195.html).
this parameter specifies amount of memory used sort , hash operations. part of local backend memory, while shared buffers reside in global memory of server.
see doc: http://www.postgresql.org/docs/9.4/static/runtime-config-resource.html
Comments
Post a Comment