\timing
Timing is on.
\pset pager always
Pager is always used.
DROP TABLE IF EXISTS deliverynotes CASCADE;
DROP TABLE
Time: 186,182 ms
CREATE TEMP TABLE deliverynotes AS (SELECT * FROM albaranescli ORDER BY idalbaran);
SELECT 333694
Time: 1022,111 ms
ALTER TABLE deliverynotes SET (fillfactor = 60);
ALTER TABLE
Time: 0,426 ms
--VACUUM ANALYZE deliverynotes;
SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
	and relname LIKE 'deliverynote%'
  ORDER BY relname;
        relation         |  size  
-------------------------+--------
 pg_temp_2.deliverynotes | 219 MB
(1 row)

Time: 185,537 ms
  
DELETE FROM   deliverynotes;
DELETE 333694
Time: 558,273 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000;
INSERT 0 50000
Time: 272,404 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 50000;
INSERT 0 50000
Time: 234,166 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 100000;
INSERT 0 50000
Time: 201,888 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 150000;
INSERT 0 50000
Time: 223,916 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 200000;
INSERT 0 50000
Time: 202,668 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 250000;
INSERT 0 50000
Time: 260,133 ms
--VACUUM ANALYZE deliverynotes;
UPDATE deliverynotes SET codserie = '*' WHERE codserie = 'VALUE NOT IN TABLE';
UPDATE 0
Time: 2098,693 ms
UPDATE deliverynotes SET codserie = '*' WHERE codserie IS NULL;
UPDATE 0
Time: 319,783 ms
UPDATE deliverynotes SET codserie = '*' WHERE codserie = 'VALUE ALSO NOT IN TABLE';
UPDATE 0
Time: 265,806 ms
UPDATE deliverynotes SET codserie = '*4' WHERE codserie = '04';
UPDATE 1
Time: 259,346 ms
UPDATE deliverynotes SET codserie = '*3' WHERE codserie = '03';
UPDATE 2258
Time: 273,400 ms
UPDATE deliverynotes SET codserie = '*7' WHERE codserie = '07';
UPDATE 5260
Time: 296,703 ms
UPDATE deliverynotes SET codserie = '*2' WHERE codserie = '02';
UPDATE 43583
Time: 441,170 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie = '01';
 count  
--------
 113615
(1 row)

Time: 348,997 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie = '999';
 count 
-------
     0
(1 row)

Time: 286,985 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie IS NULL;
 count 
-------
     0
(1 row)

Time: 255,898 ms