Timeline for answer to Viewing disk usage of temporary buffers of running queries in Postgres by smbennett1974
Current License: CC BY-SA 3.0
Post Revisions
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 2, 2016 at 18:33 | comment | added | sudo |
It says things like 2016-06-02 11:24:43 PDT LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp20410.11", size 174272980. I'm assuming the size is in bytes and that it's creating a lot of ~200MiB temp files. I expect my queries to be using lots of temporary files because my tables are around 200GiB, and I've tuned Postgres for my machine with 64GiB of RAM.
|
|
| Jun 2, 2016 at 17:57 | vote | accept | sudo | ||
| Jun 2, 2016 at 14:00 | history | answered | smbennett1974 | CC BY-SA 3.0 |