Hollis Varden: Five PostgreSQL queries that did more work than I asked for

T2Covered by 1 source · first reported by Planet PostgreSQL at 09 Oct, 00:00 UTC

Most slow queries I have looked at are not doing anything clever. They are doing extra work that nobody asked for, because one word in the SQL told PostgreSQL to. I took five of those words and measured each one against the version without it, on the same table. The biggest gap was UNION: 13.6…

cloud

Sources

• T2Hollis Varden: Five PostgreSQL queries that did more work than I asked forPlanet PostgreSQL09 Oct, 00:00