Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 171 — August 24, 2016
Postgres The Good Parts: Arrays
Postgres is packed with great datatypes, one of them that may not get quite as much attention as JSONB is the Array type. This post starts with the basics then digs into some more advanced uses and operators of it to make things more practical.
Ryan Kelly
Problems with Concurrent Postgres Indexes (and How to Solve Them)
If you’re not familiar with concurrent indexing in Postgres, first off you should give them a look. Second, you should know they’re not without their issues which are walked through here.
Ken Alex Fassone   #tutorial 
Frustrating Proprietary Licences Pushing Moves to PostgreSQL
Several European institutions have cited complex licences from their traditional proprietary suppliers as an important reason to deploy PostgreSQL instead.
Adrian Offerman   #news 
Find Your Perfect Company Match
You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies.
Hired.​com    #sponsored 
Announcing Citus 5.2
Citus 5.2 is out which is an extension which makes it simple to shard your database, allowing you to scale out. The 5.2 release includes better ORM support, broader SQL coverage, and improved transactional semantics on a single shard.
Citus Data   #news 
Optimising PostgreSQL Database Queries using Indexes
An intro to indexes, what they are, how to create, as well as some more customized approaches. All of this with a focus on improving your apps performance.
RedPanthers   #tutorial 
Weighted Random Sampling with Postgres
Generating random data isn’t too hard, but generating a realistic sampling based on some weighting can be. This post walks you through how to do this in SQL, perfect for fake datasets.
Marco Santoni   #tutorial 
Walbouncer: A Proxy for Selective PostgreSQL Replication
With support for Postgres 9.5, Walbouncer is a standalone replication proxy, enabling selective replication by forwarding data only for specific databases/tablespaces to the connected replicas.
Kaarel Moppel   #tools 
Send slow queries to Slack, PagerDuty, HipChat, or/and email
Make the most of log_min_duration_statement. Get notified instantly or receive a daily summary (free).
Papertrail   #tools  #sponsored 
JsQuery: JSON Query Language with GIN Indexing Support
Postgres Professional   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.