7 ms·
An Oracle DBA pointed out to me years ago that MySQL performed better under certain circumstances. It seems like PostGres does a pretty good job keeping up wit
by EzGraphs 14y ago
An Oracle DBA pointed out to me years ago that MySQL performed better under certain circumstances. It seems like PostGres does a pretty good job keeping up with Oracle features and is much more open and customizable. I am sure PostGres excels in many areas and is a suitable substitute for Oracle for many projects.
Does it have equivalent functionality to some of the more recent Oracle features like flashback queries and analytic functions (with windowing etc)? Are there any areas where Oracle clearly excels?
- lobster_johnson 14y agoPostgres has window functions, and I believe it supports the full ANSI windowing function feature set. Nothing like Oracle's flashback queries. It used to have a feature called time travel which allowed you to look at historical versions of data, something they could do thanks to MVCC. It was removed, presumably because it caused performance issues or was too complex to maintain.
- lobster_johnson 14y agoTime travel (http://www.postgresql.org/docs/6.3/static/c0503.htm http://www.postgresql.org/docs/6.3/static/c0503.htm) was deprecated in 6.2. > There are several reasons for this: performance impact, storage size, and a pg_time file which grows toward infinite size in a short period of time.