temporary file size exceeds temp_file_limit

[azidahaka]

My database is suddenly hanging on some queries that join many tables and I see:

    temporary file size exceeds temp_file_limit (1025563kB)

A sample query and query plan can be seen here: https://pastebin.com/wug86Wrr

This query normally takes less than 100ms but hangs when hit temporary file size limit.

When I run:

    SELECT temp_files AS "Temporary files", temp_bytes AS "Size of temporary files"

    FROM pg_stat_database db;

I see:

    Temporary files  Size of temporary files

    ---

    22550          10651900248

How do I resolve this?

[Nicolas (Google Cloud Platform Support)]

Hi ,

As your issue seems to be a specific technical issue you would have better assistance from the community by posting in StackOverflow as Google Groups is intended for general discussion. You should post to StackOverflow with the extra log information to have the developer community assist you.

That being said, the temp_file_limit is a flag you can set. Please try increasing the assigned value and try the import again.

We have 3 ways to configure the flag (i.e. via Console, GCloud, or Curl). Can you please take a look at this doc  for the individual methods?

Please also note that temp_file_limit is listed under "Supported flags" section.