pg_dirtyread

Read dead but unvacuumed tuples from a PostgreSQL relation

OTHER License

Stars
125

Bot releases are visible (Hide)

pg_dirtyread - pg_dirtyread 2.7 Latest Release

Published by df7cb 4 months ago

  • Set SO_TYPE_SEQSCAN in heap_beginscan() to support PG17.
  • Exercise toast in tests.
pg_dirtyread - pg_dirtyread 2.6

Published by df7cb 11 months ago

  • Add PG16 to github workflow matrix
  • Move index test output to separate file and add variant for PG16
pg_dirtyread - pg_dirtyread 2.5

Published by df7cb 11 months ago

  • Add functions to check unique indexes for duplicates and FKs for missing rows
  • contrib script fixes
pg_dirtyread - pg_dirtyread 2.4

Published by df7cb almost 3 years ago

  • Support PostgreSQL 14
pg_dirtyread - pg_dirtyread 2.3

Published by df7cb almost 3 years ago

  • Support PostgreSQL 13
pg_dirtyread - pg_dirtyread 2.2

Published by df7cb almost 5 years ago

  • regress: Try reading from an index.
  • Contrib: Add function to read all good tuples from a table, skipping
    over all tuples that trigger an error, add function to return ctids of
    all tuples in a table that trigger an error.
  • README: Fix instructions on setting PG_CONFIG.
pg_dirtyread - pg_dirtyread 2.1

Published by df7cb over 5 years ago

  • Support PostgreSQL 12.
pg_dirtyread - pg_dirtyread 1.2

Published by df7cb about 7 years ago

pg-dirtyread (1.2) unstable; urgency=medium

  • Refuse to return the "dead" pseudo column during recovery,
    because GetOldestXmin() asserts !RecoveryInProgress().
    Spotted by Andreas Seltenreich, thanks!

-- Christoph Berg [email protected] Sun, 06 Aug 2017 16:57:41 +0200

pg_dirtyread - pg_dirtyread 1.1

Published by df7cb about 7 years ago

pg-dirtyread (1.1) unstable; urgency=medium

  • Changes from 1.0:
    • Fix some crashes.
    • Add ability to retrieve system columns such as xmax and ctid.
    • Add "dead" column to allow identification of removed rows

-- Christoph Berg [email protected] Sun, 23 Jul 2017 12:47:01 +0200

pg_dirtyread - pg_dirtyread 1.0

Published by df7cb over 7 years ago

This is the original pg_dirtyread code from 2012:
https://github.com/omniti-labs/pgtreats/tree/master/contrib/pg_dirtyread