copytest-results.txt

text/plain

Filename: copytest-results.txt
Type: text/plain
Part: 1
Message: Inserting heap tuples in bulk in COPY
unpatched:

    testname     |     mintime     |     avgtime     |     maxtime     |  minxlog   |  avgxlog   |  maxxlog   
-----------------+-----------------+-----------------+-----------------+------------+------------+------------
 mid-logged      | 00:00:23.954561 | 00:00:26.415572 | 00:00:30.327896 |  559624432 |  559624822 |  559625376
 mid-unlogged    | 00:00:12.967393 | 00:00:13.80723  | 00:00:15.345924 |        936 |       1240 |       1544
 narrow-logged   | 00:02:16.680117 | 00:02:32.125384 | 00:03:03.504382 | 3212552504 | 3225992059 | 3229378776
 narrow-unlogged | 00:00:55.778558 | 00:01:01.832198 | 00:01:05.632945 |        328 |       9218 |      43864
 wide-logged     | 00:00:41.402941 | 00:00:46.111361 | 00:00:52.032766 |  896418200 |  903134603 |  913195736
 wide-unlogged   | 00:00:29.750483 | 00:00:35.09615  | 00:00:41.128064 |       1696 |       2003 |       2320
(6 rows)

patched:

    testname     |     mintime     |     avgtime     |     maxtime     |  minxlog  |  avgxlog  |  maxxlog  
-----------------+-----------------+-----------------+-----------------+-----------+-----------+-----------
 mid-logged      | 00:00:13.885076 | 00:00:15.89922  | 00:00:21.414129 | 287650656 | 287652286 | 287653768
 mid-unlogged    | 00:00:13.059609 | 00:00:13.639945 | 00:00:15.042474 |       936 |      1240 |      1544
 narrow-logged   | 00:00:57.124555 | 00:01:11.465383 | 00:01:28.242493 | 690478680 | 693845902 | 707256240
 narrow-unlogged | 00:00:54.593956 | 00:00:55.524332 | 00:00:56.300167 |       176 |       480 |       784
 wide-logged     | 00:00:36.989919 | 00:00:40.616294 | 00:00:50.272398 | 796129152 | 799488373 | 812919192
 wide-unlogged   | 00:00:28.671359 | 00:00:35.406796 | 00:00:39.022341 |      1696 |      2003 |      2304
(6 rows)