Well, not only DELETEs but UPDATEs also treated differently in PostgreSQL.
It's due to the way PG implements MVCC. Oracle has REDO/UNDO, while PG
keeps older row versions until they are cleaned up by autovacuum
(background process) or "manual" vacuum initiated by the user.
This mechanism is very reliable gets improvements with each new version.
We have been using PostgreSQL in production environment for years.
We have lots of installations at our customer's sites.
Works pretty well, can't complain.
Regards,
Igor Neyman
On Tue, Feb 16, 2016 at 11:07 AM, Powell, Mark <mark.powell2@xxxxxxx> wrote:
bought it. It was free and one day you had to pay for it. <<Maybe I'm wrong but I remember that happened with mysql before Oracle
As far back as I can remember MySQL required a license for legal
commercial use. It was only free for personal use if you read the
license. The commercial license however was pretty cheap. I think it was
a $500 flat fee.
I have never used PostgreSQL but I have looked into it in the past. The
product has a pretty good reputation. When I looked at it (years ago) I
remember seeing one major drawback which had to do with how delete
operations were handled. I cannot remember the details and it may have
only applied to the index entries but rows were only logically deleted and
you had to run maintenance to physically remove the data and make space
available for reuse. This is likely no longer true.
