> 24 апр. 2018 г., в 11:31, Юрий Соколов <funny.fal...@gmail.com> написал(а): > > Before implementing algorithms within PostgreSQL it will be great to test > them outside with real traces. > > I think, there should be mechamism to collect traces from real-world > postgresql instalations: every read and write access. It should be extremely > eficient to be enabled in real world. Something like circular buffer in > shared memory, and separate worker to dump it to disk. > Instead of full block address, 64bit hash could be used. Even 63bit + 1bit to > designate read/write access. Yes, this is good idea to track pattern of blocks usage. But, I think that cost of development of real page eviction strategy itself is neglectable small compared to infrastructure changes needed by any non-CS5 strategy.
Best regards, Andrey Borodin.
