firebird X postgresql 8.1.2 windows, performance comparison - Mailing list pgsql-performance

From andremachado
Subject firebird X postgresql 8.1.2 windows, performance comparison
Date
Msg-id 20060314120200.M31128@techforce.com.br
Whole thread Raw
Responses Re: firebird X postgresql 8.1.2 windows, performance comparison  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: firebird X postgresql 8.1.2 windows, performance comparison  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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

pgsql-performance by date:

Previous
From: Chris
Date:
Subject: Re: import performance
Next
From: "mcelroy, tim"
Date:
Subject: Re: PG Statistics