| Postgres Weekly | Issue 71
September 3, 2014
|
| | Postgres multicolumn indexes to save the day | |
Indexes are great things that will make your database perform better, but in Postgres you have a few options from functional and conditional ones, to the different types - BTree, GIN, GiST, KNN, SP-GiST. Multicolumn indexes while maybe not your most commonly used, when needed can be extremely effective.
| | Julien Vehent |
|
| Replicated PostgreSQL with pgpool2 | |
If you’re running a Postgres installation yourself you want some form of replication setup. Of course there’s lots of options such as WAL-E and Barman, and then there’s PG Pool which handles quite a few things beyond just replication. Here’s your perfect guide for getting at least the replication and failover setup.
| | Michael Stapelberg |
|
| Streaming directly into Postgres with Hapi.js and pg-copy-stream | |
The copy command is extremely handy for bulk loading data, if you’re doing anything with inserting lots of data it’s what you want to use. Here’s an awesome example of a Node app taking advantage of just that and getting a 10x performance improvement over plain inserts.
| | Graham Jenson |
|
| |
|
