url_test.sh.txt

#!/bin/bash

export PATH=$PATH:$PWD/bin
dbname=postgres
secs=30
psql -c "alter system set max_parallel_workers_per_gather = 0;" $dbname > /dev/null
psql -c "select pg_reload_conf();" $dbname > /dev/null
psql -c "create extension if not exists url;" $dbname > /dev/null


cat << EOSQL > bench.sql
WITH u(url) AS MATERIALIZED (
  SELECT 'https://example.com#comments'::url
)
SELECT url_fragment_set(
           url_path_set(
             url_port_set(
               url_host_set(
                 url_password_set(
                   url_username_set(
                     url_scheme_set( url, 'wss' )
                   , 'guest' )
                 , '12345' )
               , '事例.com' )
             , '8080' )
           , '/а/б/в' )
       , 'comment' )
  FROM u;
EOSQL

for i in {1..5}
do
	pgbench -n -f bench.sql -M prepared -T $secs $dbname | grep tps
done