Postgres got JSON support years ago, and it only improved with JSONB. Just now ORMs and libraries are getting support, including MassiveJS, a Node package with a novel approach to letting Postgres work as a document store.
Have you finally resolved to fix that nagging performance problem once and for all? Are you prepared for data growth in 2016? Now is the time to do a quick tune up. Evaluate your Postgres database performance with a rapid Architectural Health Check and ensure your system is optimally configured and tuned as you start the year.
Great speakers, enthusiastic attendees, lively networking, and standing room only sessions were all highlights of the first annual Postgres conference in the Bay Area.
If you’re new to what it means to have ‘full text search’ capabilities, this run through should give you a great primer on how it works in Postgres as well as some practical steps.
The most expensive operations in any Postgres database are generally aggregations. Whether it’s some sum, average, or most common counts, such operations often consume a large amount of time, but the agg extension looks to improve this.
Pg_repack is an interesting extension that lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes.
Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers.
