0

as the question here what is difference between MaterializedPostgreSQL Engine and PostgreSQL Engine in Clickhouse?

MaterializedPostgreSQL will use replication slots and will physically replicate data from PostgreSQL to ClickHouse

PostgreSQL it's just a proxy table engine.

But the more important thing is. With the advantage of materializedPosgresSQL. Should I write data to Postgres instead of Clickhouse, and use Clickhouse with MaterializedPostgresSQL as the calculator to get report?

is that speed in clickhouse and speed of MaterializedPostgresSQL is the same? I think it should be the same. Because It feel like clickhouse do copy data from Postgres. But I'm not sure is it correct

Hiep Tran
  • 3,735
  • 1
  • 21
  • 29
  • 1
    Yes, MaterializedPosgteSQL databse contains *MergeTree tables underhood, and performance will the same as usual database atomic But you will have restrictions data will stored both on postgresql and clickhouse and you will have less control for replication if compare with custom data loading. – Slach Dec 03 '22 at 12:28

0 Answers0