On Thu, 16 Jul 2020 at 09:50, Thomas Munro wrote:
> I'd look at EXPLAIN (BUFFERS) or auto_explain.log_buffers to get more
> information on cache hits and misses. I'd look for settings
> differences with EXPLAIN (SETTINGS) to see if there's anything
> accidentally set differently (maybe JIT or par
On Tue, Jul 14, 2020 at 9:27 PM Vishwa Kalyankar
wrote:
> Function Scan on kseb_geometry_trace_with_barrier_partition
> (cost=0.25..10.25 rows=1000 width=169) (actual time=11626.548..11626.568
> rows=254 loops=1)
> Function Scan on kseb_geometry_trace_with_barrier_partition
> (cost=0.25..1
Hi,
I am pasting the output of both server cpu speed and memory speed, and we
have same os (centos) on both the machines and i have downloaded the
postgres rpms from https://www.postgresql.org/
1) High end machine
[root@localhost ~]# dmidecode -t processor | grep Speed
Max Speed: 360
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 h
HI,
OS cache is updated and I had run the query few times with almost the same
result each time.
Regards,
Vishwa
On Tue, Jul 14, 2020 at 6:16 PM Philip Semanchuk <
phi...@americanefficient.com> wrote:
>
>
> > On Jul 14, 2020, at 5:27 AM, Vishwa Kalyankar <
> vishwakalyank...@gmail.com> wrote:
>
> On Jul 14, 2020, at 5:27 AM, Vishwa Kalyankar
> wrote:
>
> Hi,
>
> I have two machines - one with 8GB RAM & 4core CPU and the other with 64GB
> Ram & 24 core CPU. Both machines have the same DB (Postgres 12 + Postgis
> 2.5.3). Same query is taking less time in low end machine whereas
Hi,
I have two machines - one with 8GB RAM & 4core CPU and the other with 64GB
Ram & 24 core CPU. Both machines have the same DB (Postgres 12 + Postgis
2.5.3). Same query is taking less time in low end machine whereas more
time in high end machine. Any thoughts on where to look? I have tuned t
