Hi PostgreSQL Community, I have a question regarding the use of the pg_prewarm() function [1] in the pg_prewarm extension. The function requires a relation name and a range of pages (e.g., pages 10 to 50) to be warmed by shifting them from disk to the buffer cache.
How can I decide which range of pages to prewarm? I assume that it is related to hot pages in the relation, but how can I identify which pages are likely to be hot before they are even in the buffer cache? Additionally, since tuples within a page can move to different pages over time (due to operations like VACUUM FULL or REINDEX), how should I handle this when selecting the pages to prewarm? Any insights would be greatly appreciated. Regards, Ayush Vatsa [1] https://www.postgresql.org/docs/current/pgprewarm.html#PGPREWARM-FUNCS
