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 189 — January 11, 2017
Simple But Handy Postgres Features
Here’s a collection of a few simple but very handy Postgres features that will be useful for anyone who works with Postgres frequently.
Craig Kerstiens   #tutorial 
Tuning PostgreSQL with pgbench
pgbench is the norm when it comes to performance testing your Postgres database. Here you can learn how to use it to simulate a more realistic workload to assist with tuning your database.
Ben Cane   #tutorial 
Postgres 10 Highlight: Quorum Set of Synchronous Standbys
Being able to define quorum sets of synchronous standbys provides more flexibility in some availability scenarios.
Michael Paquier   #news 
PostgreSQL Security Audit With 2ndQuadrant Can Help Harden Your Database
Identifying database security vulnerabilities is the first step towards improving your infrastructure so that you don't fall victim to breach. A Security Audit with 2ndQuadrant evaluates and provides recommendations for the security of your database.
2ndQuadrant PostgreSQL Services    #sponsored 
PGConf US 2017 (Jersey City, March 28-31)
Early registration for this years PGConf US, taking place in March near NYC, is now open.
PGConf US   #news 
repmgr 3.3 Released
Simplifies the process of setting up databases with high availability and scalability requirements.
2ndQuadrant   #tools 
The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()
Window functions allow you to interact between rows in Postgres. For analytics they’re extremely powerful, and there’s a number of functions you can use with them. Here’s an overview of a few valuable ones and the differences.
jOOQ   #tutorial 
The Multi-Column Index of the Mysteries
Indexing is powerful in Postgres, with types, conditional, and functional indexes. While they can give you great performance, understanding the details can help you know what you’re getting. Here's a great read on multi-column ones and how they work.
The Build   #tutorial 
What Is The Purpose of PostGIS On PostgreSQL?
Why don’t we just use Postgres’ spatial functions? Paul Ramsey looks at the history.
Stack Exchange
Use kill -9 Only in an Emergency
kill -9 on Postgres will dramatically slow down its restart time.
Bruce Momjian   #opinion 
Barman v2.1 Announced
A minor release of the backup and recovery manager tool Barman, fixing a few bugs.
PostgreSQL   #tools 
One-Time Passwords with Google Authenticator PAM
Most people connect to Postgres with a standard username/password, but there’s a few more options. This highlights some of the flexibility of authentication you can use with PostgreSQL.
Ergo
'RustgreSQL': Could Postgres Be Ported to Rust?
Spoiler: Almost certainly not, but it was an interesting question.
Joel Jacobson
The Lead Developer 1-day conference for Tech Leads. 21 Feb, New York.
High-level sessions on growing an engineering organization with effective DevOps, going serverless and more.
White October Events    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.