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 190 — January 18, 2017
Two Simple Postgres Tricks to Kickstart Your 2017
A look at two useful tricks that, the author claims, even ‘power users find surprising’: disabling JOIN re-ordering and using arrays with LIKE.
Kaarel Moppel   #opinion 
Parallel Indexing in Citus
Indexes tend to make queries fast, but they come at a cost of write throughput. Read how Citus, a Postgres extension, can help parallelize queries to speed things up.
Citus Data
Josh Berkus Retires from the Core Team
After 14 years, Josh Berkus, long time contributor and core team member, has stepped down from the Postgres core team and wants to encourage fresh leadership for the project.
Josh Berkus   #news 
Bring observability to your database
Visualize and alert on system resources, connections, locks, transactions, and indexes for real-time full-stack performance monitoring.
Datadog    #sponsored 
Creating Triggers That Fire When You Create Functions
DBA Stack Exchange   #tutorial 
Another Couple of Steps On My Backup Crusade
A number of potential ways to improve your PG backups.
Magnus Hagander   #opinion 
Why Postgres
“given the alternatives, and what Postgres really delivers when it’s fully leveraged, I can’t even think of a better commercial RDBMS”
Shaun M.​ Thomas   #opinion 
PostgreSQL Inheritance
Table inheritance if often equated with partitioning in Postgres, but as highlighted here can be used from more traditional CS object inheritance if you so choose.
Software Thoughts
PostgreSQL WAL Archiving
Under the covers Postgres is one giant append-only log, which in correct technical terms is the write-ahead-log. Here you can find an overview of what it is and how to work with it.
RapidLoop
DreamFactory REST API platform for Postgres
Develop apps faster. DreamFactory automatically turns Postgres into a REST API platform in minutes.
DreamFactory    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.