,
Vishwa S Kalyankar
On Tue, Jul 14, 2020 at 10:12 PM Kenneth Marshall wrote:
> 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.
>
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 <
> vishwakal
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
.016 ms
(3 rows)
IPDS_KSEB=#
On Fri, Jul 10, 2020 at 7:23 PM Adrian Klaver
wrote:
> On 7/9/20 11:50 PM, Vishwa Kalyankar wrote:
> > Hi Team,
> >
> > I Need help or any suggestion on below mentioned issue.
> >
> > Previously we are running postgresql-10with p
Hi Team,
I Need help or any suggestion on below mentioned issue.
Previously we are running postgresql-10with postgis 2.5.3 and now we are
updated to postgresql-12 and postgis-3.0.1, and in postgresql-10 one query
is taking 20 sec and same query is taking upto 80 sec. thanks in advance
Regards
