PostgreSQL SHOW work_mem shows 16GB but configured to 1024MB -


i'm working on postgresql 9.4 , wondering work_mem. if query

show work_mem; 

i get:

work_mem text 16gb 

however if grep config file (the file show config_file) get:

work_mem = 838860kb   # min 64kb work_mem = 1024mb     # pgtune wizard  

the configuration option 16gb temp_buffers. change work_memvalue?


Comments

Popular posts from this blog

How to get the arclen between two curve points in Maya? -

git svn - Unignore directories in git-svn (adding directories to a sparse checkout) -

C++ Linked List -