File: 4-list-table-split.out

package info (click to toggle)
pgcopydb 0.17-1
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 30,636 kB
  • sloc: ansic: 217,474; sql: 1,654; sh: 812; makefile: 365; python: 94
file content (57 lines) | stat: -rw-r--r-- 4,350 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
2024-04-26 15:30:56.639 87 INFO   main.c:136                Running pgcopydb version 0.15.59.g9a151a6.dirty from "/usr/local/bin/pgcopydb"
2024-04-26 15:30:56.685 87 INFO   copydb.c:105              Using work dir "/tmp/unit/split"
2024-04-26 15:30:56.688 87 INFO   cli_list.c:1294           Table public.table_1 COPY will be split 11-ways
        Part |          Min |          Max |        Count
-------------+--------------+--------------+-------------
        1/11 |           -1 |           -1 |           -1
        2/11 |            1 |           10 |           10
        3/11 |           11 |           20 |           10
        4/11 |           21 |           30 |           10
        5/11 |           31 |           40 |           10
        6/11 |           41 |           50 |           10
        7/11 |           51 |           60 |           10
        8/11 |           61 |           70 |           10
        9/11 |           71 |           80 |           10
       10/11 |           81 |           90 |           10
       11/11 |           91 |           -1 |           -1

2024-04-26 15:30:56.695 94 INFO   main.c:136                Running pgcopydb version 0.15.59.g9a151a6.dirty from "/usr/local/bin/pgcopydb"
2024-04-26 15:30:56.741 94 INFO   copydb.c:105              Using work dir "/tmp/unit/split"
2024-04-26 15:30:56.744 94 INFO   cli_list.c:1294           Table public.table_2 COPY will be split 6-ways
        Part |          Min |          Max |        Count
-------------+--------------+--------------+-------------
         1/6 |           -1 |           -1 |           -1
         2/6 |            1 |           17 |           17
         3/6 |           18 |           34 |           17
         4/6 |           35 |           51 |           17
         5/6 |           52 |           68 |           17
         6/6 |           69 |           -1 |           -1

2024-04-26 15:30:56.753 101 INFO   main.c:136                Running pgcopydb version 0.15.59.g9a151a6.dirty from "/usr/local/bin/pgcopydb"
2024-04-26 15:30:56.812 101 INFO   copydb.c:105              Using work dir "/tmp/unit/split"
2024-04-26 15:30:56.815 101 INFO   cli_list.c:1275           Table public.table_3 (8192 bytes) will not be split
024-05-23 09:14:52.903 184 INFO   main.c:136                Running pgcopydb version 0.15.28.g40af8d7 from "/usr/local/bin/pgcopydb"
2024-05-23 09:14:52.941 184 INFO   copydb.c:105              Using work dir "/tmp/unit/split"
2024-05-23 09:14:52.944 184 INFO   cli_list.c:1297           Table public.table_ctid_candidate is 152 kB large which is larger than --split-tables-larger-than 10 kB, and does not have a unique column of type integer: splitting by CTID
2024-05-23 09:14:52.944 184 INFO   cli_list.c:1321           Table public.table_ctid_candidate COPY will be split 8-ways
        Part |          Min |          Max |        Count
-------------+--------------+--------------+-------------
         1/8 |        (0,0) |        (1,0) |            2
         2/8 |        (2,0) |        (3,0) |            2
         3/8 |        (4,0) |        (5,0) |            2
         4/8 |        (6,0) |        (7,0) |            2
         5/8 |        (8,0) |        (9,0) |            2
         6/8 |       (10,0) |       (11,0) |            2
         7/8 |       (12,0) |       (13,0) |            2
         8/8 |       (14,0) |       (-1,0) |           -1
2024-05-23 11:01:25.505 201 INFO   main.c:136                Running pgcopydb version 0.15.28.g40af8d7 from "/usr/local/bin/pgcopydb"
2024-05-23 11:01:25.551 201 INFO   cli_list.c:1300           Table public.table_ctid_candidate_skip is 152 kB large which is larger than --split-tables-larger-than 10 kB, does not have a unique column of type integer, and CTID split is disabled.Same table concurrency is not enabled

20:54:39.774 58 INFO   Running pgcopydb version 0.15.63.g1fd2daa from "/usr/local/bin/pgcopydb"
20:54:39.833 58 INFO   Using work dir "/tmp/unit/split-with-limits"
20:54:39.837 58 INFO   Table public.table_1 COPY will be split 3-ways
        Part |          Min |          Max |        Count
-------------+--------------+--------------+-------------
         1/3 |           -1 |           -1 |           -1
         2/3 |            1 |           34 |           34
         3/3 |           35 |           -1 |           -1