2 ms·
Yeah mysql-implementation sucks. And (from reading the discussions on pg-hackers) was that it's very hard to keep semantics (transactions, snapshot-isolation,
by ddorian43 12y ago
Yeah mysql-implementation sucks.
And (from reading the discussions on pg-hackers) was that it's very hard to keep semantics (transactions, snapshot-isolation, indexes etc).
Different storage-engines have different pros-cons (the same with indexes gin/gist). You could have:
in-memory storage engine (ex: current unlogged tables don't replicate since they don't have wal)
compressed (something like tokudb/mx)
columnar (see monetdb vs citus)
etc
It's harder to use another database because maintance + flexibility (ex: postgresql has arrays).
- tomiko_nakamura 12y agoPeople are working on other storage types for PostgreSQL. That's all I can say at this moment.
- ddorian43 12y agoStrange that they are working in secrecy. I would guess something like[1] would be better. [1]: http://www.postgresql.org/message-id/CA+U5nM+AFftDf-8UaMoe7Z8W6Sx-2EjFvEHephKQ=doEQ2Y1nQ@mail.gmail.com http://www.postgresql.org/message-id/CA+U5nM+AFftDf-8UaMoe7Z...
- ddorian43 12y agoMaybe you meant about this ? http://www.datanami.com/2015/03/04/fujitsu-adding-column-oriented-processing-engine-to-postgresql/ http://www.datanami.com/2015/03/04/fujitsu-adding-column-ori...