Vacuum and Materialized view refresh slow

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

Responses

Browse pgsql-general by date

  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