Back when our book queries were handled with a materialized view, we had a script that ran regularly to refresh the view and vacuum the Postgresql database.

We no longer use a materialized view, but NYPL's DBA still recommends having a script that regularly vacuums the database. Once a week should be enough.