| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | andrew(at)tao11(dot)riddles(dot)org(dot)uk |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: does work_mem is used on temp tables? |
| Date: | 2018-10-11 07:58:06 |
| Message-ID: | CA+t6e1=+2N+SnS+jJg4BrFvFED8AQdzOzFMMgfEWVXKdKY_KWQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
great, thanks !
בתאריך יום ה׳, 11 באוק׳ 2018 ב-10:42 מאת Andrew Gierth <
andrew(at)tao11(dot)riddles(dot)org(dot)uk>:
> >>>>> "Mariel" == Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> writes:
>
> Mariel> Hi,
> Mariel> Does the work mem is used when I do sorts or hash operations on
> Mariel> temp tables ? Or the temp_buffer that is allocated at the
> Mariel> beginning of the session is used for it ?
>
> work_mem is used for sorts and hashes regardless of what type the
> underlying table (if any) is.
>
> temp_buffers is used to buffer the actual _content_ of temp tables.
>
> --
> Andrew (irc:RhodiumToad)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pavan95 | 2018-10-11 11:32:46 | Re: Null value returned by function pg_last_wal_receive_lsn() inLogical Replication |
| Previous Message | Andrew Gierth | 2018-10-11 07:41:56 | Re: does work_mem is used on temp tables? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam R. | 2018-10-12 16:27:45 | One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed) |
| Previous Message | Andrew Gierth | 2018-10-11 07:41:56 | Re: does work_mem is used on temp tables? |