Remove single-tenant-vs-multi-tenant
article thumbnail

Citus 12: Schema-based sharding for PostgreSQL

The Citus Data

Schema-based sharding gives an easy path for scaling out several important classes of applications that can divide their data across schemas: Multi-tenant SaaS applications Microservices that use the same database Vertical partitioning by groups of tables Each of these scenarios can now be enabled on Citus using regular CREATE SCHEMA commands.

article thumbnail

Understanding partitioning & sharding in Postgres & Citus

The Citus Data

The topic of this month's PGSQL Phriday #011 community blogging event is partitioning vs. sharding in PostgreSQL. It seemed right to share a perspective on the question of "partitioning vs. sharding" from someone in the Citus open source team, since we eat, sleep, and breathe sharding for Postgres.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Apache Ozone – A Multi-Protocol Aware Storage System

Cloudera

Apache Ozone , a highly scalable, high performance distributed object store, provides the ideal solution to this requirement with its bucket layout flexibility and multi-protocol support. Volume names must be unique and can be used for tenants or users. To start with, Ozone’s namespace includes the following conceptual entities: Fig.1

Storage 99
article thumbnail

Cloudera Flow Management Continuous Delivery while Minimizing Downtime

Cloudera

In this blog, we will explore an end-to-end life cycle of a data flow process that promotes continuous delivery with minimum downtime. These include but are not limited to multi-tenancy Access Control Lists (ACL), peer review, and release management. Control Multiple Tenants. Multi-Tenant Role Design Example.

article thumbnail

10 Most Popular Citus Data Blog Posts in 2018, ft. Postgres

The Citus Data

If you’re a regular on the Citus Data blog , you know our Citus database engineers love PostgreSQL. And another way we share our learnings is with our blog. So just in case you missed any of our best posts from last year, here is the TOP TEN list of the most popular Citus Data blogs published in 2018. BY SAMAY SHARMA.

Data 40
article thumbnail

Optimizing data warehouse storage

Netflix Tech

Design Principles For AutoOptimize to efficiently optimize the data layout, we’ve made the following choices: Just in time vs. periodic optimization Only optimize a given data set when required (based on what changed) instead of blind periodic runs. We will publish a follow-up blog post about AutoAnalyze in the future.

Storage 81
article thumbnail

Analyzing the Limits of Connection Scalability in Postgres

The Citus Data

This particularly is an issue in workloads that utilize long-lived connections combined with schema-based multi-tenancy. Unless applications implement some form of connection tenant association, each connection over time will access all relations for all tenants. More about that in my next blog post. Problem illustration.