Sagar

• Oct 13th, 2015

Foreign key and primary key linking.

Answer Question  Select Best Answer

SriramKrishna

 Profile Answers by SriramKrishna Questions by SriramKrishna

• May 5th, 2007

OID are used for unique row identification in POSTGRESQL. For identifying specific physical rows with block and offset values in POSTGRESQL TIDs are used. The relationship between OID and TID exists in such a way that whenever a row is altered the corresponding TID also gets altered.

Answer Question  Select Best Answer

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Triggers for tables and rules for view

Answer Question  Select Best Answer

Why the updation and deletion is too slow in Greenplum as compared to Insertion?

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Because of MVCC architecture of PostgreSQL

Answer Question  Select Best Answer

Why the Update Statement works very slowly in Postgresql?

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Because of the MVCC architecture of PostgreSQL but is greatly improved starting PostgreSQL 8.3.x if you are not updating the index field.

Answer Question  Select Best Answer

RUCHI TYAGI

• Oct 8th, 2020

Inverted file is an index data structure used for mapping content to its location to a database file with in a document or in set of documents

Answer Question  Select Best Answer