3 ms·
Who do people feel the need to mention Postgres on every post talking about MySQL... It reminds me the same problem with Linux and *BSD.
by Thaxll 10y ago
Who do people feel the need to mention Postgres on every post talking about MySQL... It reminds me the same problem with Linux and *BSD.
- infamouscow 10y agoWhat drives me mad is when people claim they choose PostgreSQL over MySQL because data integrity concerns, yet they run PostgreSQL on Linux as opposed to FreeBSD or Illumos using ZFS.
- dijit 10y agoPostgres' MVCC is almost like copy-on-write by itself, so anything more than a journal is overkill in any realistic scenarios. Personally we tried ZFS with PostgreSQL and we managed to fill the WAL drive before the vacuum could clear it out with our update rate. So we went back to XFS on the more commonly adopted (in our company); CentOS
- deleted 10y ago[deleted]
- EGreg 10y agoBSD > Linux Postgres > Mysql (in most cases) But larger learning curve
- dump121 10y agoThey are two competing open source databases, knowing strength/weakness of each is always good. So unless the answer is `we rock, you suck`, it would be a useful info. for lots of people
- threeseed 10y agoPostgreSQL has been mentioned on EVERY database post for years now. And it always involve an endless amount of condescension in particular directed at those that god forbid choose to use a NoSQL database. Everything seems to get turned into a competition despite the fact that the world have moved away from the centralised, vertically scaled database towards a more heterogenous landscape.