4 ms·

My favorite merged 9.4 features missing from this post: * GIN optimizations for smaller index size and faster search. This should mean faster full text searchi

by jeltz 13y ago

My favorite merged 9.4 features missing from this post: * GIN optimizations for smaller index size and faster search. This should mean faster full text searching * Time delayed replication standbys. * CHECK OPTION for auto updatable views, I believe the constraints were slightly relaxed on which views can be updatable too. * Replication slots looks promising, this should make it easy to setup a replication slave which does not have to be reinitialized on long network failures. No more WAL shipping needed. * Printing the planning time in the EXPLAIN output (only since I wrote it myself).

dc2447 13y ago
> Time delayed replication standbys Indeed, huge. Mysql has a relatively mature lag replica history now albeit via Percona. Adding delayed replicas to Postgres will be fantastic.
- radq 13y ago
  In what situations would a delayed replica be useful?
  - dc2447 13y ago
    > In what situations would a delayed replica be useful? When we start to have slightly larger databases (multi terabyte) then delayed replicas become a very useful backup and recovery strategy. Typically we need to recover databases when there has either been human error (someone deletes a bunch of data they should not have) or a compromise. In these situations rather than restoring for a nightly backup it is _always_ faster to roll a delayed replica forward and promote it to be master then resync all the normal replicas.