Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #631

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

Show all headers | 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