Обсуждение: PG Partition Manager (pg_partman) 2.0.0RC1

Поиск
Список
Период
Сортировка

PG Partition Manager (pg_partman) 2.0.0RC1

От
Keith Fiske
Дата:
The next major version of pg_partman is soon to be released. Looking for some feedback before then since there has been some significant changes (and this is my first time writing C!).

The biggest being there is now a background worker process (http://www.postgresql.org/docs/9.4/static/bgworker.html) for partition maintenance. This means, for most cases, a separate scheduler is no longer required. This also means that PostgreSQL 9.4 at a minimum is required for 2.0.0. See the README and doc file for more info on setting this up.

There are no longer distinct partition trigger types (static & dynamic). These have been combined into a single trigger format that better handles a wider range of incoming data to partition sets. https://github.com/keithf4/pg_partman/issues/40
Instructions for migrating existing partition sets can be found in the extension update file (pg_partman--1.8.6--2.0.0.sql).

New version is in it's own repo -  https://github.com/keithf4/pg_partman_v2RC1

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com