# Database - General

Published articles for Database - General.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Postgres + ClickHouse Architectural Patterns

DevFeed: [Postgres + ClickHouse Architectural Patterns](<https://devfeed.tech/articles/postgres-clickhouse-architectural-patterns-19116.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/postgres-clickhouse-architectural-patterns/>)

Author: Agus Syafaat

Published: 2026-08-26T08:08:43Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [data-platforms](<https://devfeed.tech/topics/data-platforms.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Low Latency](<https://devfeed.tech/topics/low-latency.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [clustercontrol](<https://devfeed.tech/tags/clustercontrol.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [hybrid-operations](<https://devfeed.tech/tags/hybrid-operations.md>), [latency](<https://devfeed.tech/tags/latency.md>), [olap](<https://devfeed.tech/tags/olap.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [time](<https://devfeed.tech/tags/time.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

This article explains architectural patterns that combine PostgreSQL and ClickHouse. PostgreSQL serves as the authoritative transactional system for OLTP workloads, while ClickHouse handles large-scale analytical queries and real-time analytics. Continuous Change Data Capture synchronization connects the systems and separates transactional and analytical workloads.

### Source excerpt

The role of databases has shifted significantly as modern applications must deliver real-time analytics, dashboards, and machine learning alongside low-latency transaction processing. Handling these diverse demands with a single relational database has become unsustainable under growing data volumes. Consequently, organizations are adopting specialized database architectures where multiple engines work together based on their strengths, allowing [...] The post Postgres + ClickHouse Architectural Patterns appeared first on Severalnines.

## ClickHouse Schema Design and Data Modeling

DevFeed: [ClickHouse Schema Design and Data Modeling](<https://devfeed.tech/articles/clickhouse-schema-design-and-data-modeling-19112.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/clickhouse-schema-design-and-data-modeling/>)

Author: Agus Syafaat

Published: 2026-07-17T12:48:53Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data-modeling](<https://devfeed.tech/topics/data-modeling.md>), [distributed-systems](<https://devfeed.tech/topics/distributed-systems.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cta](<https://devfeed.tech/tags/cta.md>), [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distribution](<https://devfeed.tech/tags/distribution.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [production](<https://devfeed.tech/tags/production.md>), [schema](<https://devfeed.tech/tags/schema.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>)

### AI overview

This article explains how to design and maintain ClickHouse schemas in production. It covers distributed and local tables, shards and replicas, shard-key selection, operational concerns such as slow queries and oversized partitions, monitoring, and schema evolution.

### Source excerpt

Sometimes, we see ClickHouse queries that should normally complete in milliseconds take several seconds to finish or worse, time out entirely. When that happens, there is a good chance that the schema is the real culprit. The problem is often not the query itself, nor is it a hardware bottleneck. Instead, it can stem from [...] The post ClickHouse Schema Design and Data Modeling appeared first on Severalnines.

## Building a Modern Analytics Stack Around ClickHouse

DevFeed: [Building a Modern Analytics Stack Around ClickHouse](<https://devfeed.tech/articles/building-a-modern-analytics-stack-around-clickhouse-19109.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/building-a-modern-analytics-stack-around-clickhouse/>)

Author: Sebastian Insausti

Published: 2026-07-01T10:35:21Z

Content type: article

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [NVMe](<https://devfeed.tech/topics/nvme.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [IO](<https://devfeed.tech/topics/io.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-stack](<https://devfeed.tech/tags/analytics-stack.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cta](<https://devfeed.tech/tags/cta.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [databases](<https://devfeed.tech/tags/databases.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [olap](<https://devfeed.tech/tags/olap.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>)

### AI overview

This article explains how ClickHouse fits into a modern analytics stack alongside relational databases, Redis, and Prometheus. It describes ClickHouse as an open-source column-oriented DBMS for analytical workloads and discusses columnar storage, distributed processing, replication, and near-real-time ingestion.

### Source excerpt

Historically, relational databases did double duty. The same PostgreSQL / MySQL instance that handled your application's writes also answered your business questions. A well-indexed schema, a few GROUP BY reports, done. And that works, right up until it doesn't: the reports get slower, the dashboards start eating the same I/O budget as the application; or, [...] The post Building a Modern Analytics Stack Around ClickHouse appeared first on Severalnines.

## Managing ClickHouse Resources in Multi-Tenant Environments

DevFeed: [Managing ClickHouse Resources in Multi-Tenant Environments](<https://devfeed.tech/articles/managing-clickhouse-resources-in-multi-tenant-environments-19115.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/managing-clickhouse-resources-in-multi-tenant-environments/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-06-09T11:20:22Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [systems](<https://devfeed.tech/topics/systems.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cta](<https://devfeed.tech/tags/cta.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>)

### AI overview

This tutorial explains how to manage ClickHouse resources in multi-tenant environments. It discusses contention caused by shared CPU, memory, and disk resources, and describes identifying contention, scheduling workloads, and validating cluster stability.

### Source excerpt

When people first deploy ClickHouse, their initial reaction is often surprise. Queries that used to take minutes now finish in seconds. Dashboards feel instant even when reading billions of rows. To see this in action, here is a simple aggregation query running against a 200 million row events table: ClickHouse delivers exceptional speed, scanning 200 [...] The post Managing ClickHouse Resources in Multi-Tenant Environments appeared first on Severalnines.

## How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps

DevFeed: [How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps](<https://devfeed.tech/articles/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps-19114.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/how-to-migrate-from-sql-server-to-postgresql-ha-for-dockerized-apps/>)

Author: Jessie Baynas

Published: 2026-05-28T07:18:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Docker Compose](<https://devfeed.tech/topics/docker-compose.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>)

Tags: [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [database-general](<https://devfeed.tech/tags/database-general.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [devops](<https://devfeed.tech/tags/devops.md>), [failover](<https://devfeed.tech/tags/failover.md>), [migration](<https://devfeed.tech/tags/migration.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [validation](<https://devfeed.tech/tags/validation.md>)

### AI overview

This tutorial explains how to migrate a database from Microsoft SQL Server to PostgreSQL for Dockerized applications. It separates schema migration with pgloader from bulk data export using BCP and import with PostgreSQL COPY, and describes a setup involving streaming replication and ClusterControl for deployment, monitoring, and failover.

### Source excerpt

For many organizations, migrating from Microsoft SQL Server to PostgreSQL is no longer only about reducing licensing costs. The transition is often part of a broader modernization initiative focused on improving flexibility, scalability, and operational efficiency. PostgreSQL has evolved into one of the most mature open-source database platforms available today. It is widely adopted across [...] The post How to Migrate from SQL Server to PostgreSQL HA for Dockerized Apps appeared first on Severalnines.