Hi Justin,
I am pasting once again the output of low end server , explain result
and shared_buffer size of high end machine.
-bash-4.2$ psql -p 5422
psql (12.3)
Type "help" for help.
postgres=# \c IPDS_KSEB;
You are now connected to database "IPDS_KSEB" as user "postgres".
IPDS_KSEB=# set tr
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
