,
Fahiz
On 12 Dec 2019, 02:25 +, Jeff Janes , wrote:
> On Wed, Dec 11, 2019 at 5:21 PM Fahiz Mohamed wrote:
> > > There is a slight different in both instance’s data. Inastanbce 1
> > > contains latest data and instance 2 consists of data which is 3 weeks
> &
t to 160mb and
instance 2 still using 4mb as work_mem.
shared_buffers set to 8GB in both.
Both are on Postgres DB version 9.6.9
Thanks in advance.
Fahiz
On 10 Dec 2019, 20:15 +, Michael Lewis , wrote:
> On Mon, Dec 9, 2019 at 3:39 PM Fahiz Mohamed wrote:
> > > I ran "explain
Thank you very much for your prompt responses.
I have analysed more regarding this and found the long running query.
I ran "explain analyse" on this query and I got following result. (We have 2
identical DB instances and they consist of same data. Instane 1 took 20+ second
to process and instan
Hi team,
Could you please help me with this strange issue I am facing in my current live
server I am maintaining.
There is a specific search query I am running to get list of Documents and
their metadata from several table in the DB.
We are running Postgres 9.6.9 on Amazon RDS (db.m5.4xlarge in
