From: | Frits Jalvingh <jal(at)etc(dot)to> |
---|---|
To: | |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Fwd: temp_file_limit? |
Date: | 2022-12-19 16:57:42 |
Message-ID: | CAKhTGFXkTstt5NUqfk=WWbKZW0h16hijjvtJM_yK_XMLiUuHyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
@justin:
Ran the query again. Top shows the following processes:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
COMMAND
650830 postgres 20 0 7503,2m 2,6g 2,6g R 100,0 4,2 12:46.34
postgres: jal datavault_317_prd [local] EXPLAIN
666141 postgres 20 0 7486,3m 2,6g 2,6g R 100,0 4,1 2:10.24
postgres: parallel worker for PID 650830
Your commands shows, during execution:
root(at)chatelet:/d2/var/lib/postgresql/15/main/base# du --max=2 -mx
./pgsql_tmp |sort -nr
68629 ./pgsql_tmp/pgsql_tmp650830.3.fileset
68629 ./pgsql_tmp
root(at)chatelet:/d2/var/lib/postgresql/15/main/base# du --max=2 -mx
./pgsql_tmp |sort -nr
194494 ./pgsql_tmp
194493 ./pgsql_tmp/pgsql_tmp650830.3.fileset
root(at)chatelet:/d2/var/lib/postgresql/15/main/base# du --max=2 -mx
./pgsql_tmp |sort -nr
335289 ./pgsql_tmp/pgsql_tmp650830.3.fileset
335289 ./pgsql_tmp
root(at)chatelet:/d2/var/lib/postgresql/15/main/base# du --max=2 -mx
./pgsql_tmp |sort -nr
412021 ./pgsql_tmp/pgsql_tmp650830.3.fileset
412021 ./pgsql_tmp
^^^ a few seconds after this last try the query aborted:
ERROR: temporary file size exceeds temp_file_limit (104857600kB)
One possibility is that there are files in the tmpdir, which have been
> unlinked, but are still opened, so their space hasn't been reclaimed.
> You could check for that by running lsof -nn |grep pgsql_tmp Any deleted
> files would say things like 'DEL|deleted|inode|no such'
>
I do not really understand what you would like me to do, and when. The disk
space is growing, and it is actual files under pgsql_tmp?
Hope this tells you something, please let me know if you would like more
info, and again - thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2022-12-19 17:15:43 | Re: Fwd: temp_file_limit? |
Previous Message | João Paulo Luís | 2022-12-19 16:50:56 | RE: Postgres12 looking for possible HashAggregate issue workarounds? |