From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Joe Conway <mail@joeconway.com>
Subject: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Date: Wed, 15 Sep 2004 10:28:08 -0700
User-Agent: KMail/1.6.2
Cc: simon@2ndquadrant.com, Chris Browne <cbbrowne@acm.org>,
	pgsql-performance@postgresql.org
References: <28292295$109523922141480635ce12a8.90913606@config17.schlund.de>
	<41485CA6.1080505@joeconway.com>
In-Reply-To: <41485CA6.1080505@joeconway.com>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200409151028.08461.josh@agliodbs.com>

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