2ndQuadrant | PostgreSQL
Mission Critical Databases
+39 0574 159 3000
  • Contact us
  • IT
    • EN
    • FR
    • ES
    • DE
    • PT
  • Supporto e Servizi
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • BDR
    • Case Studies
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti di database
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Supporto e Amministrazione del Database
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro di Apprendimento PostgreSQL
    • Webinars
      • Archivio Webinar
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • Buone prassi per la sicurezza
    • Blog
    • Formazione Professionale
      • Catalogo dei corsi
    • Case Studies
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Amministrazione del Database
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libri
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2 Edizione
      • PostgreSQL 9 Administration Cookbook – 3 Edizione
      • PostgreSQL Server Programming Cookbook – 2 Edizione
      • PostgreSQL 9 Cookbook – Edizione in lingua Cinese
    • Video
    • PostgreSQL
      • PostgreSQL – La storia
      • Chi usa PostgreSQL?
      • PostgreSQL FAQs
      • PostgreSQL vs MySQL
      • Business Case per PostgreSQL
      • Informazioni di Sicurezza
      • Introduzione a PostGIS
      • Documentazione
  • Chi siamo
    • Chi è 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • Notizie
    • Lavora con noi
  • Blog
  • Installers
  • Menu Menu
Sei in: Home1 / Products2 / Postgres-XL

Postgres-XL

Postgres-XL is a massively parallel database built on top of – and very closely compatible with – PostgreSQL. It is different because it supports both Business Intelligence workloads and high-volume transactional write and read workloads all on the same platform.

Postgres-XL

Postgres-XL is designed to be horizontally scalable and flexible enough to handle various workloads including:

  • OLTP write-intensive workloads
  • Business Intelligence requiring OLAP with MPP parallelism
  • Operational data store
  • Key-value store including JSON
  • GIS Geospatial
  • Mixed-workload environments

What Our Clients Say

 

“Postgres-XL has been key to the success of the Gaia variability studies group in Geneva. Flexibility enabled by Postgres for the Extra Large scientific challenge, solid architecture, and rich environment stood out when we researched for credible long-term big data platforms. Capability of having millisecond access to information about specific light sources or processing results, with the power of horizontal scalability without sacrificing ACID properties, has been a clear win for our project.”

Krzysztof Nienartowicz, Manager ESA Gaia – Data Processing Center, European Space Agency

Availability

Postgres-XL 10

Postgres-XL 10R1.1 Released – February 18, 2019

You can download Postgres-XL 10R1.1 here

Please send an email to [email protected] if you want to contribute.

You can contribute by fixing regressions and checking if new features of PostgreSQL 10 work with XL 10.

Postgres-XL 9.5

Postgres-XL 9.5 R1.6 Released – August 24, 2017

You can download Postgres-XL here.

Please report all issues to [email protected]

Performance

Our internal testing for BI workloads reveals a dramatic boost in performance compared to native PostgreSQL. Results on a 16 node cluster show linear scalability for most queries.

This graph shows the 2ndQuadrant’s testing for BI workloads. The results on a 16 node cluster revealed a dramatic boost in performance by Postgre-XL compared to native PostgreSQL.

Features

Some of the most prominent features of Postgres-XL are listed below:

  • Scalable – partition or replicate tables across multiple nodes
  • Fully ACID compliant including MVCC
  • Open Source
  • Cluster-wide consistency ensured by Global Transaction Monitor
  • Based on PostgreSQL 9.5, fully utilizing new BI features
  • Compatible with all PostgreSQL drivers, including JDBC, ODBC, OLE DB, Python, Ruby, perl DBI, Tcl, and Erlang.
  • CREATE TABLE syntax compatibility with Greenplum and Redshift

Core Enhancements

In order to perform as well as XL does, a number of core enhancements were made and are described below.

Massively Parallel Processing (MPP)

  • Multi-node distributed Parallel Query – Allows SQL queries to be executed up to N times faster on N datanodes, spreading both CPU and I/O utilization evenly across a cluster.
  • Three stage Aggregation – Parallelizes aggregate queries to minimize distributed data logistics.
  • Dynamic Redistribution of data for complex SQL queries – Automatically re-arrange data to allow complex SQL queries, not just simple Star Schema queries or Map/Reduce-style tasks.
  • Cooperative Scans – Queries work together to avoid repeated re-scanning of same data.

Distributed Transaction Processing (OLTP)

  • Distributed Global Consistency – Database appears to be a single consistent database to users.
  • Write Scalability, as well as Read Scalability – Scale OLTP writes across the nodes.

Extensibility & Scalability

  • Linear scalability – Performance increases linearly for many typical operations for both OLTP and Parallel Query.
  • Extensible  – Cluster can be extended to increase processing power.
  • Very Large Database Support – Cluster easily supports 10s of TBs.

High Availability

  • High Availability – Physically replicated data nodes to ensure High Availability.
  • Disaster Recovery – Disaster Recovery via Streaming Replication.

Platform Testing & Support

  • XL is tested on Linux and Mac OS X.

History

Postgres-XL has been evolving over many years, originating with the GridSQL project and PostgresXC, later combined as TransLattice Storm (StormDB). TransLattice open sourced the project, resulting in Postgres-XL 9.2. More recently, the EU-funded Big Data project AXLE funded the main work to bring the code up to date as Postgres-XL 9.5, allowing XL to take advantage of the rapidly increasing BI features plugged into the core of PostgreSQL.

Support for Postgres-XL

Postgres-XL is open source and fully supported for 2ndQuadrant Support customers. We also offer consulting services to help organisations with application development, cluster design, deployment, feature development and performance analysis.

Need more help?

Want to know more? Need some help to set up XL? As active community developers for the project, we’re probably the best people in the world to help you get up and running with Postgres-XL. We have consultants available to provide assistance, plus our unique 24/7 Production Support subscription service also covers Postgres-XL.

Postgres-XL Knowledge Base

Training

Training by 2ndQuadrant

Postgres-XL-10

An in-depth and practical course covering this horizontally scalable extension to PostgreSQL. This course will help delegates understand and implement massively parallel databases using Postgres-XL. This course will also discuss the problems with parallelism.

Blogs

Nessun risultato

Spiacente, nessun articolo corrisponde ai tuoi criteri

View All Blogs
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scorrere verso l’alto
×