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
Attachment:
sql_query_problem.txt.tar.gz
Description: GNU Zip compressed data
