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.