Question
Postgres query stop after 10 minutes
I have Managed Postgres instance, and a query that stops after 10 minutes.
The query is REFRESH MATERIALIZED VIEW xyz.
I kind looks like there is a limit for a query to run for 10 minutes. Can anyone tell what particular limit might come into play here?
The instance is 1 GB RAM / 1vCPU / 10 GB Disk / Primary only / FRA1.
The application is running spring boot and the Hikari connection pool.
First error message is 'SQLSTATE(57P01), ErrorCode(0)'
Second: FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command