Re: Many DataFileRead - IO waits - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Many DataFileRead - IO waits
Date
Msg-id CAHOFxGrMHhm+kGeB=DP8nYm-H2k2A5CU4gbFqWrtQtD_VETgKg@mail.gmail.com
Whole thread Raw
In response to Re: Many DataFileRead - IO waits  (Ben Snaidero <bensnaidero@geotab.com>)
Responses Re: Many DataFileRead - IO waits  (Ben Snaidero <bensnaidero@geotab.com>)
List 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.

pgsql-performance by date:

Previous
From: Ben Snaidero
Date:
Subject: Re: Many DataFileRead - IO waits
Next
From: Ben Snaidero
Date:
Subject: Re: Many DataFileRead - IO waits