Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables - Mailing list pgsql-performance

From Michael Glaesemann
Subject Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables
Date
Msg-id D74A0EF0-06B2-11D9-91A2-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables
Next
From: Christopher Browne
Date:
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables