Actions for heavy users of temporary tables
If you are a heavy user of temporary tables in your applications, then there are some additional actions you may need to perform.
There are four main things to check, which are as follows:
- Make sure you run VACUUM on system tables, or enable autovacuum to do this for you.
- Monitor running queries to see how many and how large temporary files are active.
- Tune memory parameters. Think about increasing the temp_buffers parameter, though be careful not to overallocate memory by doing so.
- Separate temp table I/O. In a query intensive system, you may find that read/write to temporary files exceeds reads/writes on permanent data tables and indexes. In this case, you should create new tablespace(s) ...