Eine aufbereitete Darstellung der Quelle

 
     
 
 
Anforderungen  |   Konzepte  |   Entwurf  |   Entwicklung  |   Qualitätssicherung  |   Lebenszyklus  |   Steuerung
 
 
 
 

Benutzer

Quelle  vacuum-no-cleanup-lock.out  Sprache: unbekannt

 
Spracherkennung für: .out vermutete Sprache: Unknown {[0] [0] [0]} [Methode: Schwerpunktbildung, einfache Gewichte, sechs Dimensionen]

Parsed test spec with 4 sessions

starting permutation: vacuumer_pg_class_stats dml_insert vacuumer_nonaggressive_vacuum vacuumer_pg_class_stats
step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       20
(1 row)

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       21
(1 row)


starting permutation: vacuumer_pg_class_stats dml_insert pinholder_cursor vacuumer_nonaggressive_vacuum vacuumer_pg_class_stats pinholder_commit
step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       20
(1 row)

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step pinholder_cursor: 
  BEGIN;
  DECLARE c1 CURSOR FOR SELECT 1 AS dummy FROM smalltbl;
  FETCH NEXT FROM c1;

dummy
-----
    1
(1 row)

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       21
(1 row)

step pinholder_commit: 
  COMMIT;


starting permutation: vacuumer_pg_class_stats pinholder_cursor dml_insert dml_delete dml_insert vacuumer_nonaggressive_vacuum vacuumer_pg_class_stats pinholder_commit
step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       20
(1 row)

step pinholder_cursor: 
  BEGIN;
  DECLARE c1 CURSOR FOR SELECT 1 AS dummy FROM smalltbl;
  FETCH NEXT FROM c1;

dummy
-----
    1
(1 row)

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step dml_delete: 
  DELETE FROM smalltbl WHERE id = (SELECT min(id) FROM smalltbl);

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       21
(1 row)

step pinholder_commit: 
  COMMIT;


starting permutation: vacuumer_pg_class_stats dml_insert dml_delete pinholder_cursor dml_insert vacuumer_nonaggressive_vacuum vacuumer_pg_class_stats pinholder_commit
step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       20
(1 row)

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step dml_delete: 
  DELETE FROM smalltbl WHERE id = (SELECT min(id) FROM smalltbl);

step pinholder_cursor: 
  BEGIN;
  DECLARE c1 CURSOR FOR SELECT 1 AS dummy FROM smalltbl;
  FETCH NEXT FROM c1;

dummy
-----
    1
(1 row)

step dml_insert: 
  INSERT INTO smalltbl SELECT max(id) + 1 FROM smalltbl;

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step vacuumer_pg_class_stats: 
  SELECT relpages, reltuples FROM pg_class WHERE oid = 'smalltbl'::regclass;

relpages|reltuples
--------+---------
       1|       21
(1 row)

step pinholder_commit: 
  COMMIT;


starting permutation: dml_begin dml_other_begin dml_key_share dml_other_key_share vacuumer_nonaggressive_vacuum pinholder_cursor dml_other_update dml_commit dml_other_commit vacuumer_nonaggressive_vacuum pinholder_commit vacuumer_nonaggressive_vacuum
step dml_begin: BEGIN;
step dml_other_begin: BEGIN;
step dml_key_share: SELECT id FROM smalltbl WHERE id = 3 FOR KEY SHARE;
id
--
 3
(1 row)

step dml_other_key_share: SELECT id FROM smalltbl WHERE id = 3 FOR KEY SHARE;
id
--
 3
(1 row)

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step pinholder_cursor: 
  BEGIN;
  DECLARE c1 CURSOR FOR SELECT 1 AS dummy FROM smalltbl;
  FETCH NEXT FROM c1;

dummy
-----
    1
(1 row)

step dml_other_update: UPDATE smalltbl SET t = 'u' WHERE id = 3;
step dml_commit: COMMIT;
step dml_other_commit: COMMIT;
step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;

step pinholder_commit: 
  COMMIT;

step vacuumer_nonaggressive_vacuum: 
  VACUUM smalltbl;


[Dauer der Verarbeitung: 0.12 Sekunden, vorverarbeitet 2026-09-27]

                                                                                                                                                                                                                                                                                                                                                                                                     


Neuigkeiten

     Aktuelles
     Motto des Tages

Open Source Software

     Quellcodebibliothek
     Eigene Quellcodes
     Fremde Quellcodes
     Suchen

Jenseits des Üblichen ....

Besucherstatistik

Besucherstatistik

Statistik
#Sources=1126864
#Domains=1897691