From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Slow Query, many tmpfiles |
Date: | 2020-02-03 13:09:21 |
Message-ID: | f5317b9b-8421-7c39-8a3e-d9371a05f326@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello, some simple query are very slow since a few days, no significant
changes are done the last days. I look for disk-io, swap, looked tables,
all seems to be good.
What I have found is this:
postgres=# SELECT temp_files AS "Temporary files"
, temp_bytes AS "Size of temporary files"
FROM pg_stat_database db;
Temporary files | Size of temporary files
-----------------+-------------------------
0 | 0
0 | 0
0 | 0
0 | 0
13542 | 5313912899891
(5 rows)
postgres(at)dolly:~/9.6/main/base/pgsql_tmp$ ls -la
total 20
drwx------ 2 postgres postgres 16384 Feb 3 02:25 .
drwx------ 8 postgres postgres 4096 Jul 26 2017 ..
Where does the 13542 tmp files are come from?
How can I delete that?
Where are they stored?
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Lembark | 2020-02-03 16:01:04 | Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI |
Previous Message | Andrei Zhidenkov | 2020-02-03 08:29:58 | Re: How to avoid UPDATE on same data in table ? |