Re: Many DataFileRead - IO waits

From: Ben Snaidero <bensnaidero(at)geotab(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Many DataFileRead - IO waits
Date: 2020-02-28 16:53:47
Message-ID: CAEPE5bMHZ3vLS85O7dTFGhRg+SG=Z2=dDbupAmjNAnDEBPayYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Feb 28, 2020 at 11:41 AM Michael Lewis <mlewis(at)entrata(dot)com> wrote:

> If no updates or deletes are happening on the table, it would be best
> practice to set up a scheduled manual vacuum analyze to ensure statistics
> and the visibility map is updated. Other than creating the index on the
> first two columns only, I'm out of ideas. Hopefully someone running
> Postgres at large scale on Windows will chime in.
>

Yep. We run manual vacuum freeze analyze weekly to ensure visibility map
is updated and statistics are up to date.

Thanks for taking the time to look.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message legrand legrand 2020-02-28 19:00:09 Re: Many DataFileRead - IO waits
Previous Message Michael Lewis 2020-02-28 16:40:46 Re: Many DataFileRead - IO waits