Hello,
Attached is a file containing the problematic queries cited yesterday, with
"explain", "\di" and "show all" outputs.
The first one finished in almost 4 hours. Firebird for windows finished in 1m30s.
The second one CRASHED after some hours, without finishing. The error message
is at the file too.
I will ask my friend to reduce shared_buffers to 16000 as this number gave the
best results for his machine.
Do you have any suggestion?
Regards.
Andre Felipe Machado