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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to