On Mon, Aug 14, 2017 at 4:16 PM, Jerry Sievers <gsiever...@comcast.net> wrote: > Scott Marlowe <scott.marl...@gmail.com> writes: > >> You do know that temp tables go into the default temp table space, >> just like sorts, right? > > Not so. > > This system has no defined temp_tablespace however spillage due to > sorting/hashing that exceeds work_mem goes to base/pgsql_tmp which we > have symlinked out to a local SSD drive.
Which is also where temp tables are created. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
