s
sreelu 123

Posted on 5th March 2024|3287 views

0
votes

Postgresql Ctid

What is Ctid in PostgreSQL?

Answers
P
Altaf syed

Posted on 5th March 2024

  • Ctid is for the location of a tuple.
  • Ctid is a hidden and unique record for each table in PostgreSQL.
  • Itempointer is the data type of the system column ctid. A tuple ID is a pair (block number, tuple index within the block).
  • If you update or move a Row Version of ctid by using VACUUM FULL or AUTO-VACUUM to increase the overall performance.
  • Ctid can be used to delete duplicate records, old version rows or dead rows in a table.

Syntax:

SELECT CTID,* FROM students;

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos