[google-cloud-sql-discuss] Re: temporary file size exceeds temp_file_limit

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.

On Monday, March 25, 2019 at 12:32:26 PM UTC-4, azidahaka wrote:

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?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2a691d53-971f-4490-9c6d-c9a4fed9b56a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.