Public Notes on
View Public Collections
PostgreSQL TOAST Data Corruption (ERROR: unexpected chunk number) fluca1978.github.io

Highlights

The TOAST mechanism is great, but until you detoast the content of your data you could not notice a problem in it. Periodically run tools based on the above functions can help you determine if a problem has been generated
kirubakaran
PostgreSQL: Documentation: 14: SELECT www.postgresql.org

Highlights

With SKIP LOCKED, any selected rows that cannot be immediately locked are skipped. Skipping locked rows provides an inconsistent view of the data, so this is not suitable for general purpose work, but can be used to avoid lock contention with multiple consumers accessing a queue-like table.
kirubakaran