Adding on to this use case:
what do we do when we reach end of year?
Probably auto-archive as per weekly, monthly , quarterly or yearly tables?
On Thu, Jan 7, 2010 at 1:14 AM, Josh Berkus
<josh@agliodbs.com> wrote:
On 1/6/10 9:13 AM, Robert Haas wrote:
> On Wed, Jan 6, 2010 at 12:06 PM, David Fetter <
david@fetter.org> wrote:
>> On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote:
>>> Robert Haas wrote:
>>>> Getting full?
>>>>
>>>> ...Robert
>>>>
>>> Ok. Bad analogy. We have the tables setup to write data according
>>> to the month it was loaded. We have a December table, a January
>>> table and so on. Basically following the examples given on the 8.4
>>> web site.
FWIW, our roadmap is to add a 2nd type or partitioning which would be on
the sub-table level and much more automated for that reason.
--Josh Berkus
--
Chetan Sutrave
http://www.enterprisedb.com