Skip site navigation (1) Skip section navigation (2)

Re: Data Warehouse Reevaluation - MySQL vs Postgres --

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "Joe Conway" <mail(at)joeconway(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: 2004-09-15 04:54:18
Message-ID: 000e01c49ae0$0f189e80$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Joe,

> That's exactly what we're doing, but using inherited tables instead of a
> union view. With inheritance, there is no need to rebuild the view each
> time a table is added or removed. Basically, in our application, tables
> are partitioned by either month or week, depending on the type of data
> involved, and queries are normally date qualified.

That sounds interesting. I have to admit that I havn't touched iheritance in
pg at all yet so I find it hard to imagine how this would work. If you have
a chance, would you mind elaborating on it just a little?

Regards
Iain


In response to

Responses

pgsql-performance by date

Next:From: Steve AtkinsDate: 2004-09-15 05:10:04
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables
Previous:From: Joe ConwayDate: 2004-09-15 04:30:24
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group