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 182 — November 9, 2016
Postgres's 'Autovacuum' is Not the Enemy
Autovacuum in Postgres often gets a bad reputation, which is a little unfair. Here’s a look at how autovacuum helps with bloat and some guidance on tuning it.
Citus Data
Securing PostgreSQL [PDF]
Security is something all apps have to think about. Here’s some good general and Postgres specific guidance on all the things you need to think about as you manage your database.
Christophe Pettus   #tutorial 
A PostgreSQL 9.6 Patch for Instance Level Encryption
The patch automatically stores all the files of a cluster on disk in encrypted format and decrypts blocks as they are read from disk into shared buffers.
Cybertec   #tools 
[Webinar] What's New in MySQL 8.0 and PostgreSQL 9.6
In this recorded webinar, Baron Schwartz discusses some of the new features and capabilities available in MySQL 8.0 and PostgreSQL 9.6.
VividCortex    #sponsored 
Char(16) Conference: A Business Data Scalability Event in NYC
Tickets for the CHAR(16) conference, taking place in New York on December 6, are now available. Use code PGW50 for $50 off your ticket price. Focuses on Postgres.
Char Conference   #news 
Writing a RESTful API with Express and MassiveJS
MassiveJS is a library for working with Postgres in Node.
Alexis Hevia   #tutorial 
A Hands-On Experience with Complex SQL
Filmed at Keep Ruby Weird 2016. 21 minutes
Craig Kerstiens   #video 
PostgreSQL 9.6 Improves Synchronous Replication and More
“PostgreSQL 9.6 has given users plenty of reasons to upgrade.”
Josh Berkus   #opinion 
pg_party: Automatic Date-Range Partitioning Script for PG V9.1+
Erkan Durmus   #tools 
Locking PostgreSQL Shared Memory to Physical RAM
A way to avoid decrypted data getting leaked to disk, but encrypting your swap may be better.
ergo
Hunting PostgreSQL Bugs with SQLsmith
Slides from PGConf EU walking through a new tool SQLsmith, what type of testing it provides, and some of the results from using it with Postgres.
Credativ
Don't Get Frustrated - Get Hired
Hired puts the power back in your hands, by having companies apply to you, not the other way around. With Hired you only talk to companies you're interested in.
Hired    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.