title

text

Maksim Viharev
Maksim Viharev Alytics
17:00 06 February
45 мин

GreenHouseSQL as a scalable analytics system for postgresql, greenplum and clickhouse

At pgconf’17 I talked about our analytics systems based on PostgreSQL. Afterwards we looked at hadoop, s3, presto, vertica, and other frights. Finally we stopped to suffer nonsense and just completed PostgreSQL with ready Greenplum and Clickhouse. As a result, we achieved amazing performance, fast migration, easy maintenance, reliability and horizontal scalability. We enabled to recover the system after fault in two commands, decreased infrastructure costs and expanded functionality due to ANSI SQL, MPP and In-memory. All within the open-source and full SQL paradigm. We called the product GreenHouseSQL, which is our inner whole cycle data platform. In the talk we will show the beauty of solution internals, explain the advantages and flaws, tips and tricks of starting with Greenplum, as well as why do we need Clickhouse, what is left to PostgreSQL, and eventually how does it all work.

слайды

Видео

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

  • Jignesh Shah
    Jignesh Shah Amazon Web Services
    45 мин

    Deep Dive into the RDS PostgreSQL Universe

    In this session we will deep dive into the exciting features of Amazon RDS for PostgreSQL, including new versions of PostgreSQL releases, new extensions, larger instances. We will also show benchmarks of new RDS instance types, and their value proposition. We will also look at how high availability and read scaling works on RDS PostgreSQL. We will also explore lessons we have learned managing a large fleet of PostgreSQL instances, including important tunables and possible gotchas around pg_upgrade.

  • Kamil Islamov
    Kamil Islamov Stickeroid Ai
    22 мин

    CTE Queries Usage for Business Logic

    Wide usage of Common Table Expression queries considered as a core paradigm for implementing the Business Logic for high loaded web applications development based on PostgreSQL functions.

  • Jignesh Shah
    Jignesh Shah Amazon Web Services
    45 мин

    Tips and Tricks with Amazon RDS for PostgreSQL

    Managed database services are gaining in popularity. In this session we look at how best to configure Amazon RDS for PostgreSQL and also look at common user operations of using RDS for PostgreSQL. We will also look beyond common user operations and into some specific optimizations related to upgrade, logical replication, performance, and reducing downtime.

  • Peter Gribanov
    Peter Gribanov
    22 мин

    1С:Enterprise and PostgreSQL

    • 1С: as a cross-platform business application development environment
    • 1С and PostgreSQL together since 2006
    • 1C How to work with 1С on PostgreSQL in 1cFresh cloud service
    • What major improvements in 1С:platform make work with PostgreSQL more efficient.