On 07/18/2018 06:57 AM, Thomas Kellerer wrote:
Adrian Klaver schrieb am 18.07.2018 um 15:06:
In the chapter "Database File layout" the pgsql_tmp is explained as follows:
Temporary files (for operations such as sorting more data than can fit in
memory)
are created within PGDATA/base/p
Thomas Kellerer writes:
> But what about the (temp) space needed for e.g. sorting, grouping or
> intermediate results from CTEs or derived tables?
> Is that also controlled through the temp_tablespaces?
Yes.
regards, tom lane
Adrian Klaver schrieb am 18.07.2018 um 15:06:
>> In the chapter "Database File layout" the pgsql_tmp is explained as follows:
>>
>> Temporary files (for operations such as sorting more data than can fit
>> in memory)
>> are created within PGDATA/base/pgsql_tmp, or within a pgsql_tmp
>> su
On 07/18/2018 12:53 AM, Thomas Kellerer wrote:
In the chapter "Database File layout" the pgsql_tmp is explained as follows:
Temporary files (for operations such as sorting more data than can fit in
memory)
are created within PGDATA/base/pgsql_tmp, or within a pgsql_tmp
subdirectory of
In the chapter "Database File layout" the pgsql_tmp is explained as follows:
Temporary files (for operations such as sorting more data than can fit in
memory)
are created within PGDATA/base/pgsql_tmp, or within a pgsql_tmp subdirectory
of
a tablespace directory
However the documentat
