Hello community, I am Firebird user for many years, I think I started using Interbase in 2001, and after that I use Firebird from version 1.0. I have a Firebird 2.5 Server in the company where I work, which stores some data for the purpose of business analysis. Since now it is September, many queries works relatively slow, due to a lot of data in the database. From the curiosity, I installed PostgreSQL yesterday on my laptop, migrated data from actual Firebird database to Postgresql, and compared time of execution on both system. On my great surprise, PostgreSQL was much faster tqan Firebird. I don't know nothing about tweak of PostgreSQL database, so I only migrated data, nothing else. I know that some of my views / queries are not optimized 100% on Firebird, but same situation is with PostgreSQL database which was just converted version of firebird. Query which gives me sales by product lines from begining of the year till yesterday was working on firebird server 22 seconds, and on PostgreSQL 2 seconds.
My laptop has SSD disc, but even when i put Firebird database on my laptop, query takes 16 seconds in Firebird. How is it possible that PostgreSQL is so much faster than Firebird? Regards, Zoran
