CODEWITHSUNDEEP
sql-serverdatabaseoracle-databasepostgresql
Muhammad Asim
Muhammad Asim

Reputation: 159

Dead and Live tuples in database

I am new to Postgresql and while going through it's features I came across with a concept of "Live and Dead Tuples" which was explained very clearly in this post and I am very clear about this concept now.

My question is that, does this concept applies on all other relational databases as well like Oracle or SQL Server or it's just in PostgreSQL ? Because I've worked with SQL Server previously and I never came across with this terminology before, maybe this never occurred to me before or I never had to use this so I couldn't figure it out.

Upvotes: 1

Views: 1513

Answers (1)

Roger Wolf
Roger Wolf

Reputation: 7692

Yes, the terminology you use appears to be DBMS-specific. In MS SQL Server, in particular, the official term is "ghost record", and the process behind physical row deletion is called Ghost Cleanup.

I'm sure other DBMS use their own terminology, as well.

Upvotes: 3

Related Questions