Re: Partition DB Tables by month

Romildo Wildgrube wrote:

> Hi,
>
> Is there a way to break the data files by month like in Oracle so that
> I can easely drop the tables on a monthly basis? Is this something
> postgres supports or is there a work around solution?

Hmm, as far as I know its not supported.
But I could think of a solution of a table per month
which are then hidden behind a view which does a UNION ALL
on all of them.
You could even automate the Adminostration of this via a Function.
I mean, in Oracle Partitions behave like single tables, so this would
simulate somethig similar.
But I think the Optimizer would not
be able to see that he must only access the table table_Jan_2003
if you are restricting on January 2003...

Cheers, Dani