[Pgpool-general] INSERT slow on one system not on another

[Derek Jones]

I did some logging on one of the node backends.

Here's a sample insert - notice the completion time in ms starred below.

Kind regards

Derek.

LOCATION:  exec_simple_query, postgres.c:1009
LOG:  00000: statement:    insert into      table_A
(       abc,       def,       my_type,       deflink,       pqr, 
stu,       ep_type         )      values
(       '27244',        '29151',        'P',        '',        190.4, 
      3.5,        'zz'     )   ,
(       '27244',        '29151',        'A',        'yes',     190.4, 
      3.5,        'zz'     )   ,
(       '27244',        '29216',        'P',        '',        201.6, 
      3.0,        'zz'     )   ,
(       '27244',        '29216',        'A',        'yes',     201.6, 
      3.0,        'zz'     )   ,
(       '27244',        '29228',        'P',        '',        203.7, 
      3.0,        'zz'     )   ,
(       '27244',        '29228',        'A',        'yes',     203.7, 
      3.0,        'zz'     )   ,
(       '27244',        '29290',        'P',        '',        201.8, 
      3.0,        'zz'     )   ,
(       '27244',        '29290',        'A',        'yes',     201.8, 
      3.0,        'zz'     )   ,
(       '27244',        '29319',        'P',        '',        179.0, 
      2.7,        'zz'     )   ,
(       '27244',        '29319',        'A',        'yes',     179.0, 
      2.7,        'zz'     )   ,
(       '27244',        '29370',        'P',        '',        227.7, 
      3.5,        'zz'     )   ,
(       '27244',        '29370',        'A',        'yes',     227.7, 
      3.5,        'zz'     )   ,
(       '27244',        '29384',        'P',        '',        228.9, 
      3.5,        'zz'     )   ,
(       '27244',        '29384',        'A',        'yes',     228.9, 
      3.5,        'zz'     )   ,
(       '27244',        '29417',        'P',        '',        291.2, 
      4.8,        'zz'     )   ,
(       '27244',        '29417',        'A',        'yes',     291.2, 
      4.8,        'zz'     )   ,
(       '27244',        '29433',        'P',        '',        257.3, 
      4.3,        'zz'     )   ,
(       '27244',        '29433',        'A',        'yes',     257.3, 
      4.3,        'zz'     )   ,
(       '27244',        '29450',        'P',        '',        265.9, 
      4.9,        'zz'     )   ,
(       '27244',        '29450',        'A',        'yes',     265.9, 
      4.9,        'zz'     )   ,
(       '27244',        '29470',        'P',        '',        303.5, 
      5.1,        'zz'     )   ,
(       '27244',        '29470',        'A',        'yes',     303.5, 
      5.1,        'zz'     )   ,
(       '27244',        '29479',        'P',        '',        224.9, 
      4.2,        'zz'     )   ,
(       '27244',        '29479',        'A',        'yes',     224.9, 
      4.2,        'zz'     )   ,
(       '27244',        '29540',        'P',        '',        151.2, 
      2.7,        'zz'     )   ,
(       '27244',        '29540',        'A',        'yes',     151.2, 
      2.7,        'zz'     )   ,
(       '27244',        '29545',        'P',        '',        203.3, 
      3.5,        'zz'     )   ,
(       '27244',        '29545',        'A',        'yes',     203.3, 
      3.5,        'zz'     )   ,
(       '27244',        '29555',        'P',        '',        197.6, 
      3.8,        'zz'     )   ,
(       '27244',        '29555',        'A',        'yes',     197.6, 
      3.8,        'zz'     )   ,
(       '27244',        '29566',        'P',        '',        228.3, 
      3.9,        'zz'     )   ,
(       '27244',        '29566',        'A',        'yes',     228.3, 
      3.9,        'zz'     )   ,
(       '27244',        '29570',        'P',        '',        125.8, 
      2.3,        'zz'     )   ,
(       '27244',        '29570',        'A',        'yes',     125.8, 
      2.3,        'zz'     )   ,
(       '27244',        '29587',        'P',        '',        213.8, 
      4.2,        'zz'     )
LOCATION:  exec_simple_query, postgres.c:811
LOG:  00000: statement:  RESET ALL
LOCATION:  exec_simple_query, postgres.c:811
LOG:  00000: duration: 0.078 ms
LOCATION:  exec_simple_query, postgres.c:1009
LOG:  00000: statement:  SET SESSION AUTHORIZATION DEFAULT
LOCATION:  exec_simple_query, postgres.c:811
LOG:  00000: duration: 0.105 ms
LOCATION:  exec_simple_query, postgres.c:1009

----> SEE THIS ----> LOG:  00000: duration: ****36394.210 ms ****

LOCATION:  exec_simple_query, postgres.c:1009
LOG:  00000: statement: COMMIT
LOCATION:  exec_simple_query, postgres.c:811
LOG:  00000: duration: 43.626 ms