DBMS > PostgreSQL vs. Redis vs. TimesTen
System Properties Comparison PostgreSQL vs. Redis vs. TimesTen
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines
|PostgreSQL Xexclude from comparison
|Redis Xexclude from comparison
|TimesTen Xexclude from comparison
|Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL
|Popular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments Redis focuses on performance so most of its design decisions prioritize high performance and very low latencies.
|In-Memory RDBMS compatible to Oracle
|Primary database model
|Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
|Key-value store Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence
|Secondary database models
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Document store with RedisJSON
Graph DBMS with RedisGraph
Search engine with RediSearch
Time Series DBMS with RedisTimeSeries
|PostgreSQL Global Development Group www.postgresql.org/developer
|Redis project core team, inspired by Salvatore Sanfilippo Development sponsored by Redis Inc.
|Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005
|1989 1989: Postgres, 1996: PostgreSQL
|16.2, February 2024
|7.2.4, January 2024
|11 Release 2 (220.127.116.11.0)
|License Commercial or Open Source
|Open Source BSD
|Open Source source-available extensions (modules), commercial licenses for Redis Enterprise
|Cloud-based only Only available as a cloud service
|DBaaS offerings (sponsored links) Database as a Service
Providers of DBaaS offerings, please contact us to be listed.
|Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
|Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
|Server operating systems
Windows ported and maintained by Microsoft Open Technologies, Inc.
|Typing predefined data types such as float or date
|partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.
|yes specific XML-type available, but no XML query functionality.
|yes with RediSearch module
|SQL Support of SQL
|yes standard with numerous extensions
|with RediSQL module
|APIs and other access methods
native C library
streaming API for large objects
|proprietary protocol RESP - REdis Serialization Protocol
Oracle Call Interface (OCI)
|Supported programming languages
|Server-side scripts Stored procedures
|user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
|Lua; Redis Functions coming in Redis 7 (slides and Github)
|publish/subscribe channels provide some trigger functionality; RedisGears
|Partitioning methods Methods for storing different data on different nodes
|partitioning by range, list and (since PostgreSQL 11) by hash
|Sharding Automatic hash-based sharding with support for hash-tags for manual sharding
|Replication methods Methods for redundantly storing data on multiple nodes
|Source-replica replication other methods possible by using 3rd party extensions
|Multi-source replication with Redis Enterprise Pack
Source-replica replication Chained replication is supported
|MapReduce Offers an API for user-defined Map/Reduce methods
|Consistency concepts Methods to ensure consistency in a distributed system
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
|Immediate Consistency or Eventual Consistency depending on configuration
|Foreign keys Referential integrity
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data
|Atomic execution of command blocks and scripts and optimistic locking
|Concurrency Support for concurrent manipulation of data
|yes Data access is serialized by the server
|Durability Support for making data persistent
|yes Configurable mechanisms for persistency via snapshots and/or operations logs
|yes by means of logfiles and checkpoints
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.
|User concepts Access control
|fine grained access rights according to SQL-standard
|Access Control Lists (ACLs): redis.io/docs/management/security/acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/docs/management/security/encryption
|fine grained access rights according to SQL-standard
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services
|pgDash: In-Depth PostgreSQL Monitoring.
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
Instaclustr: Fully Hosted & Managed PostgreSQL
Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Redgate webinars: A series of key topics for new PostgreSQL users.
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
|Redisson PRO: The ultra-fast Redis Java Client.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
CData: Connect to Big Data & NoSQL through standard Drivers.
Navicat for Redis: the award-winning Redis management tool with an intuitive and powerful graphical interface.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts
PostgreSQL is the DBMS of the Year 2023 Snowflake is the DBMS of the Year 2022, defending the title from last year
Snowflake is the DBMS of the Year 2022, defending the title from last year
PostgreSQL is the DBMS of the Year 2018 MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MongoDB is the DBMS of the year, defending the title from last year
|Recent citations in the news
Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL major version 16
First Principles: Optimizing PostgreSQL for the cloud
Generally Available: Support for Cross Region Restore for PostgreSQL backups | Azure updates
OCI Database: Oracle Embraces PostgreSQL
VMware and Google Cloud Announce Planned PostgreSQL-Compatible Database Solution for Traditional and ...
provided by Google News
New Redis attack campaign weakens systems before deploying cryptominer
New Mingo Malware Attacking Linux Redis Servers To Mine Cryptocurrency
AWS announces vector search for Amazon MemoryDB for Redis (Preview)
In-memory database Redis wants to dabble in disk
provided by Google News
Share this page