| Postgres Weekly |
Issue 90
January 28, 2015
|
|
| Better Monitoring with pg_stat_archiver in PostgreSQL 9.4 |
|
Postgres 9.4 introduced many improvements - one of the most exciting being JSONB. There’s also another key one that quietly snuck in that gives you more insight into where you’re at with your replication, helping you have more safety around your data.
|
| 2ndQuadrant |
|
| The Top 10 List for Planning a Postgres Deployment |
|
A well-prepared DBA considers their strategy for a Postgres rollout early. Thinking about key database questions in advance can make you the IT hero as you reveal a solid deployment plan that directly supports the goals of the business.
|
| EnterpriseDB Sponsored |
|
 |
| How to Bulk-Import JSON to Postgres |
|
Got lots of JSON data sitting around? You can quickly load it into Postgres to do more analysis, which is even easier with JSONB now.
|
| Hasan Diwan |
|
| Regular Expression Stop Words for Postgresql |
|
If Postgres’ text parsing out of the box isn’t enough for you, you can simply plug in your own. Here’s an awesome example of parsing out stop words, which can come in handy in lots of use cases.
|
| no0p |
|
| Incremental Backup with Barman 1.4.0 |
|
Barman, one of the two predominant solutions for disaster recovery (with the other being Wal-e), just got a major update, incremental backups which can help with both speed and size.
|
| 2ndQuadrant |
|
|
|
|