1. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.
2. Teradata :
Teradata is an RDBMS that is produced by Teradata Corp. And it is used to manage large data warehousing operations. Teradata Corporation is a provider of database and analytics-related software, products, and services. It accepts the number of requests from multiple client applications.
Difference between PostgreSQL and Teradata :
|1||It is developed by PostgreSQL Global Development Group in 1989.||It is developed by Teradata Corp. in 1984.|
|2||PostgreSQL server operating systems are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.||Teradata server operating systems are Linux, hosted.|
|3||The primary database model for PostgreSQL is Relational DBMS.||The primary database model for Teradata is Relational DBMS.|
|4||It is a open source software framework.||It runs world’s largest commercial databases.|
|5||Famous companies like National Audubon Society, Inc., FreshRealm, LLC, TIME Systems etc uses PostgreSQL.||Famous companies like Cognizant, Capgemini, aws, Cisco, Citibank, etc use Teradata.|
|6||It do not support In-memory capabilities.||It support in-memory capabilities.|
|7||It provides us with Immediate Consistency method to ensure consistency in a distributed system.||It also provides us with Immediate Consistency method to ensure consistency in a distributed system.|
|8||It supports Master-Slave Replication.||It supports both Master-Slave Replication and Master-Master Replication.|
|10||It provides access rights for users and roles.||It provide fine grained access rights according to SQL-standard.|