No upcoming presentations...

    If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants/customers/accounts and your database tables capture this natural relation. With smaller amounts of data (10s of GB), it’s easy to throw more hardware at the problem and scale up your database. As these tables grow however, you need to th...

    @ PGConf US 2017 [PgConf.US]
    Training

    If you’re building a SaaS application, you probably already have the notion of tenancy built in your data model. Typically, most information relates to tenants / customers / accounts and your database tables capture this natural relation. With smaller amounts of data, it’s easy to throw more hardware at the problem and scale up your database. As these tables grow however, you need to think abou...

    @ PGConf US 2017 [PgConf.US]
    Development

    Citus is a distributed database that scales out Postgres. By using the extension APIs, Citus distributes your tables across a cluster of machines and parallelizes SQL queires. This talk describes the Citus architecture by focusing on our learnings in distributed systems. We first describe how Citus leverages PostgreSQL's extension APIs. These APIs are rich enough to store distributed metadata, ...

    @ PGConf US 2016 [PgConf.US]
    Internals

    Column oriented data stores bring notable performance advantages for analytic workloads; and they have gained popularity as part of proprietary database solutions in the past few years. cstore_fdw is an open source columnar store for PostgreSQL. The extension follows the same data layout as Facebook's Optimized Row Columnar (ORC) format, and brings the following benefits: * Compression: Reduces...

    @ PGConf US 2015 [PgConf.US]
    General

    Citus scales out PostgreSQL through using the extension APIs. To do this, Citus shards and replicates data, performs distributed deadlock detection, and parallelizes queries across a cluster of machines.

    This talk describes the distributed systems challenges we faced at Citus and how we addressed them. In particular, we'll talk about three problems we tackled when scaling out Postgres:

    • ...

    @ PostgresConf US 2018
    Data