Hi, pls tell me, I am currently running 2nd run in my box, (New attempt 2), and > its in the "Attempting vacuum" phase. > What is it supposed to do next? > I got no errors , it has gotten my machine to its knees. >
The jar has an endless while loop. Thus please kill the PID when you are done testing. It loosely follows the following: 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; VACCUM (ANALYZE, FULL); If the error is going to occur it will happen during the second "Attempting vacuum" phase. 1st vacuum: c.setAutoCommit(true); System.out.println("Attempting vacuum"); c.prepareCall("VACUUM (FULL, ANALYZE, VERBOSE) x").execute(); System.out.println("Vacuum end. 30 sec sleep"); Thread.sleep(60000); 2nd vacuum: System.out.println("Attempting vacuum"); c.prepareCall("VACUUM (FULL, ANALYZE, VERBOSE) x").execute(); System.out.println("Vacuum completed"); Thread.sleep(30000); System.out.println("Dropping the table"); c.createStatement().execute("drop table if exists x"); Thread.sleep(30000); Hope this helps! Best wishes, Harry