TritonDataCenter / pg_prefaulter

Faults pages into PostgreSQL shared_buffers or filesystem caches in advance of WAL apply
Apache License 2.0
56 stars 13 forks source link

Enable WAL prefaulting for PostgreSQL processes that are in recovery. #25

Closed sean- closed 7 years ago

sean- commented 7 years ago

If the database is running, connect to the database and pre-fault per information contained in the database.

If the database is starting up, however, we're probably in a world of hurt and would like the prefaulter to pre-fault in the necessary pages in order to speed up the rate at which the database becomes available

When pg_prefaulter is unable to connect to the database and recognizes the database is starting up, pg_prefaulter resorts to *NIX CLI utilities to parse out the WAL file being replayed according to the process titles. Hardware fails. Databases misbehave. The need to recovery quickly is important. Hopefully others concur and benefit from this functionality.

Fixes: #20