Postgres Destination

Postgres also known as PostgreSQL, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres

Read The Docs

The different types of destinations

There is no one size fits all solution when it comes to databases, datalakes and data warehouses. Each one had different benefits and drawbacks which you can read more about here

Analytical vs Transactional

Analytical Data Stores (OLAPs)

The analytical data stores include normally all of the data warehouse vendors such as Snowflake, Redshift, Bigquery and many others. Analytical data stores are normally columnar data bases which are optimized for storing vast amounts of data at a decent price while at the same time allowing you to issue complex queries to understand your business data.
Using one of this solutions for operational queries where a lot of updating happens would be costly and inefficient.

Transactional Data Stores

Transactional Data Stores are more commonly used for operational workloads such as managing all the data from a web application. Common web solutions such as Wordpress rely on these type of data stores. Some examples are MongoDB, Postgresql, MySQL and many others.
These type of data bases can handle a huge volume of updates as users interact with the product.