• EN
    assets/icons/email Created with Sketch. assets/icons/zoom Created with Sketch. Blog

    Cybertec Logo

    • Data Science
    • Support
      • PostgreSQL 24×7 enterprise support
      • PostgreSQL health check
      • PostgreSQL product- and 3rd level support
      • PostgreSQL update
      • PostgreSQL developer support
    • Services
      • PostgreSQL design
        • Database architecture
        • Database modeling
      • PostgreSQL migration
        • Migrating from Oracle
        • Migrating from MySQL / MariaDB
      • PostgreSQL administration
        • PostgreSQL disaster and data recovery
        • Remote DBA
        • Performance and scalability
        • Automation with kubernetes
      • PostgreSQL consulting
      • PostgreSQL development
      • PostgreSQL clustering and HA
        • Clustering and failover
        • Point-In-Time-Recovery
        • Synchronous and asynchronous replication
        • Multimaster replication
        • Scaling with PL/Proxy
    • Courses
    • Products
      • Cloud database setup
      • PostgreSQL Books
      • PostgreSQL tools
        • PostgreSQL instance level encryption
        • Cybertec Enterprise Migrator
        • Data Masking for PostgreSQL
        • pgwatch2: next generation PostgreSQL monitoring tool
        • PL/pgSQL_sec: Fully encrypted stored procedures
        • pg_squeeze: Shrinks tables better than VACUUM
        • pgconfigurator – configurate PostgreSQL easily
        • pgneural: Bringing machine learning to PostgreSQL
        • Walbouncer: Enterprise grade partial replication
        • Agg: Parallel aggregations for PostgreSQL
        • pg_matlab: Matlab / PostgreSQL integration
    • Overview
      • Advantages of PostgreSQL
      • Solutions – Who uses PostgreSQL
        • Startups
        • PostgreSQL for governments and public services
        • Longlife solutions
      • Business Cases
        • Fraud Detection
        • PostgreSQL for biotech and scientific applications
    • Contact

    Posts

    Blog » statistics

    Tag: statistics

    19.09.2018 | Laurenz Albe

    Correlation of PostgreSQL columns explained

    After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column in the pg_stats system view. This article will explain the meaning of the correlation column and its impact on index scans. Physical vs. logical ordering Most common PostgreSQL data types have an ordering: they support […]

    Read more

    logo

    HEADQUARTER
    Cybertec Schönig & Schönig GmbH
    Gröhrmühlgasse 26
    A-2700 Wiener Neustadt

    +43 (0) 2622 93022-0
    office@cybertec.at
    twitter.com/PostgresSupport

    Our Services

    • Administration
    • Replication
    • Consulting
    • Database Design
    • Support
    • Migration
    • Development

    Newsletter

    Stay well informed about PostgreSQL subscribing to our newsletter.

    © 2000–2019 Cybertec Schönig & Schönig GmbH
    • Contact
    • Data protection policy
    • Imprint

    This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.

    More Information ×
    assets/icons/close Created with Sketch.