|
On 10/02/2016 06:10, ioan ghip 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? Is PostgreSQL way better performing than Firebird?
Is it worth the effort moving away from Firebird? Would I gain
stability and increased performance?
Thanks.
Hello,
we have been running over 100 PostgerSQL servers (8.3) on remote
tanker vessels in harsh conditions
under heavy vibrations due to both weather and mechanical
vibrations, on commodity PC workstations
for years, and only one of them (hardware) was damaged beyond
repair (not PgSQL's fault).
In other cases with databases corrupted due to heavily damaged
disks, we managed to recover
and rescue all of the data except some few rows which could be
re-generated anyway.
PostgreSQL *is* a reliable DB.
About checksums in our office master DB that's a fine idea, too
bad that pg_upgrade doesn't cope with them
(and upgrading without pg_upgrade is out of the question)
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
|
