LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f CONTEXT: parallel worker LOG: begin index sort: unique = f, workMem = 698709, randomAccess = f CONTEXT: parallel worker LOG: 0 switching to external sort with 501 tapes: CPU: user: 3.85 s, system: 2.15 s, elapsed: 6.16 s LOG: 0 starting quicksort of run 1: CPU: user: 3.85 s, system: 2.15 s, elapsed: 6.16 s LOG: 2 switching to external sort with 501 tapes: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 1: CPU: user: 4.14 s, system: 1.85 s, elapsed: 6.22 s CONTEXT: parallel worker LOG: 1 switching to external sort with 501 tapes: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 1: CPU: user: 3.90 s, system: 2.23 s, elapsed: 6.31 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 1: CPU: user: 13.82 s, system: 2.23 s, elapsed: 16.23 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 1: CPU: user: 14.33 s, system: 2.15 s, elapsed: 16.64 s LOG: 0 finished writing run 1 to tape 0: CPU: user: 15.10 s, system: 2.96 s, elapsed: 18.22 s LOG: 2 finished quicksort of run 1: CPU: user: 14.67 s, system: 1.85 s, elapsed: 16.75 s CONTEXT: parallel worker LOG: 1 finished writing run 1 to tape 0: CPU: user: 14.58 s, system: 3.08 s, elapsed: 17.86 s CONTEXT: parallel worker LOG: 2 finished writing run 1 to tape 0: CPU: user: 15.52 s, system: 2.65 s, elapsed: 18.64 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 2: CPU: user: 18.28 s, system: 4.88 s, elapsed: 23.52 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 2: CPU: user: 18.48 s, system: 4.83 s, elapsed: 23.74 s LOG: 2 starting quicksort of run 2: CPU: user: 19.00 s, system: 4.49 s, elapsed: 24.10 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 2: CPU: user: 27.76 s, system: 4.83 s, elapsed: 33.02 s LOG: 0 finished writing run 2 to tape 1: CPU: user: 28.70 s, system: 5.53 s, elapsed: 34.74 s LOG: 2 finished quicksort of run 2: CPU: user: 28.90 s, system: 4.49 s, elapsed: 34.00 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 2: CPU: user: 27.97 s, system: 4.88 s, elapsed: 33.21 s CONTEXT: parallel worker LOG: 1 finished writing run 2 to tape 1: CPU: user: 28.86 s, system: 5.61 s, elapsed: 34.91 s CONTEXT: parallel worker LOG: 2 finished writing run 2 to tape 1: CPU: user: 29.65 s, system: 5.31 s, elapsed: 35.66 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 3: CPU: user: 32.65 s, system: 6.97 s, elapsed: 40.24 s LOG: 1 starting quicksort of run 3: CPU: user: 32.60 s, system: 7.36 s, elapsed: 40.49 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 3: CPU: user: 33.38 s, system: 6.78 s, elapsed: 40.99 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 3: CPU: user: 41.76 s, system: 6.97 s, elapsed: 49.35 s LOG: 0 finished writing run 3 to tape 2: CPU: user: 42.58 s, system: 7.65 s, elapsed: 50.87 s LOG: 2 finished quicksort of run 3: CPU: user: 42.02 s, system: 6.78 s, elapsed: 49.63 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 3: CPU: user: 41.51 s, system: 7.36 s, elapsed: 49.40 s CONTEXT: parallel worker LOG: 1 finished writing run 3 to tape 2: CPU: user: 42.19 s, system: 8.25 s, elapsed: 50.98 s CONTEXT: parallel worker LOG: 2 finished writing run 3 to tape 2: CPU: user: 42.77 s, system: 7.65 s, elapsed: 51.26 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 4: CPU: user: 46.06 s, system: 9.75 s, elapsed: 56.62 s LOG: 1 starting quicksort of run 4: CPU: user: 45.89 s, system: 10.17 s, elapsed: 56.86 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 4: CPU: user: 46.23 s, system: 9.70 s, elapsed: 57.00 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 4: CPU: user: 56.70 s, system: 9.75 s, elapsed: 67.26 s LOG: 0 finished writing run 4 to tape 3: CPU: user: 57.56 s, system: 10.49 s, elapsed: 68.87 s LOG: 2 finished quicksort of run 4: CPU: user: 57.82 s, system: 9.70 s, elapsed: 68.59 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 4: CPU: user: 56.64 s, system: 10.17 s, elapsed: 67.61 s CONTEXT: parallel worker LOG: 1 finished writing run 4 to tape 3: CPU: user: 57.61 s, system: 10.85 s, elapsed: 69.26 s CONTEXT: parallel worker LOG: 2 finished writing run 4 to tape 3: CPU: user: 58.67 s, system: 10.51 s, elapsed: 70.24 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 5: CPU: user: 61.37 s, system: 12.30 s, elapsed: 74.63 s LOG: 1 starting quicksort of run 5: CPU: user: 61.38 s, system: 12.74 s, elapsed: 75.09 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 5: CPU: user: 62.32 s, system: 12.30 s, elapsed: 75.86 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 5: CPU: user: 72.04 s, system: 12.30 s, elapsed: 85.30 s LOG: 0 finished writing run 5 to tape 4: CPU: user: 72.85 s, system: 13.07 s, elapsed: 86.87 s LOG: 1 finished quicksort of run 5: CPU: user: 71.68 s, system: 12.74 s, elapsed: 85.39 s CONTEXT: parallel worker LOG: 1 finished writing run 5 to tape 4: CPU: user: 72.43 s, system: 13.61 s, elapsed: 87.01 s CONTEXT: parallel worker LOG: 2 finished quicksort of run 5: CPU: user: 73.91 s, system: 12.30 s, elapsed: 87.45 s CONTEXT: parallel worker LOG: 2 finished writing run 5 to tape 4: CPU: user: 74.86 s, system: 12.97 s, elapsed: 89.24 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 6: CPU: user: 76.58 s, system: 14.97 s, elapsed: 92.67 s LOG: 1 starting quicksort of run 6: CPU: user: 76.00 s, system: 15.63 s, elapsed: 92.86 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 6: CPU: user: 78.45 s, system: 14.63 s, elapsed: 94.66 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 6: CPU: user: 87.48 s, system: 14.99 s, elapsed: 103.58 s LOG: 0 finished writing run 6 to tape 5: CPU: user: 88.20 s, system: 16.05 s, elapsed: 105.36 s LOG: 1 finished quicksort of run 6: CPU: user: 86.92 s, system: 15.63 s, elapsed: 103.80 s CONTEXT: parallel worker LOG: 1 finished writing run 6 to tape 5: CPU: user: 87.78 s, system: 16.39 s, elapsed: 105.42 s CONTEXT: parallel worker LOG: 2 finished quicksort of run 6: CPU: user: 90.60 s, system: 14.63 s, elapsed: 106.81 s CONTEXT: parallel worker LOG: 2 finished writing run 6 to tape 5: CPU: user: 91.49 s, system: 15.35 s, elapsed: 108.42 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 7: CPU: user: 91.86 s, system: 17.97 s, elapsed: 111.04 s LOG: 1 starting quicksort of run 7: CPU: user: 91.43 s, system: 18.23 s, elapsed: 111.15 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 7: CPU: user: 95.14 s, system: 16.80 s, elapsed: 113.63 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 7: CPU: user: 101.79 s, system: 18.23 s, elapsed: 121.49 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 7: CPU: user: 102.96 s, system: 17.97 s, elapsed: 122.13 s LOG: 0 finished writing run 7 to tape 6: CPU: user: 103.77 s, system: 18.96 s, elapsed: 123.94 s LOG: 1 finished writing run 7 to tape 6: CPU: user: 102.58 s, system: 18.96 s, elapsed: 123.02 s CONTEXT: parallel worker LOG: 2 finished quicksort of run 7: CPU: user: 106.36 s, system: 16.80 s, elapsed: 124.84 s CONTEXT: parallel worker LOG: 2 finished writing run 7 to tape 6: CPU: user: 107.23 s, system: 17.58 s, elapsed: 126.50 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 8: CPU: user: 106.15 s, system: 20.87 s, elapsed: 128.68 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 8: CPU: user: 107.50 s, system: 20.73 s, elapsed: 129.63 s LOG: 2 starting quicksort of run 8: CPU: user: 110.90 s, system: 19.09 s, elapsed: 131.74 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 8: CPU: user: 116.12 s, system: 20.87 s, elapsed: 138.65 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 8: CPU: user: 117.93 s, system: 20.73 s, elapsed: 140.07 s LOG: 0 finished writing run 8 to tape 7: CPU: user: 118.63 s, system: 21.74 s, elapsed: 141.78 s LOG: 1 finished writing run 8 to tape 7: CPU: user: 116.92 s, system: 21.51 s, elapsed: 140.08 s CONTEXT: parallel worker LOG: 2 finished quicksort of run 8: CPU: user: 121.50 s, system: 19.09 s, elapsed: 142.35 s CONTEXT: parallel worker LOG: 2 finished writing run 8 to tape 7: CPU: user: 122.21 s, system: 20.04 s, elapsed: 144.00 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 9: CPU: user: 120.76 s, system: 22.93 s, elapsed: 145.39 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 9: CPU: user: 122.36 s, system: 23.47 s, elapsed: 147.31 s LOG: 2 starting quicksort of run 9: CPU: user: 125.84 s, system: 21.49 s, elapsed: 149.18 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 9: CPU: user: 130.10 s, system: 22.93 s, elapsed: 154.73 s CONTEXT: parallel worker LOG: 1 finished writing run 9 to tape 8: CPU: user: 130.69 s, system: 23.69 s, elapsed: 156.09 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 9: CPU: user: 132.47 s, system: 23.47 s, elapsed: 157.41 s LOG: 0 finished writing run 9 to tape 8: CPU: user: 133.20 s, system: 24.33 s, elapsed: 159.01 s LOG: 2 finished quicksort of run 9: CPU: user: 135.54 s, system: 21.49 s, elapsed: 158.88 s CONTEXT: parallel worker LOG: 2 finished writing run 9 to tape 8: CPU: user: 136.28 s, system: 22.44 s, elapsed: 160.57 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 10: CPU: user: 134.42 s, system: 24.99 s, elapsed: 161.13 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 10: CPU: user: 137.04 s, system: 26.00 s, elapsed: 164.53 s LOG: 2 starting quicksort of run 10: CPU: user: 139.88 s, system: 24.00 s, elapsed: 165.79 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 10: CPU: user: 144.12 s, system: 24.99 s, elapsed: 170.83 s CONTEXT: parallel worker LOG: 1 finished writing run 10 to tape 9: CPU: user: 144.83 s, system: 25.69 s, elapsed: 172.23 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 10: CPU: user: 148.09 s, system: 26.00 s, elapsed: 175.57 s LOG: 0 finished writing run 10 to tape 9: CPU: user: 149.04 s, system: 26.69 s, elapsed: 177.21 s LOG: 2 finished quicksort of run 10: CPU: user: 150.11 s, system: 24.00 s, elapsed: 176.03 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 11: CPU: user: 148.32 s, system: 26.89 s, elapsed: 176.93 s CONTEXT: parallel worker LOG: 2 finished writing run 10 to tape 9: CPU: user: 150.93 s, system: 24.85 s, elapsed: 177.68 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 11: CPU: user: 152.52 s, system: 28.42 s, elapsed: 182.45 s LOG: 2 starting quicksort of run 11: CPU: user: 154.28 s, system: 26.64 s, elapsed: 182.92 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 11: CPU: user: 158.55 s, system: 26.89 s, elapsed: 187.16 s CONTEXT: parallel worker LOG: 1 finished writing run 11 to tape 10: CPU: user: 159.19 s, system: 27.64 s, elapsed: 188.55 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 11: CPU: user: 162.92 s, system: 28.42 s, elapsed: 192.86 s LOG: 0 finished writing run 11 to tape 10: CPU: user: 163.83 s, system: 29.10 s, elapsed: 194.45 s LOG: 2 finished quicksort of run 11: CPU: user: 165.17 s, system: 26.64 s, elapsed: 193.81 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 12: CPU: user: 162.77 s, system: 28.65 s, elapsed: 193.14 s CONTEXT: parallel worker LOG: 2 finished writing run 11 to tape 10: CPU: user: 166.21 s, system: 27.26 s, elapsed: 195.48 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 12: CPU: user: 167.54 s, system: 30.49 s, elapsed: 199.61 s LOG: 2 starting quicksort of run 12: CPU: user: 169.88 s, system: 28.65 s, elapsed: 200.58 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 12: CPU: user: 172.72 s, system: 28.65 s, elapsed: 203.09 s CONTEXT: parallel worker LOG: 1 finished writing run 12 to tape 11: CPU: user: 173.55 s, system: 29.26 s, elapsed: 204.53 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 13: CPU: user: 177.04 s, system: 30.32 s, elapsed: 209.08 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 12: CPU: user: 178.51 s, system: 30.49 s, elapsed: 210.58 s LOG: 0 finished writing run 12 to tape 11: CPU: user: 179.29 s, system: 31.34 s, elapsed: 212.20 s LOG: 2 finished quicksort of run 12: CPU: user: 181.41 s, system: 28.65 s, elapsed: 212.11 s CONTEXT: parallel worker LOG: 2 finished writing run 12 to tape 11: CPU: user: 182.34 s, system: 29.43 s, elapsed: 213.89 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 13: CPU: user: 183.05 s, system: 32.74 s, elapsed: 217.40 s LOG: 2 starting quicksort of run 13: CPU: user: 185.98 s, system: 30.85 s, elapsed: 218.97 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 13: CPU: user: 187.95 s, system: 30.32 s, elapsed: 219.99 s CONTEXT: parallel worker LOG: 1 finished writing run 13 to tape 12: CPU: user: 188.77 s, system: 30.96 s, elapsed: 221.45 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 14: CPU: user: 192.52 s, system: 31.76 s, elapsed: 225.99 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 13: CPU: user: 195.43 s, system: 32.74 s, elapsed: 229.78 s LOG: 0 finished writing run 13 to tape 12: CPU: user: 196.37 s, system: 33.47 s, elapsed: 231.45 s LOG: 2 finished quicksort of run 13: CPU: user: 197.76 s, system: 30.85 s, elapsed: 230.75 s CONTEXT: parallel worker LOG: 2 finished writing run 13 to tape 12: CPU: user: 198.83 s, system: 31.57 s, elapsed: 232.54 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 14: CPU: user: 202.84 s, system: 31.76 s, elapsed: 236.32 s CONTEXT: parallel worker LOG: 0 starting quicksort of run 14: CPU: user: 200.02 s, system: 34.99 s, elapsed: 236.68 s LOG: 1 finished writing run 14 to tape 13: CPU: user: 203.72 s, system: 32.35 s, elapsed: 237.79 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 14: CPU: user: 202.48 s, system: 33.08 s, elapsed: 237.83 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 15: CPU: user: 207.21 s, system: 33.38 s, elapsed: 242.31 s CONTEXT: parallel worker LOG: 0 finished quicksort of run 14: CPU: user: 210.21 s, system: 34.99 s, elapsed: 246.87 s LOG: 0 finished writing run 14 to tape 13: CPU: user: 210.92 s, system: 35.83 s, elapsed: 248.43 s LOG: 2 finished quicksort of run 14: CPU: user: 212.91 s, system: 33.08 s, elapsed: 248.25 s CONTEXT: parallel worker LOG: 2 finished writing run 14 to tape 13: CPU: user: 213.75 s, system: 33.94 s, elapsed: 249.95 s CONTEXT: parallel worker LOG: performsort of 0 starting: CPU: user: 212.41 s, system: 36.28 s, elapsed: 250.36 s LOG: 0 starting quicksort of run 15: CPU: user: 212.41 s, system: 36.28 s, elapsed: 250.36 s LOG: performsort of 2 starting: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s CONTEXT: parallel worker LOG: 2 starting quicksort of run 15: CPU: user: 214.04 s, system: 34.02 s, elapsed: 250.33 s CONTEXT: parallel worker LOG: 2 finished quicksort of run 15: CPU: user: 214.61 s, system: 34.02 s, elapsed: 250.89 s CONTEXT: parallel worker LOG: 2 finished writing run 15 to tape 14: CPU: user: 214.65 s, system: 34.08 s, elapsed: 251.00 s CONTEXT: parallel worker LOG: 2 using 698564 KB of memory for read buffers among 15 input tapes CONTEXT: parallel worker LOG: 1 finished quicksort of run 15: CPU: user: 217.48 s, system: 33.38 s, elapsed: 252.58 s CONTEXT: parallel worker LOG: 1 finished writing run 15 to tape 14: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s CONTEXT: parallel worker LOG: performsort of 1 starting: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s CONTEXT: parallel worker LOG: 1 starting quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s CONTEXT: parallel worker LOG: 1 finished quicksort of run 16: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s CONTEXT: parallel worker LOG: 1 finished writing run 16 to tape 15: CPU: user: 218.22 s, system: 34.05 s, elapsed: 253.99 s CONTEXT: parallel worker LOG: 1 using 698555 KB of memory for read buffers among 16 input tapes CONTEXT: parallel worker LOG: 0 finished quicksort of run 15: CPU: user: 216.68 s, system: 36.28 s, elapsed: 254.63 s LOG: 0 finished writing run 15 to tape 14: CPU: user: 217.05 s, system: 36.61 s, elapsed: 255.34 s LOG: 0 using 698564 KB of memory for read buffers among 15 input tapes LOG: 2 finished 15-way merge step: CPU: user: 240.78 s, system: 44.70 s, elapsed: 287.75 s CONTEXT: parallel worker LOG: performsort of 2 done: CPU: user: 240.78 s, system: 44.81 s, elapsed: 287.86 s CONTEXT: parallel worker LOG: parallel external sort of 2 ended, 435256 disk blocks used: CPU: user: 240.78 s, system: 44.81 s, elapsed: 291.58 s CONTEXT: parallel worker LOG: 1 finished 16-way merge step: CPU: user: 244.85 s, system: 46.41 s, elapsed: 292.99 s CONTEXT: parallel worker LOG: 0 finished 15-way merge step: CPU: user: 243.68 s, system: 47.67 s, elapsed: 293.06 s LOG: performsort of 0 done: CPU: user: 243.68 s, system: 47.81 s, elapsed: 293.20 s LOG: parallel external sort of 0 ended, 445285 disk blocks used: CPU: user: 243.68 s, system: 47.82 s, elapsed: 314.96 s LOG: performsort of 1 done: CPU: user: 244.85 s, system: 46.55 s, elapsed: 293.14 s CONTEXT: parallel worker LOG: parallel external sort of 1 ended, 463964 disk blocks used: CPU: user: 244.85 s, system: 46.55 s, elapsed: 299.38 s CONTEXT: parallel worker LOG: begin index sort: unique = f, workMem = 2096128, randomAccess = f LOG: performsort of -1 starting: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s LOG: could not rmdir directory "base/pgsql_tmp/pgsql_tmp8856.2.sharedfileset": Directory not empty ERROR: could not determine size of temporary file "0" ********** Error ********** ERROR: could not determine size of temporary file "0" SQL state: 58P01