Re: Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Pavel Stehule
Hi čt 4. 12. 2025 v 19:46 odesílatel Vincent Veyron napsal: > Hi, > > 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

Re: Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Tom Lane
Pavel Stehule writes: > čt 4. 12. 2025 v 19:46 odesílatel Vincent Veyron > 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 p

RE: Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Clay Jackson (cjackson)
Slower CPU, less RAM Clay Jackson From: Pavel Stehule Sent: Thursday, December 4, 2025 10:54 AM To: Vincent Veyron Cc: [email protected] Subject: Re: Why is my query 3 times faster on my workstation than on my server? CAUTION: This email originated from outside of the or

Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Vincent Veyron
Hi, 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 D

Re: Why is my query 3 times faster on my workstation than on my server?

2025-12-04 Thread Vincent Veyron
On Thu, 04 Dec 2025 14:06:40 -0500 Tom Lane wrote: Hi Tom, > > Yeah. Check out the ratings at > > https://browser.geekbench.com > I guess these ratings will come handy to help pick my next server, thank you. >They seem to think the i5-5300U is a 2-core device, maybe you are counting >hype