logo-MindMajix
s
sreelu 123

Posted on 20th June 2024|3325 views

0
votes

Postgresql Ctid

What is Ctid in PostgreSQL?

1 answers
Answers
P
Altaf syed

Posted on 20th June 2024| views

  • 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
Name
Course *
Email *
Phone Number