gddlZddlZddlZddlZedkr:edd5ZeZdddn #1swxYwYngdZe eZ ej dZ d d Z edkr e dSdS) N__main__z/usr/share/dict/wordsbrU)mode)s/usr/share/dict/wordssissreadsins__main__cpttjdtS)z$extract a random word from ``Words``r)Wordsrandom randrange wordcountstripR/granary/edev/quantum/lib/python3.11/site-packages/postgresql/test/perf_copy_io.pygetWordrs& fq),,-33555r Ic ^ td td}d fdtjd|fzfdt |D}tjdt j}||}t j|z }tjd| | |z d z |z ||z fztd }t j}d}|D]}|t|z }t j|z }tjd || d z |z ||z fztd dS#td wxYw) NzLCREATE TEMP TABLE _copy (i int, t text, mt text, ts text, ty text, tx text);zCOPY _copy FROM STDINrc,t|z |S)zcount of bytes)len)datasizes rincsizeztestSpeed..incsizes3t994 ;r zpreparing data(%d tuples)... c g|]}dt|dtttttfdzS) ascii )joinstrencoder).0xrs r ztestSpeed.. s $ $ $ '%**q66==799gii 99gii     $ $ $r zstarting copy... zCOPY FROM STDIN Summary, copied tuples: %d copied bytes: %d duration: %f average tuple size(bytes): %f average KB per second: %f average tuples per second: %f izCOPY _copy TO STDOUTztCOPY TO STDOUT Summary, copied tuples: %d duration: %f average KB per second: %f average tuples per second: %f zDROP TABLE _copy) sqlexecpreparesysstderrwriterangetime load_rowschunksr) tuplesQrstart copied_indurationcrowsrrs @@r testSpeedr1s 89994 %&&! $ *3fY>??? $ $ $ $6]] $ $ $$ *'((( )++%kk$) Y[[5 (*% D(6M4K( X '    $%%! )++%!hhjjdD >11 Y[[5 (*& x4K( X(     ' s E7FF,)r)osr#rr'__name__openwordfile readlinesrrr seedrr1r r rr8s, z d "///8     % H G G CJJ  6667777r z sAA  A