Re: Opinion for using PostgreSQL for production please
Date: Tue, 16 Feb 2016 11:31:27 -0500
Message-ID: <CAJoeKmv+vxpdSkNnMWgeL+Limp+p+XD1YVbWBtA1pHgTZkcxAw_at_mail.gmail.com>
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_at_hpe.com> wrote:
> >> Maybe I'm wrong but I remember that happened with mysql before Oracle
> bought it. It was free and one day you had to pay for it. <<
>
>
>
> 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.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 16 2016 - 17:31:27 CET