Hi,
Not sure whether its relevant or not, however upon adding an ANALYSE before the second vacuum the issue has not presented when testing. I have managed 95 cycles thus far.
BEGIN;
CREATE TABLE x (id BIGSERIAL PRIMARY KEY, payload1 VARCHAR, payload2 VARCHAR, payload3 VARCHAR, payload4 BIGINT, payload5 BIGINT);
/* Repeat until 2,000,000 rows are inserted */
INSERT INTO x (id, payload1, payload2, payload3, payload4, payload5) VALUES (random values of varying length/size to force random toast usage);
COMMIT;
VACUUM (ANALYZE, FULL);
BEGIN;
/* Repeat until all 2,000,000 rows are updated */
UPDATE x SET payload1 = , payload2 = , payload3 = , payload4 = , payload5 = ... again random values of varying length/size to force random toast usage
COMMIT;
ANALYZE x; -- <== New analyse here.
VACCUM (ANALYZE, FULL);
(...)
Vacuum end. 30 sec sleep
Update selective
Inserting the rows
update 0
update 20000
update 40000
update 60000
update 80000
update 100000
update 120000
update 140000
update 160000
update 180000
Update all
Attempting vacuum
Vacuum completed
dropping the table
=========================================
New attempt - number 96
Inserting the rows
Executing 0
Executing 40000
Executing 80000
Executing 120000
Executing 160000
Executing 200000
Executing 240000
Executing 280000
(...)
Many thanks,
Harry
