Le lundi 3 février 2014 19:18:54 Gurjeet Singh a écrit : > Possible enhancements: > - Ability to save/restore only specific databases. > - Control how many BlockReaders are active at a time; to avoid I/O > storms. - Be smart about lowered shared_buffers across the restart. > - Different modes of reading like pg_prewarm does. > - Include PgFincore functionality, at least for Linux platforms.
Please note that pgfincore is working on any system where PostgreSQL prefetch is working, exactly like pg_prewarm. This includes linux, BSD and many unix-like. It *is not* limited to linux. I never had a single request for windows, but windows does provides an API for that too (however I have no windows offhand to test). Another side note is that currently BSD (at least freeBSD) have a more advanced mincore() syscall than linux and offers a better analysis (dirty status is known) and they implemented posix_fadvise... PS: There is a previous thread about that hibernation feature. Mitsuru IWASAKI did a patch, and it triggers some interesting discussions. Some notes in this thread are outdated now, but it's worth having a look at it: http://www.postgresql.org/message-id/20110504.231048.113741617.iwas...@jp.freebsd.org https://commitfest.postgresql.org/action/patch_view?idT9 -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation
Description: This is a digitally signed message part.