README.md in pgslice-0.4.1 vs README.md in pgslice-0.4.2

- old
+ new

@@ -357,11 +357,11 @@ ## Schema Updates Once a table is partitioned, here’s how to change the schema: - To add, remove, or modify a column, make the update on the master table only -- To add or remove an index, make the update on the master table and all partitions +- To add or remove an index, make the update on the master table and all partitions (for Postgres 11, make the update on the master table only) ## Declarative Partitioning Postgres 10 introduces [declarative partitioning](https://www.postgresql.org/docs/10/static/ddl-partitioning.html#ddl-partitioning-declarative). A major benefit is `INSERT` statements with a `RETURNING` clause work as expected. If you prefer to use trigger-based partitioning instead (not recommended), pass the `--trigger-based` option to the `prep` command. @@ -392,16 +392,10 @@ ## Reference - [PostgreSQL Manual](https://www.postgresql.org/docs/current/static/ddl-partitioning.html) - [PostgreSQL Wiki](https://wiki.postgresql.org/wiki/Table_partitioning) -## TODO - -- Command to sync index changes with partitions -- Disable indexing for faster `fill` -- ETA for `fill` - ## Related Projects Also check out: - [PgHero](https://github.com/ankane/pghero) - A performance dashboard for Postgres @@ -423,5 +417,14 @@ cd pgslice bundle install createdb pgslice_test bundle exec rake ``` + +To test against different versions of Postgres with Docker, use: + +```sh +docker run -p=8000:5432 postgres:10 +TZ=Etc/UTC PGSLICE_URL=postgres://postgres@localhost:8000/postgres bundle exec rake +``` + +On Mac, you must use [Docker for Mac](https://www.docker.com/docker-mac) for the port mapping to localhost to work.