Groups > comp.databases.postgresql > #249

Re: MySQL vs Postgres for a "data warehouse", 5-10 TB

From	Axel Schwenke <axel.schwenke@gmx.de>
Newsgroups	comp.databases.mysql, comp.databases.postgresql
Subject	Re: MySQL vs Postgres for a "data warehouse", 5-10 TB
Date	2011-09-11 18:11 +0200
Organization	xl@home
Message-ID	<v63vj8-su2.ln1@xl.homelinux.org> (permalink)
References	<H9idndjaqY3Xb_fTnZ2dnUVZ_sGdnZ2d@giganews.com> <vilain-F1171C.23304409092011@news.individual.net> <M9OdnSps5JUM6PbTnZ2dnUVZ_gGdnZ2d@giganews.com> <j4get5$1jc2$1@gal.iecc.com> <65Wdna3o9egcTfbTnZ2dnUVZ_uWdnZ2d@giganews.com>

Cross-posted to 2 groups.

Show all headers | View raw

Ignoramus13208 <ignoramus13208@NOSPAM.13208.invalid> wrote:
>>
>> A few moments spent looking at the MySQL manual reveals partitioned
>> tables and MERGE tables
>
> At first, I really liked your idea of a MERGE. It does fit my dataset
> very well.

I doubt that. MERGE is the much older and quite crappy sister of
partitioned tables. And since you claimed partitions would not fit,
MERGE won't too.

Also the MERGE engine is notoriously unstable. I expect to see
support for MERGE tables being dropped soon.

XL

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

MySQL vs Postgres for a "data warehouse", 5-10 TB Ignoramus5263 <ignoramus5263@NOSPAM.5263.invalid> - 2011-09-10 00:14 -0500
  Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Michael Vilain <vilain@NOspamcop.net> - 2011-09-09 23:30 -0700
    Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Luuk <Luuk@invalid.lan> - 2011-09-10 10:13 +0200
    Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Ignoramus13208 <ignoramus13208@NOSPAM.13208.invalid> - 2011-09-10 09:34 -0500
      Re: MySQL vs Postgres for a "data warehouse", 5-10 TB John Levine <johnl@iecc.com> - 2011-09-10 19:47 +0000
        Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Ignoramus13208 <ignoramus13208@NOSPAM.13208.invalid> - 2011-09-10 16:02 -0500
          Re: MySQL vs Postgres for a "data warehouse", 5-10 TB The Natural Philosopher <tnp@invalid.invalid> - 2011-09-11 15:40 +0100
          Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Axel Schwenke <axel.schwenke@gmx.de> - 2011-09-11 18:11 +0200
            Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Ignoramus21330 <ignoramus21330@NOSPAM.21330.invalid> - 2011-09-11 12:07 -0500
      Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Norman Peelman <npeelmandog@cfl.rr.com> - 2011-09-10 19:06 -0400
  Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2011-09-11 10:24 +0100
    Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Ignoramus21330 <ignoramus21330@NOSPAM.21330.invalid> - 2011-09-11 07:35 -0500
  Re: MySQL vs Postgres for a "data warehouse", 5-10 TB Bodo <bodo@nomail.org.invalid> - 2011-09-23 13:01 +0200

csiph-web