pg_partman.git / summary / log
2013-01-11 a3b5c5db66a4 Docs update
Keith Fiske
2013-01-11 509042ba17b2 v0.2.0 Added child table retention management (dropping old ones). Documentation updates.
Keith Fiske
2013-01-04 18dbce354adb Added quarterly time partitioning. Fixed bug in run_maintenance. See CHANGELOG for more details.
Keith Fiske
2012-12-17 aa577b15f66c v0.1.1 Avoid needless trigger function re-creation in run_maintenance()
Keith Fiske
2012-11-19 47b07d7fe1f3 Merge pull request #1 from ea-cm/qualify-partition-type
Keith Fiske
2012-11-18 ffe5eb5fa48a Convert more hardcoded 'part' schema into @extschema@
Brad Ediger
2012-11-18 050eba204f40 Qualify partition_type in extschema
Brad Ediger
2012-10-01 86dd6826f08a Updated docs. Converted to postgresql extension format.
Keith Fiske
2012-10-01 39b936df3de6 Added functions to partition data from previously unpartitioned table. Added function to monitor parent tables for data. New ID based partitions will now start with partition for highest value if data already exists. Changed trigger to only ON INSERT for now. Made partition creation more efficient (shorter lock on parent).
Keith Fiske
2012-09-18 c022d2e060f9 More pg_jobmon integration. Now working in create_parent and time-based partition functions
Keith Fiske
2012-09-17 5610dcd40e0d Starting work on pg_jobmon integration. Now works for id partitioning. Static partitioning now inserts to parent on inserts outside monitored interval.
Keith Fiske
2012-09-12 54a9109917d2 Removed child tables inheriting constraints. Made them inherit indexes. If original parent table has data, it's no longer renamed, just left as the parent table.
Keith Fiske
2012-09-11 7191aca83927 Updating docs
Keith Fiske
2012-09-11 5d0fec7497ef Updating docs. Added Example to README file
Keith Fiske
2012-09-11 cf3ef9a3487f Updating docs. Added Example to README file
Keith Fiske
2012-09-11 59efeb1676ef Made simple install script and added installation instructions. Not yet in extension form
Keith Fiske
2012-09-11 ba2dd69a567f Renamed to PG Partition Mananger (pg_partman)
Keith Fiske
2012-09-11 c6da9403ebd6 Got id-dynamic working. Made partition creation functions handle if the partition already exists. Code cleanup
Keith Fiske
2012-09-11 642f6ea49437 id-static option now working. New id partition creation is based on table control column value and does not require run_maintenance()
Keith Fiske
2012-09-09 e01634e323de time-dynamic option now working
Keith Fiske
2012-09-09 7d942bf565ea Update docs
Keith Fiske
2012-09-09 63408a1e0365 Update docs
Keith Fiske
2012-09-09 4469730c29ab Update docs
Keith Fiske
2012-09-09 e46378bedde7 Update docs
Keith Fiske
2012-09-09 d15917a188b2 run_maintenance() function now working when run as a cronjob to keep time-based partitioning up to date. datetime_string now a config table value. Updated docs on how to use main create_parent() function.
Keith Fiske
2012-09-09 0d0502b3ec45 Fixed to correctly use ISO date format for weekly partitioning only. Changed to dedicated functions for time partition maintenance. Working on crontab function for time based partitioning
Keith Fiske
2012-09-08 addc0bb1a21c Added constraints to partition tables. Changed all date formats to ISO
Keith Fiske
2012-09-07 8ca84ba49f7c Made trigger function prettier
Keith Fiske
2012-09-07 763da1e08956 Fixed half-hour and quarter-hour function to point to correct tables. Made time-static function handle up to two partitions ahead. Simplified create_parent process for premaking partitions.
Keith Fiske
2012-09-06 428dc2b6fa79 Functions now working to create non-dynamic, time-based partitions, functions and triggers
Keith Fiske
2012-09-05 8326fb03611b Initial commit
Keith Fiske
[prev]