On Thu, Jul 16, 2020 at 09:13:45PM +0530, Vishwa Kalyankar wrote:
> 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
It looks like they're returning different number of rows, so definitely not the
Hi Justin,
I tried both the way, pg_dump and rsync of complete data_directory, but
the result is same.
Both the db's configurations are not same, I have tuned the db in both
machines according to https://pgtune.leopard.in.ua/#/
Below is the result of explain (analyze, buffer, settings) of bot
On Thu, Jul 16, 2020 at 09:13:45PM +0530, 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 mo
