Re: Data Warehouse Reevaluation - MySQL vs Postgres --

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: simon(at)2ndquadrant(dot)com, Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: 2004-09-15 17:28:08
Message-ID: 200409151028.08461.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joe,

> - the use of inherited tables to partition this huge number of rows and
> yet allow simple query access to it seems to work well, at least in
> early validation tests
> - had we simply taken the original database and "slammed" it into
> Postgres with no further thought, we would not have seen the big
> improvements, and thus the project might have been seen as a failure
> (even though it saves substantial $)

Any further thoughts on developing this into true table partitioning?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Conway 2004-09-15 17:34:53 Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Previous Message Jeffrey W. Baker 2004-09-15 16:11:37 Re: disk performance benchmarks