A practical guide arguing range-based partitioning is the only good way to partition large Postgres tables.
“If your tables are around 100 gigabytes, that's a good moment to start to think about partitioning.”
Latest signals
Every signal tracked from the world's AI conferences — 4,665 talks, quotes & announcements, newest first.
Basic SQL/PGQ property graph support has been committed to PostgreSQL 19, enabling relational data to be queried as graphs.
“We have committed basic support for this standard in PostgreSQL 19.”
A developer walks through building a WAL-sender performance optimization feature for PostgreSQL physical replication.
“It is an exploration of how one can develop a feature which will improve performance of physical replication.”
pg_duckdb is a Postgres extension embedding DuckDB's analytical engine to run fast OLAP queries inside Postgres without data movement.
“It's like bringing the capabilities of OLTP and OLAP at one place.”
Discrete event simulation can model Postgres CPU-credit degradation on burstable cloud instances to shift-left performance testing before deployment.
“So actually you will go into the death spiral where it will keep on burning your excess CPU and you can't recover.”
PostgreSQL logical replication evolved from 9.4 API primitives to native core support, heading toward multi-master.
“We'll go from its earliest building blocks in PostgreSQL 9.4 all the way to the multi-master distributed future that's being actively built right now.”
A Cohesity engineer argues Postgres security must be a proactive design habit, not a reactive afterthought.
“Is your Postgres really secure or is it just working?”
PostgreSQL 18 ships major vacuum improvements: async I/O, dynamic autovacuum scaling, and dead-tuple caps.
“PostgreSQL 18 delivers the most significant collection of vacuum and analyze improvements over the years.”
New Citus version adds parallel rebalancing to speed up cluster scaling when adding worker nodes.
“The data was not a bottleneck. The machinery that moves the data was the bottleneck.”
Postgres NOTIFY in triggers forces accidental serialization via a global pg_database lock, stalling concurrent commits.
“Postgres treats LISTEN/NOTIFY like a globally serialized queue of notifications”
A POSETTE 2026 talk explains how a Postgres INSERT flows through WAL, logical decoding, and replication slots to a subscriber.
“We start from the insert, the time the insert begins on the publisher, makes its way to the shared buffer, eventually to the WAL.”
Apple revised its Developer Program License Agreement to set terms for alternative iOS app distribution and payments in Brazil.
Apple will let Brazilian developers use alternative app marketplaces and non-Apple payments starting with iOS 26.5.
Sierra builds customer-engagement agents using many parallel models per turn and isolated PCI infrastructure for payments.
“We have isolated infrastructure where payment info doesn't go to an external large language model cuz none of the LLM providers are PCI certified in that way.”
Databricks lead shares a framework for taking AI demos to production, warning model-first thinking causes failures.
“And every conversation started with let's choose the model, right?”
OpenAI's GPT-5.5 Instant improves ChatGPT health and wellness responses with stronger reasoning and physician-informed evaluations.
Intel CEO Lip Bu Tan is turning around Intel as agentic AI drives high CPU demand, with US government and Nvidia as backers.
“right now the agentic AI and influence CPU become you know highly in demand and so in some way I'm happy right now the demand is very high for my CPU”
Databricks publishes an explainer defining artificial intelligence as a branch of computer science.
An OpenAI reasoning model helped researchers identify 18 new diagnoses in previously unsolved rare genetic disease cases.
Databricks blog publishes an educational explainer defining row-level security as a database access control.
Midjourney launched Midjourney Medical, a full-body ultrasonic CT scanner called the Midjourney Scanner.
A Google I/O video titled about becoming the senior dev contains only music and no substantive content.
Databricks launches CustomerLake, an agentic CDP on the lakehouse with LLM-powered profile and campaign agents.
“But now we can really personalize with really cheap, small, uh distilled LLMs, one-to-one uh continuous campaigns.”
Hugging Face explores fine-tuning methods that may outperform LoRA, the most popular technique.