Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables

On Sep 15, 2004, at 8:32 AM, Simon Riggs wrote:

> The "partitions" are just tables, so no need for other management 
> tools.
> Oracle treats the partitions as sub-tables, so you need a range of 
> commands
> to add, swap etc the partitions of the main table.
>
> I guess a set of tools that emulates that functionality would be 
> generically
> a good thing, if you can see a way to do that.
>
> Oracle partitions were restricted in only allowing a single load 
> statement
> into a single partition at any time, whereas multiple COPY statements 
> can
> access a single partition table on PostgreSQL.

How does this compare to DB2 partitioning?

Michael Glaesemann
grzm myrealbox com