3 ms·
How many releases before JSON/JSONB support becomes stable? Looks like a lot of changes in this area. It also looks like a lot of performance improvements have
by illumen 12y ago
How many releases before JSON/JSONB support becomes stable? Looks like a lot of changes in this area.
It also looks like a lot of performance improvements have arrived. With the article the other day about how an intern found a 4x speed improvements for SELECT queries, it gives me hope that amazingly postgresql still has plenty of room to be sped up.
Just the SSL ECDH key exchange alone should dramatically improve the speed to fetch data. Also, pg_prewarm should reduce the time of the first queries to hit the database once a DB is restarted.
Looks like some NOSQL/Document databases can be replaced with postgresql quite nicely.
Whilst there are some improvements in the full text search, it seems things like SOLR are safe... for now.
It's nice to see more steps towards multi-master too.
- farresito 12y agoI think that improvement was from an external library, not from postgres itself.
- yangyang 12y agoThat query improvement was for a third-party extension storing data outside PostgreSQL (cstore_fdw), and has no effect on core Postgres.
- tracker1 12y agoI'm really hoping to see out of the box multi-master myself, not to mention I think that with the improved JSON/JSONB formats, that PLV8 will become more important in this space. With multi-master (or a better failover strategy in general), I can potentially drop MongoDB in favor of PostgreSQL, what has kept me from it is the HA strategy has been missing from the open/free/libre version, and the commercial support is cost prohibitive imho.