RPK wrote:
> How is FireBird rated when compared with PostgreSQL?
Firebird is a good db. But it has its spaces. Its is the little
brother of PG.
It has two modes: classic (spawn per connection, small caching) and
superServer (one program w/threads and lots of caching). superserver
does not run well on SMP. If you need SMP run classic.
The best part is the maintenance. Its very simple to setup and run and
requires no maintenance. I'd say for medium size its great, but for
huge, go PG.
Firebird does not span disks well (you can have multiple files, but
cannot tell what's in each file), no clustering, and poor replication
(3rd party only).
So, really, it depends on your needs.
-Andy