[PostGIS] #5990: Adding 2 lines to Postgis topology takes a more hours in a production line

[PostGIS]

#5990: Adding 2 lines to Postgis topology takes a more hours in a production line
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.1
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 A comment for my self on how to run a test for this area


 {{{
 CALL resolve_overlap_gap_single_cell(
 E'{"(,id,geo,grl_sk.n5_forvaltning_flate,kom,sl_sdeid,geo,4258,f,\\"id
 integer\\",id,\\"komid integer,sl_sdeid integer,kommunenavn character
 varying,area
 numeric\\",\\"komid,sl_sdeid,kommunenavn,area\\")","(,,,arstat_input_raw.ssb_vann,vann,gid,geo,32633,t,,,,)","(,,,arstat_input_raw.ar5,ar5,sl_sdeid,geo,4258,f,,,,)","(,,,arstat_input_raw.n50,n50,gid,geo,25833,t,,,,)","(,,,arstat_input_raw.arfjell,arf,gid,geo,4258,f,,,,)"}','{"(1,grl_sk.n5_forvaltning_flate,sl_sdeid,integer,kom,geo,,4258,f)","(2,arstat_input_raw.ssb_vann,gid,integer,vann,geo,,32633,t)","(3,arstat_input_raw.ar5,sl_sdeid,integer,ar5,geo,,4258,f)","(4,arstat_input_raw.n50,gid,integer,n50,geo,,25833,t)","(5,arstat_input_raw.arfjell,gid,integer,arf,geo,,4258,f)"}','(arstat_snap_rmsliv_2025.arstat_result,arstat_snap_rmsliv_2025_1579,4258,f,1e-07,1e-07,t,1,2,t,t,3)',1e-07,'arstat_snap_rmsliv_2025_1579.arstat_result',
 '(2,0,f,,0,0,0,0,0,0,0,0103000020A2100000010000005C000000AC7BEEA71BFA1B406E769DC79E644F40CC588DA407CD1B405D6166E0EE644F4031C512392CCC1B40C18B8A830B654F40F1479EBE1AEC1B4065A5E13CB9694F4053FBE09A74E61B40888ECF707B6B4F40D7C0FDB9C2F01B40B40CE153556D4F40E9257A8064BE1B40321ED1EEA66F4F40A09F208AF9741B4094BD24F0926F4F40EEA58FE227261B408576C5DDF1704F403869EEE2101B1B409430467B32724F4082605DA2520A1B40B3DCD1692B7E4F4094C64E83CEFE194045FB0CC795924F407A0E733E79FE194024B48DD1BC924F40B76D67E2AA5A1B40105CDDE95BA14F408C9707C372711B40143476F517A34F407FE4E464FEDD1C400B7E3053CA934F40A2230256C0711D40287E50B965814F40AD2E0F5785711D40A86F16A736814F40CB363A76E65C1D40DA9F453BE37F4F408F42474A7B591D40A781DAD1677D4F4004593B4D61C81D40CA03F1FC817A4F40CAF0BDDC14F51D40D7C54EBD20764F40F8CE413DBA151E402BBB3E878B764F40414B215B693A1E4074083620EC774F400D5FF425D0641E40AA0D33F8F3764F40634F3D3A766A1E40ACE7490E7B764F40B9B0D5631A6B1E40AAB0139CF6754F4097FC64FDC9701E409A40EF5C81754F4097AE971D916F1E40D4D8B40A90744F40CA0068D304771E40E3D0D95161734F401771207DA0731E4073F985672C734F40F19F3241B4581E40E97B10CF23734F40E9A8F588805B1E40E11138B294714F400246EFFEDD5A1E40CFF524EA5B704F401A9241B4A44E1E4024055C9FC6704F408A1948747C441E4031EF802450704F40F84624CBB12D1E40F3BD312DC46F4F4086190A9130291E40434706DE6F6F4F40BFD85C4F351B1E4012EBFD16456F4F4033B733D9A9171E409CE58D82F96E4F404F6965E9B60C1E40D15FC43A996E4F404DE5F277C6001E405AA00634846E4F409CE811C060EF1D40FA5F12F5DD6D4F4014B6F0615DD81D40A9190C11FB6D4F402D9318038DC61D4022D4FA4E846D4F406B0E99523AC41D404E9BB7216F6D4F4034DF744169C31D404DDD9ADB176D4F400143D06C22B51D40914384A6BE6C4F40E61329161C9F1D40257CA53FE86C4F40194ACD0FF1941D405563B93CA06C4F408022BC7CE98B1D4036640AFDA56B4F40EFA9CCD60B9B1D407EA72F59F46A4F40DD2FA2832DB81D409E0D90431C6A4F408401E162DFB81D40E583D9B8F9694F40AF225DF57CAB1D4038BADB6F31694F40965893BFF1AE1D40444BE2C0D0684F40721FBFFB0FA41D4099C3D95EF3674F40A0348E1FA6A11D4066D396AF6A674F40A8551490BF941D40DB55FF2BB8664F40E7B23B7207851D40708EF3E41F664F409A1C927A93691D40847FA54900664F40729F5C0D03631D40CF404BFAB9654F409FB2F70205511D4068F42D6951654F40D669160165441D40F9AB48E672654F40096A4389E2291D40DD983D4C67654F4075AB75E0A0011D401EFD2922FE634F4045000B1420E91C401FA066142B644F40DB00D53277CF1C40F17A7BC5BE634F40346DA47380CC1C4024D3DC7FE8634F403A51CA8DB8CA1C40A454BEA934644F4003CBF425C1C51C40E7B912765C644F4057C7FA955CA01C40E0041C1EB5624F4099B07935769A1C409E81F047B3624F4014538EF3698D1C40F85A40972D624F4002C9CA527C881C401C12752E1E624F403BFDBBA624801C40EE40FAA38C624F408F7C07F3AA761C4064A1A345E2614F401E46D804746D1C40F3AE03DF89614F40CF8E762F4E681C40B3CECFB91D614F4049EE9B2B90611C40AC1C2967D6604F40CBD736EBE8581C405EBDBFF2C8604F40F530438307561C40D5B5789592604F409F6D8C3ADF4D1C40B5846AA2B2604F4055C44E7DEC481C40DFA63C1872604F409B7F3CFF633A1C405B26C2D128604F4057B50176E92F1C401E2163EF4D604F4036DDB03157251C40FFF606E6A8614F408BF153B796241C40656B35BF01624F4052AC113AE41D1C40F68F59B13F634F40B0DFC0709E191C40FA5F7FA196634F40DD3F638D68141C4076AF3BCCE3634F40AC7BEEA71BFA1B406E769DC79E644F40,1.1889460856827504e-06,)',
 'arstat_snap_rmsliv_2025_1579.arstat_result_job_list','arstat_snap_rmsliv_2025_1579.arstat_result_grid','0103000020A21000000100000005000000A0F2578060401B40CA29AF9AE4704F40A0F2578060401B4038CACC13FC724F40339AFFDC24641B4038CACC13FC724F40339AFFDC24641B40CA29AF9AE4704F40A0F2578060401B40CA29AF9AE4704F40',1,1);
 --jobid=62

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5990#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.