firebird X postgresql 8.1.2 windows, performance comparison

From: "andremachado" <andremachado(at)techforce(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: firebird X postgresql 8.1.2 windows, performance comparison
Date: 2006-03-14 12:02:49
Message-ID: 20060314120200.M31128@techforce.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 Content-Type Size
sql_query_problem.txt.tar.gz application/x-gzip 6.8 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message mcelroy, tim 2006-03-14 13:50:04 Re: PG Statistics
Previous Message Chris 2006-03-14 06:28:34 Re: import performance