OSDN -- 開發和下載開源軟體
繁體中文翻譯狀態 translation status for zh-tw

RSS
Download List

專案描述

pgDynamicPartitions is a script that allows you to maintain a rolling window of daily table partitions under PostgreSQL. When called daily via cron, it will create x empty partitions into the future and keep only n partitions from the past 30 days, for example, and drop any that are older. It can be used with multiple tables, and each can be treated differently by calling it with different parameters via cron.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2012-01-24 07:23
1.3.20120119

This release is not a code change, but a change in the example table definitions. The way the example was doing the constraints before was causing query pruning not to work as expected. If your tables are partitioned with these new constraints, you can now do queries like "select * from foo where date(starttime) = ’2012-01-19′", and it will work as expected and only scan the partitions for the day 01-19. That assumes that ‘starttime’ is a timestamp column.

Project Resources

Project Page