DBMS > MonetDB vs. PostgreSQL vs. QuestDB
System Properties Comparison MonetDB vs. PostgreSQL vs. QuestDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||MonetDB Xexclude from comparison||PostgreSQL Xexclude from comparison||QuestDB Xexclude from comparison|
|Description||A relational database management system that stores data in columns||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||A high performance open source SQL database for time series data|
|Primary database model||Relational DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Time Series DBMS|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||MonetDB BV||PostgreSQL Global Development Group www.postgresql.org/developer||QuestDB Technology Inc|
|Initial release||2004||1989 1989: Postgres, 1996: PostgreSQL||2014|
|Current release||Jul2021-SP2, July 2021||16.1, November 2023|
|License Commercial or Open Source||Open Source Mozilla Public License 2.0||Open Source BSD||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no||no||no|
|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.|
|Implementation language||C||C||Java (Zero-GC), C++, Rust|
|Server operating systems||FreeBSD|
|Data scheme||yes||yes||yes schema-free via InfluxDB Line Protocol|
|Typing predefined data types such as float or date||yes||yes||yes|
|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.||no|
|SQL Support of SQL||yes SQL 2003 with some extensions||yes standard with numerous extensions||SQL with time-series extensions|
|APIs and other access methods||JDBC|
native C library MAPI library (MonetDB application programming interface)
native C library
streaming API for large objects
InfluxDB Line Protocol (TCP/UDP)
PostgreSQL wire protocol
|Supported programming languages||C|
|C PostgreSQL driver|
Rust over HTTP
|Server-side scripts Stored procedures||yes, in SQL, C, R||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding via remote tables||partitioning by range, list and (since PostgreSQL 11) by hash||horizontal partitioning (by timestamps)|
|Replication methods Methods for redundantly storing data on multiple nodes||none Source-replica replication available in experimental status||Source-replica replication other methods possible by using 3rd party extensions||Source-replica replication with eventual consistency|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID for single-table writes|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes through memory mapped files|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||Relational model with native time series support Column-based storage and time partitioned...|
|Competitive advantages||High ingestion throughput: peak of 4M rows/sec (TSBS Benchmark) Code optimizations...|
|Typical application scenarios||Financial tick data Industrial IoT Application Metrics Monitoring|
|Key customers||Banks & Hedge funds, Yahoo, OKX, Airbus, Aquis Exchange, Net App, Cloudera, Airtel,...|
|Licensing and pricing models||Open source Apache 2.0 QuestDB Enterprise QuestDB Cloud|
QuestDB Release Week #4
Building a faster hash table for high performance SQL joins
Is all data time series data?
Solving duplicate data with performant deduplication
QuestDB + Hacktoberfest 2023: 10 Years of Hacking
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Instaclustr: Fully Hosted & Managed PostgreSQL
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
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!
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.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
pgDash: In-Depth PostgreSQL Monitoring.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Conferences, events and webinars|
PostgreSQL 101: Database monitoring and optimization
|Recent citations in the news|
News MonetDB Solutions secures investment from ServiceNow
News In Memoriam Martin Kersten
A Closer Look at the Top 3 Embedded Databases: SQLite, RocksDB ...
CWI spin-off DuckDB Labs partners with MotherDuck, who raises ...
In-Process Analytical Data Management with DuckDB
provided by Google News
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ...
Timescale Introduces Dynamic PostgreSQL, an Alternative to ...
Google AlloyDB Omni: PostgreSQL-Compatible Database for On ...
PostgreSQL Takes a New Turn
Timescale's Dynamic PostgreSQL Makes Data Provisioning Elastic
provided by Google News
QuestDB snares $12M Series A with hosted version coming soon
QuestDB nabs $2.3M seed to build open source time series database
Read the Pitch Deck Database Startup QuestDB Used to Raise $12 ...
Comparing Different Time-Series Databases
Aquis Exchange goes live with QuestDB for real time monitoring
provided by Google News
Sr PostgreSQL DBA
Full Stack Developer
Share this page