| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | does work_mem is used on temp tables? |
| Date: | 2018-10-11 06:56:48 |
| Message-ID: | CA+t6e1=O+9MWJ4MDxphf5AuQsUanPzYNGMidp-jK2y44VzOBvA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Hi,
Does the work mem is used when I do sorts or hash operations on temp
tables ? Or the temp_buffer that is allocated at the beginning of the
session is used for it ?
At one of our apps, the app create a temp table and run on it some
operations (joins,sum,count,avg ) and so on.. I saw in the postgresql.conf
that fs temp files are generated so I guested that the memory buffer that
was allocated for that session was too small. The question is should I
increase the work_mem or the temp_buffers ?
Thanks , Mariel.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2018-10-11 07:41:56 | Re: does work_mem is used on temp tables? |
| Previous Message | Mike Broers | 2018-10-10 19:29:44 | Re: root cause of corruption in hot standby |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2018-10-11 07:41:56 | Re: does work_mem is used on temp tables? |
| Previous Message | Vladimir Ryabtsev | 2018-10-10 10:59:53 | Re: Why could different data in a table be processed with different performance? |