From: | Vikas Sharma <shavikas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Vacuum and Materialized view refresh slow |
Date: | 2018-11-30 18:59:37 |
Message-ID: | CAN6gwKznszC+p=YmKdKmFiuMsk1nT+FgJH6Sa8G5qQ-rGvm+TA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello There,
We have postgres 9.6 with 3 slaves replicated in synchronous commit.
we recently migrated to to another cloud provider. Though we have the
same configuration for VMs and postgres, we are experiencing systemwide
slowness with writes to database.
I am more concerned about a scheduled script to vacuum and refresh two
Materialized views after every 5 minutes.
Time to refresh MV and vacuum has increased considerably and during this
time a simple insert takes 10-15 seconds which normally should take
milliseconds whereas with old provider that simple insert used to take not
more than couple of seconds during refresh time.
I have seen the vacuum and refresh MV process showing as waiting for a
{change location} sometimes for a fraction of seconds.
Could I be enlighted about what I can do to improve the performance to make
write faster.
Best regards
Vikas
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Romero Benavides | 2018-11-30 20:53:45 | Re: Vacuum and Materialized view refresh slow |
Previous Message | John Smith | 2018-11-30 17:33:07 | Re: psql is hanging |