On Tue, Dec 11, 2018 at 3:58 PM Ron <ronljohnsonjr@xxxxxxxxx> wrote: > On 12/10/2018 06:24 PM, Thomas Munro wrote: > > On Tue, Dec 11, 2018 at 2:56 AM Ron <ronljohnsonjr@xxxxxxxxx> wrote: > >> 2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS CDSLBXW 13748 SELECT > >> PostgreSQL JDBC Driver 53100 ERROR: could not write to tuplestore temporary > >> file: No space left on device > >> > >> I see this in the pg_log file, but #1 can't figure out what "tuplestore" is > >> (Google doesn't help), and #2 there's lots of space on all my file systems. > >> data/base, where pgsql_tmp lives, has 96GB free.) > > Maybe the setting log_temp_files could help you identify the query > > that is doing it? > > > > https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-TEMP-FILES > > Great idea; I've made the change. What do I grep for in the pg_log file? It should say something like: LOG: temporary file: path "base/pgsql_tmp/...", size ... STATEMENT: ... -- Thomas Munro http://www.enterprisedb.com
