title

text

Marco Slot
Marco Slot Citus Data
: December

CitusDB: an extension for Scaling out PostgreSQL

CitusDB is an extension for PostgreSQL that can distribute tables across a cluster of PostgreSQL servers. Data is stored in shards that can use append-partitioning for bulk-loading of time series data or hash-partitioning for real-time data ingestion. SELECT queries on distributed tables are transparently parallelised across the cluster, using all available cores. Distributed tables can also be joined in parallel, even if they are not partitioned along the same column. CitusDB is especially suitable for real-time analytics use-cases such as dashboards which require fast analytical queries over live data, and can simultaneously act as a scalable operational database. This talk will describe the internals of CitusDB and give a live demo of a large-scale CitusDB cluster.

Слайды

Видео

Другие доклады

  • Konstantin Evteev
    Konstantin Evteev X5 FoodTech
    45 мин
  • Mikhail Tyurin
    Mikhail Tyurin Avito
    22 мин

    My Five Slides About Postgres

    My experience of working with PostgreSQL has provided clear understanding of its main advantages, making us choose and recommend choosing it.
    1. Beginning
    2. Documentation
    3. Community
    4.1 Transactional DDL
    4.2 WAL and True Physical Replication
    4.3 Transactional Snapshot and True Logical Replication and PGQ
    4.4 Exciting extensibility
    5. Success

  • Дмитрий Воронин
    Дмитрий Воронин ОАО "НПО РусБИТех"
    22 мин

    The base version of DBMS PostgreSQL can register events bellow: - connect and disconnect - denial of access with date, time and user's name.

    Requirements guidelines for audit subsystem is much wider possibilities basic version of database PostgreSQL.

    The RusBITech company holds the necessary improvements PostgreSQL database to enhance it's functionality.

    A result of improvements audit subsystem of PostgreSQL database as part of the operating system «Astra Linux Special Edition» further enables registration:

    • The creation and destruction of database objects;
    • Changes to the rules of access control;
    • Both failures and successful attempts to access the database objects;
    • Changes to the powers and status of subjects access objects access.

    For all events are specified: - date and time; - The user performing the action of the registrant; - The object on which the action is carried out; - Type of event; - The result of the operation.

    Audit subsystem of modified PostgreSQL is integrated into a centralized audit system OS «Astra Linux Special Edition». Provided the rules setting without stopping the logging (restarting) database.

  • Ivan Frolkov
    Ivan Frolkov Postgres Professional
    90 мин