Discussion
Loading...

Post

  • About
  • Code of conduct
  • Privacy
  • Users
  • Instances
  • About Bonfire
Data Bene
@data_bene@fosstodon.org  ·  activity timestamp 3 days ago

#PostgreSQL18 brings major changes to the statistics ecosystem, like:

✨ pg_upgrade retains the optimizer stats (a welcome change!)
✨ Statistics I/O in bytes instead of pages
✨ New C API for extensions
✨ I/O visibility by backend with pg_stat_get_backend_io()
✨ Better insights for conflict management

Notably, you can now use the #PostgreSQL Cumulative Statistics API. Export, import and adjust stats at will.

Learn more in our latest blog from @c2main https://www.data-bene.io/en/blog/cumulative-statistics-in-postgresql-18

#tech #programming

Data Bene

Cumulative Statistics in PostgreSQL 18

In PostgreSQL 18, the statistics & monitoring subsystem receives a significant overhaul - extended cumulative statistics, new per-backend I/O visibility, the ability for extensions to export / import / adjust statistics, and much more. Let's explore these changes.
PostgreSQL elephant logo

Title:Cumulative Statistics in PostgreSQL 18

A blog focused on the updates introduced to the statistics & monitoring
subsystem in PostgreSQL 18. Here, we'll explore what's new, what to
watch out for, GUC knobs, and how extension authors can leverage the
new C API surface.

Data Bene logo
PostgreSQL elephant logo Title:Cumulative Statistics in PostgreSQL 18 A blog focused on the updates introduced to the statistics & monitoring subsystem in PostgreSQL 18. Here, we'll explore what's new, what to watch out for, GUC knobs, and how extension authors can leverage the new C API surface. Data Bene logo
PostgreSQL elephant logo Title:Cumulative Statistics in PostgreSQL 18 A blog focused on the updates introduced to the statistics & monitoring subsystem in PostgreSQL 18. Here, we'll explore what's new, what to watch out for, GUC knobs, and how extension authors can leverage the new C API surface. Data Bene logo
  • Copy link
  • Flag this post
  • Block
Log in

Open Science

We are a network of scientists, developers and organizations building the next generation of digital spaces for open science.

Open Science: About · Code of conduct · Privacy · Users · Instances
Bonfire open science · 1.0.0-rc.2.30 no JS en
Automatic federation enabled
  • Explore
  • About
  • Members
  • Code of Conduct
Home
Login