Re: SAPDB and mySQL

[Nicolai Tufar]

Probably you did not run VACUUM? It is a notorious anachronism in PostgreSQL. Or mayby you had to tune some queries?   But now as SAP/DB is gone. It may be worth to take a second look at Postgres.   Nicolai ----- Original Message ----- From: Detlef Schulze To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:45 PM Subject: Re: SAPDB and mySQL PostgreSQL is indeed a nice database, but IMHO there is one more thing that it lacks: performance. A couple of month ago I changed the database used by an application with only some tables but quite many rows in two tables from PostgreSQL to SapDB.   I notified a speed increase of much more than 400%   Bye bye PostgreSQL  ----- Original Message ----- From: Nicolai Tufar To: Sergio Samayoa ; Edgar Castanedo ; Ray Harrison ; [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 7:57 PM Subject: Re: SAPDB and mySQL I have used PostgreSQL extensively. It has everything you mentioned (PK, FK, Check constraints, triggers, stored procedure, selectavle stored procedures (functions?), transactional control). The only thing that PostgreSQL lacks to compete with Oracle and DB2 (and later SAP/DB by the way) directly is point-in-time recovery and hot backup. They promise to have this feature by July plus a native Win32 port which is also a must.   Regards, Nicolai