Pavel Stehule <[email protected]> writes: > čt 4. 12. 2025 v 19:46 odesílatel Vincent Veyron <[email protected]> > napsal: >> Using the same query, with the same database on both machine, plans and >> estimates are quasi identical, but actual cost is multiplied by three on my >> server compared to my workstation, for all nodes in the plan. Can you tell >> me what explains the difference? >> >> I work with PostgreSQL 15.14 on Debian Old Stable (bookworm). >> >> My workstation is a Lenovo X250 with 8GB RAM and an Intel(R) Core(TM) >> i5-5300U CPU @ 2.30GHz (4 cores) >> cpu MHz : 500.000 >> cache size : 3072 KB >> >> My server is a Start-3-S-SSD server from online.net with 4 GB RAM and an >> Intel(R) Atom(TM) CPU C2338 @ 1.74GHz (2 cores) >> cpu MHz : 1198.820 >> cache size : 1024 KB
> Intel Atom is slow CPU Yeah. Check out the ratings at https://browser.geekbench.com They seem to think the i5-5300U is a 2-core device, maybe you are counting hyperthreading? Anyway, the scores for it are around 900-1000 single-core and 1600-ish multi-core. The Atom C2338 shows up around 140-150 single-core and 250-ish multi-core; plus, those ratings mention 2400MHz which is faster than the clock speed you are showing. So from these numbers I'd ask not "why 3x slower?" but "why only 3x slower?". Maybe your queries are partly disk-bound. regards, tom lane
