On Tue, Feb 9, 2016 at 10:10 PM, ioan ghip <ioan@xxxxxxxxxxxxxxx> wrote: > I have a Firebird SQL database running on one of my servers which has about > 50k inserts, about 100k updates and about 30k deletes every day. There are > about 4 million records in 24 tables. I have a bunch of stored procedures, > triggers, events and views that I'm using. > Firebird works fairly well, but from time to time the database gets > corrupted and I couldn't figure out yet (after many years of running) what's > the reason. When this happens I run "gfix -mend -full -ignore", backup and > restore the db and everything is fine until next problem in a week, or a > month. > > I never used PostgreSQL. Yesterday I installed it on my development machine > and after few tests I saw that it's fairly easy to use. > Does anyone have experience with both, Firebird and PostgreSQL? yes > Is PostgreSQL way better performing than Firebird? yes > Is it worth the effort moving away from Firebird? yes > Would I gain stability and increased performance? yes Firebird was and is a pretty neat database. I still remember when I first fired up Delphi and whipped out an application in about 10 minutes. Well, it's time to move on...you're with us now. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
