On 2016-05-06 14:15:47 -0700, Josh berkus wrote: > For the serious testing, does anyone have a good technique for creating > loads which would stress-test vacuum freezing? It's hard for me to come > up with anything which wouldn't be very time-and-resource intensive > (like running at 10,000 TPS for a week).
I've changed the limits for freezing options a while back, so you can now set autovacuum_freeze_max as low as 100000 (best set vacuum_freeze_table_age accordingly). You'll have to come up with a workload that doesn't overwrite all data continuously (otherwise there'll never be old rows), but otherwise it should now be fairly easy to test that kind of scenario. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
