Re: Same query taking less time in low configuration machine

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Vishwa Kalyankar <vishwakalyankar8(at)gmail(dot)com>
Cc: Philip Semanchuk <philip(at)americanefficient(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Same query taking less time in low configuration machine
Date: 2020-07-14 16:42:36
Message-ID: 20200714164236.GI18411@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 14, 2020 at 09:27:56PM +0530, Vishwa Kalyankar wrote:
> HI,
>
> OS cache is updated and I had run the query few times with almost the same
> result each time.
>
> Regards,
> Vishwa

Hi Vishwa,

What are the CPU speeds, memory bandwidth, I/O bandwidth? Often the
lower core count CPUs have a faster clock speed. What is the CPU cache
size for both? Are you running the same OS and PostgreSQL build binaries
on both?

Regards,
Ken

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2020-07-14 17:03:41 Problem with FDW wrapper errors
Previous Message Marc Millas 2020-07-14 16:36:05 how to "explain" some ddl