Olá Marcos,
> My original query, which worked for some days and then went to
> recovery mode
> was ...
If it was working and then ceased to function, did any of the following
occur:-
1) Postgres version changed?
2) OS version changed?
3) Schema changes affecting the tables/views used in your query?
I assume that you have a development data base. Can you bump up the log
level on that, run the query and see any errors in the log.
Cheers,
Robert
