I am not sure how to resolve it. My query has more than 80K rows, the query worked for 7999 rows and throws this error "Result exceeded maximum size (556.308MB > 500MB)" even if the number of rows increase by one. What's strange is, when I have come across this issue I got busy with informing my manager on what's going on. Then I run it once again, at then it throws that error when I limit the query to 90K rows.
P.S. I did try increasing the time out after option under advanced tab.
Resource used - PostgreSQL
Thank you for getting back.