| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
| Cc: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: CTEs and temp_buffers? |
| Date: | 2022-04-26 19:03:56 |
| Message-ID: | 254725.1650999836@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
MichaelDBA <MichaelDBA(at)sqlexec(dot)com> writes:
> Hi Tom,
> Of course, you're right! I got sidetracked thinking about temp_buffers
> with respect to temporary tables and not CTEs where work_mem stuff would
> apply. But back to the temp_buffers thing. Can you acknowledge that my
> thinking is right about that? That temporary table buffers if exceeding
> temp_buffers gets logged to the *<datadir>/base/pgsql_tmp* area and is
> not logged in the logs at all? My testing seems to confirm that.
No. Temp tables go into the same directories as regular tables.
The files have funny names though, following the format "tN_OID"
rather than just "OID".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikhil Shetty | 2022-04-27 11:08:59 | Postgres Stale Statistics |
| Previous Message | MichaelDBA | 2022-04-26 18:55:54 | Re: CTEs and temp_buffers? |