Ir al contenido principal
Madero Solutions
ServiciosIndustriasTecnologíasMetodologíaNoticiasAcerca de
Madero Solutions
Servicios
Industrias
Tecnologías
Metodología
NoticiasAcerca de
Madero Solutions

Ingeniería de software nearshore y equipos dedicados para productos digitales, con foco en claridad, calidad y entregas sostenibles.

Explorar

  • Acerca de
  • Noticias
  • Metodología
  • Industrias
  • Tecnologías

Servicios

  • Servicios
  • Desarrollo y diseño de software
  • QA, testing, mantenimiento y modernización
  • Cloud y tecnologías avanzadas
  • Soluciones de negocio

Contacto y legal

  • Contacto
  • Política de privacidad

© 2018 Madero Solutions SRL. Todos los derechos reservados.

Ir al contenido principal
Madero Solutions
ServiciosIndustriasTecnologíasMetodologíaNoticiasAcerca de
Madero Solutions
Servicios
Industrias
Tecnologías
Metodología
NoticiasAcerca de
Madero Solutions

Ingeniería de software nearshore y equipos dedicados para productos digitales, con foco en claridad, calidad y entregas sostenibles.

Explorar

  • Acerca de
  • Noticias
  • Metodología
  • Industrias
  • Tecnologías

Servicios

  • Servicios
  • Desarrollo y diseño de software
  • QA, testing, mantenimiento y modernización
  • Cloud y tecnologías avanzadas
  • Soluciones de negocio

Contacto y legal

  • Contacto
  • Política de privacidad

© 2018 Madero Solutions SRL. Todos los derechos reservados.

Skip to main content
Madero Solutions
ServicesIndustriesTechnologiesMethodologyNewsAbout
Madero Solutions
Services
Industries
Technologies
Methodology
NewsAbout
  1. Home
  2. /
  3. News
  4. /
  5. Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it.
Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it.
FRESH PICKS

Alexander Ioffe: Postgres runs your query fast exactly five times. Then it changes its mind. One prepared statement, twelve EXPLAIN ANALYZE runs on one connection, a plan change on run six, and why a single run could never have shown it.

A prepared statement ran in 274 ms for five executions and 2,319 ms from the sixth, on the same connection in the same minute. One EXPLAIN ANALYZE is a sample of size one and cannot see this; twelve in a row, with the plan kept per run,…

DatabasesPlanet PostgreSQLPublished: September 11, 2026
Databases
Read original article ↗← News

Related news

Databases
DatabasesInfoQSep 16, 2026

Java 27 Delivers Post-Quantum Cryptography, Future Language Innovation, Helidon 27, JavaFX 27

Oracle has released version 27 of the Java programming language and virtual machine. As the second non-LTS release since JDK 25, the final feature set includes nine JEPs, five of which are still progressing through the preview and…

View summaryRead original article ↗
Databases
DatabasesPlanet PostgreSQLSep 16, 2026Content in its original language: Portuguese

Florent Jardin: Inspecting a catalog with pg_migrate

Over the past few years, I have been working on assessing the strengths and weaknesses of PostgreSQL migration tools. Several articles published by yours truly led to the ambitious project I have been pursuing since 2024 with my colleagues…

View summaryRead original article ↗
Databases
DatabasesPlanet PostgreSQLSep 16, 2026Content in its original language: Portuguese

Christophe Pettus: All Your GUCs in a Row: max_locks_per_transaction

`max_locks_per_transaction` isn't about transactions or limits—it sizes the cluster-wide lock table, and its misleading name has confused PostgreSQL users for…

View summaryRead original article ↗
Madero Solutions

Nearshore software engineering and dedicated teams for digital products—clear communication, solid delivery, and sustainable pace.

Explore

  • About
  • News
  • Methodology
  • Industries
  • Technologies

Services

  • Services
  • Development and software design
  • QA, testing, maintenance and modernization
  • Cloud and advanced technologies
  • Business solutions

Contact & legal

  • Contact
  • Privacy policy

© 2018 Madero Solutions SRL. All rights reserved.