Create entry

Postgres vs. Apache Hadoop

Postgres Apache Hadoop + Add column
Description Relational Database System Huge Data Management
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Operating system
Programming language
Website www.​postgresql.​org hadoop.​apache.​org
Multilingual content Yes ?
Database model
Query language
Transactions Yes No
Unicode Yes Yes
Referential integrity Yes No
Price rating ★★★★★ ★★★★☆
WYSIWYG-Editor No ?
Standard compliance Yes No
Sharding No Yes
Replication Yes Yes
Map and reduce No Yes
Revision control Yes Yes
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes No
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Software distribution
Full text search Yes No
Preference (78% global votes) (28% global votes)
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★★ ★★★★☆
Lines of code 733 k ?
TTL for entries No Yes
Conditional entry updates Yes Yes
Composite keys Yes Yes
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes ?
Compression Yes Yes
Real time analytics Yes No
Creation Date 1989 ?
Community Driven Good ?
Shared nothing architecture Yes Yes
Web interface Yes Yes
Data encryption Yes ?
Secondary Indexes Yes Yes
Embeddable No Yes
Geospatial Indexes Yes No
Locking model ?
Data storage
Replication mode
Native driver
Cloud platform support ?
Online backup Yes Yes
Data types
Partial Index Yes No
Function Based Index Yes No
Log Yes Yes
Download www.​postgresql.​org/​download/​ hadoop.​apache.​org/​releases.​html
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★☆
In-Place Update Yes No
Free for commercial use Yes Yes
Sorts Yes Yes
Tuneable write concerns Yes Yes
Open Source Yes Yes
Triggers Yes ?
Perfomance ★★★★★ ★★★★☆
Materialized Views Yes ?
Spring Data Support Yes ?
Geospatial Yes ?
Text Analytics Yes ?
Server Side Java Script Yes ?
JSON Yes Yes
Stored Procedure Yes Yes
Free edition Yes Yes
SQL Queries Yes Yes
Network datatype Yes ?
CLI` Yes Yes
But can you use it on a cold rainy night in stoke? Yes ?
Does your boss understand it? Yes ?
Memory minimum ? 10 EB
Release Date ? September 2007
Value size max. ? 10 PB
WSDL ? Yes
Graph support ? Conditional
Implementation flexibility (0% global votes) (17% global votes)
Backup functionality ? Good
Capped Collections ? Yes
Geo-distributed ? No
Max rows in query result ? 9 999 999 999
24/7 support ? No
¿Es una Cagada? ? No
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
+ Add row ++
Postgres Apache Hadoop
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.