Re: Many DataFileRead - IO waits

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

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ben Snaidero 2020-02-28 16:53:47 Re: Many DataFileRead - IO waits
Previous Message Pavel Stehule 2020-02-28 15:30:28 Re: proposal: schema variables