linux cachestat in file Readv and Prefetch

2024-01-17 Thread Cedric Villemain
Hi, I was testing the index prefetch and streamIO patches and I added cachestat() syscall to get a better view of the prefetching. It's a new linux syscall, it requires 6.5, it provides numerous interesting information from the VM for the range of pages examined. It's way way faster than the

doing also VM cache snapshot and restore with pg_prewarm, having more information of the VM inside PostgreSQL

2024-01-03 Thread Cedric Villemain
Hi, for 15 years pgfincore has been sitting quietly and being used in large setups to help in HA and resources management. It can perfectly stay as is, to be honest I was expecting to one day include a windows support and propose that to PostgreSQL, it appears getting support on linux and BSD

Change prefetch and read strategies to use range in pg_prewarm ... and raise a question about posix_fadvise WILLNEED

2024-01-03 Thread Cedric Villemain
Hi, I wonder what you think of making pg_prewarm use recent addition on smgrprefetch and readv ? In order to try, I did it anyway in the attached patches. They contain no doc update, but I will proceed if it is of interest. In summary: 1. The first one adds a new check on parameters (chec