Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-18 Thread Bruce Momjian
On Wed, Feb 10, 2016 at 10:34:53AM +0200, Achilleas Mantzios wrote: > 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) Just to clarify,

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-11 Thread Pierre Chevalier Géologue
Le 10/02/2016 18:08, John R Pierce a écrit : On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: PPS: how should I behave on this list: should I systematically "reply to all", or just "reply" to the list? I'm used to a number of mailing lists where a simple "reply" automatically replies to

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-11 Thread Pierre Chevalier Géologue
Le 10/02/2016 19:49, Adrian Klaver a écrit : Go here: https://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full=pgsql-general And in settings check: eliminatecc Select this if you do not want two copies when someone sends a message both to you and to the list.

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-11 Thread Merlin Moncure
On Tue, Feb 9, 2016 at 10:10 PM, 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

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-11 Thread Adrian Klaver
On 02/11/2016 05:42 AM, Pierre Chevalier Géologue wrote: Le 10/02/2016 19:49, Adrian Klaver a écrit : Go here: https://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full=pgsql-general And in settings check: eliminatecc Select this if you do not want two copies

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Andy Colson
On 2/9/2016 10:10 PM, 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

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Edson Richter
Em 10/02/2016 13:32, Andy Colson escreveu: On 2/9/2016 10:10 PM, 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

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread David G. Johnston
On Wed, Feb 10, 2016 at 10:08 AM, John R Pierce wrote: > On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: > > PPS: how should I behave on this list: should I systematically "reply to > all", or just "reply" to the list? I'm used to a number of mailing lists > where a

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread John R Pierce
On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: PPS: how should I behave on this list: should I systematically "reply to all", or just "reply" to the list? I'm used to a number of mailing lists where a simple "reply" automatically replies to the list, and the rule obliges you to *only*

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread ioan ghip
> Is this running as an embedded engine or a standalone server? One thing > about Firebird is that since it is embeddable, in that mode other > application bugs could corrupt the database. In the other case, I would > expect you may want to run hardware diagnostics to rule out hardware >

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Pierre Chevalier Géologue
Hello, Le 10/02/2016 08:43, Chris Travers a écrit : I have never seen database corruption on PostgreSQL that was not a result of either: 1. Use cases WAY out of the ordinary (and then only years ago and I reported a bug on this and it was very quickly fixed) 2. Hardware problems 3. Heat

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Adrian Klaver
On 02/10/2016 09:24 AM, David G. Johnston wrote: On Wed, Feb 10, 2016 at 10:08 AM, John R Pierce >wrote: On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: PPS: how should I behave on this list: should I systematically "reply to

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Karsten Hilbert
On Wed, Feb 10, 2016 at 01:14:42PM +0200, Achilleas Mantzios wrote: > >>About checksums in our office master DB that's a fine idea, too bad that > >>pg_upgrade doesn't cope with them > >I am sure you have considered "failing over" the master to an > >in-office slave which has got checksums

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Karsten Hilbert
On Wed, Feb 10, 2016 at 10:34:53AM +0200, Achilleas Mantzios wrote: PG on tankers: > About checksums in our office master DB that's a fine idea, too bad that > pg_upgrade doesn't cope with them I am sure you have considered "failing over" the master to an in-office slave which has got

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Achilleas Mantzios
On 10/02/2016 12:40, Karsten Hilbert wrote: On Wed, Feb 10, 2016 at 10:34:53AM +0200, Achilleas Mantzios wrote: PG on tankers: About checksums in our office master DB that's a fine idea, too bad that pg_upgrade doesn't cope with them I am sure you have considered "failing over" the master

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Achilleas Mantzios
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

[GENERAL] PostgreSQL vs Firebird SQL

2016-02-09 Thread ioan ghip
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,

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-09 Thread Chris Travers
Hi; On Wed, Feb 10, 2016 at 5:10 AM, 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

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-09 Thread David Grelaud
I confirm what Josh berkus said. The performance will not be a problem as soon as you manage your database very well (good configuration, good hardware, good queries, good data organisation...), like a lot of other competitors I think? We have never used Firebird but we use intensively PostgreSQL

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-09 Thread Josh berkus
On 02/10/2016 05:10 AM, 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