Search
Items tagged with: performance
#China's #Loongson 3A6000 CPU Reaches Core i5-14600K #Performance In Clock-To-Clock Test, Overclocked To 3 GHz
> Loongson 3A6000 CPU, made for China's domestic PC market, has reached performance parity with Intel 14th Gen CPUs in latest benchmarks.
Such an innocent looking query... I didn't expect it to do this!
One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0
SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;
@michristofides
#postgis #postgresql #postgres #performance
One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0
SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;
@michristofides
#postgis #postgresql #postgres #performance
On reprend avec Melanie, autrice d'un patch récent concernant les #statistiques dans #PostgreSQL ! Well done Melanie! Posez vos questions en direct sur https://dali.bo/2022_site_pgsessions !
#sgbd #conférence #pg_stat_io #performance #pgsession15
#sgbd #conférence #pg_stat_io #performance #pgsession15
PostgreSQL® Sessions
DALIBO est le spécialiste français de PostgreSQL® et fournit à ses clients du support, de la formation et des audits depuis 2005.dali.bo