pg_wait_sampling: Sampling based statistics of wait events
Summary: The pg_wait_sampling extension exposes a lot of sampling based statistics of wait events that will be helpful for optimizing PostgreSQL database.
Access PostgreSQL with ChatGPT
Summary: GPT can write SQL. If we write our question in plain English, and have GPT write the SQL to get the answer, well then we can save a lot of time spent on enterprise process management and data analysis software.
Database Compatibility and Selection Suggestions
Database compatibility is critical to the success of a database product, and it can even make the difference between life and death for a database product. The problem of database compatibility is essentially a problem that software products will have.
PostgreSQL optimizer is good enough
The optimizer is the heart and soul of a relational DBMS. It analyzes SQL statements and determines the most efficient access plan for satisfying each statement. For database optimizers, there have always been many voices among database-related practitioners.
PL/Scheme - Code is data
Sometimes it’s useful to bring data into code, and other times, it’s useful to bring code into data.