Groups > comp.databases.postgresql > #631

Re: will cassandra, riak, or hypertable obsolete pg?

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: will cassandra, riak, or hypertable obsolete pg?
Date	Mon, 16 Feb 2015 11:50:22 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	43
Message-ID	<pan.2015.02.16.11.51.01@gmail.com> (permalink)
References	<8abcf0be-97d0-4c11-869f-303f7e4bc1f7@googlegroups.com> <e7dba211-8fd8-4a54-a996-18acee97a9a6@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Mon, 16 Feb 2015 11:50:22 +0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="9dbb49b777b4f27f09e09421fc52f8c8"; logging-data="23500"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/1bsBAWBgz4CmnFKe/4zLk"
User-Agent	Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock	sha1:JyPhSPczbU89X+KG8LNGA5LbEeI=
Xref	csiph.com comp.databases.postgresql:631

Show key headers only | View raw

On Sun, 21 Dec 2014 20:30:18 -0800, johannes falcone wrote:

> On Wednesday, December 3, 2014 3:44:01 PM UTC-5, johannes falcone wrote:
>> why not?
> 
> Hypertable seems to replace postgresql.
> 
> why would that be a bad idea?

Some NoSQL databases seem to be more successful than PostgreSQL. MongoDB 
is the most prevalent among them. However, SQL technology is a golden 
standard, with many advantages like transaction management according to 
the ACID rules, standardization and tabular format. Tables are 
everybody's favorite tool and format. Relational technology has many 
advantages, but PostgreSQL is probably not a good candidate. PostgreSQL 
has many shortcomings:

- No parallelism without a 3rd party application
- Partitioning is a joke: no global indexes, no unique constraints on them
  either.
- My favorite gripe about hints still stands, despite the availability of 
  pg_hint_plan (http://pghintplan.sourceforge.jp/pg_hint_plan.html). This
  extension is largely ignored by PostgreSQL community, because of its 
  irrational obstinate attitude toward hints.

There are other problems, too. Text search is overly complex and hard to 
set, materialized views do not include "REFRESH" clause, a separate 
refresh materialized view command has to be used instead. However, the 
implementation of materialized views, together with the availability of 
the pg_hint_plan extension is a significant progress for otherwise 
stagnant community. With materialized views, real hot backup and a fairly
decent hint implementation, I would say for the first time that PostgreSQL 
is preferable to MySQL. The original MySQL still doesn't contain a hot 
backup utility and does not support materialized views. I am not 
following MariaDB or Drizzle so I don't know much about them.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Je suis Charlie

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

Thread

will cassandra, riak, or hypertable obsolete pg? johannes falcone <visphatesjava@gmail.com> - 2014-12-03 12:44 -0800
  Re: will cassandra, riak, or hypertable obsolete pg? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-12-03 22:14 +0100
    Re: will cassandra, riak, or hypertable obsolete pg? johannes falcone <visphatesjava@gmail.com> - 2014-12-09 19:32 -0800
  Re: will cassandra, riak, or hypertable obsolete pg? johannes falcone <visphatesjava@gmail.com> - 2014-12-21 20:30 -0800
    Re: will cassandra, riak, or hypertable obsolete pg? Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-16 11:50 +0000

csiph-web