PostgreSQL Source Code  git master
 All Data Structures Namespaces Files Functions Variables Typedefs Enumerations Enumerator Macros
heapam.h File Reference
#include "access/sdir.h"
#include "access/skey.h"
#include "nodes/lockoptions.h"
#include "nodes/primnodes.h"
#include "storage/bufpage.h"
#include "storage/lockdefs.h"
#include "utils/relcache.h"
#include "utils/snapshot.h"
Include dependency graph for heapam.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures

struct  HeapUpdateFailureData
 

Macros

#define HEAP_INSERT_SKIP_WAL   0x0001
 
#define HEAP_INSERT_SKIP_FSM   0x0002
 
#define HEAP_INSERT_FROZEN   0x0004
 
#define HEAP_INSERT_SPECULATIVE   0x0008
 
#define MaxLockTupleMode   LockTupleExclusive
 
#define heap_close(r, l)   relation_close(r,l)
 
#define HeapScanIsValid(scan)   PointerIsValid(scan)
 

Typedefs

typedef struct
BulkInsertStateData
BulkInsertState
 
typedef enum LockTupleMode LockTupleMode
 
typedef struct
HeapUpdateFailureData 
HeapUpdateFailureData
 
typedef struct HeapScanDescDataHeapScanDesc
 
typedef struct
ParallelHeapScanDescData
ParallelHeapScanDesc
 

Enumerations

enum  LockTupleMode { LockTupleKeyShare, LockTupleShare, LockTupleNoKeyExclusive, LockTupleExclusive }
 

Functions

Relation relation_open (Oid relationId, LOCKMODE lockmode)
 
Relation try_relation_open (Oid relationId, LOCKMODE lockmode)
 
Relation relation_openrv (const RangeVar *relation, LOCKMODE lockmode)
 
Relation relation_openrv_extended (const RangeVar *relation, LOCKMODE lockmode, bool missing_ok)
 
void relation_close (Relation relation, LOCKMODE lockmode)
 
Relation heap_open (Oid relationId, LOCKMODE lockmode)
 
Relation heap_openrv (const RangeVar *relation, LOCKMODE lockmode)
 
Relation heap_openrv_extended (const RangeVar *relation, LOCKMODE lockmode, bool missing_ok)
 
HeapScanDesc heap_beginscan (Relation relation, Snapshot snapshot, int nkeys, ScanKey key)
 
HeapScanDesc heap_beginscan_catalog (Relation relation, int nkeys, ScanKey key)
 
HeapScanDesc heap_beginscan_strat (Relation relation, Snapshot snapshot, int nkeys, ScanKey key, bool allow_strat, bool allow_sync)
 
HeapScanDesc heap_beginscan_bm (Relation relation, Snapshot snapshot, int nkeys, ScanKey key)
 
HeapScanDesc heap_beginscan_sampling (Relation relation, Snapshot snapshot, int nkeys, ScanKey key, bool allow_strat, bool allow_sync, bool allow_pagemode)
 
void heap_setscanlimits (HeapScanDesc scan, BlockNumber startBlk, BlockNumber endBlk)
 
void heapgetpage (HeapScanDesc scan, BlockNumber page)
 
void heap_rescan (HeapScanDesc scan, ScanKey key)
 
void heap_rescan_set_params (HeapScanDesc scan, ScanKey key, bool allow_strat, bool allow_sync, bool allow_pagemode)
 
void heap_endscan (HeapScanDesc scan)
 
HeapTuple heap_getnext (HeapScanDesc scan, ScanDirection direction)
 
Size heap_parallelscan_estimate (Snapshot snapshot)
 
void heap_parallelscan_initialize (ParallelHeapScanDesc target, Relation relation, Snapshot snapshot)
 
HeapScanDesc heap_beginscan_parallel (Relation, ParallelHeapScanDesc)
 
bool heap_fetch (Relation relation, Snapshot snapshot, HeapTuple tuple, Buffer *userbuf, bool keep_buf, Relation stats_relation)
 
bool heap_hot_search_buffer (ItemPointer tid, Relation relation, Buffer buffer, Snapshot snapshot, HeapTuple heapTuple, bool *all_dead, bool first_call)
 
bool heap_hot_search (ItemPointer tid, Relation relation, Snapshot snapshot, bool *all_dead)
 
void heap_get_latest_tid (Relation relation, Snapshot snapshot, ItemPointer tid)
 
void setLastTid (const ItemPointer tid)
 
BulkInsertState GetBulkInsertState (void)
 
void FreeBulkInsertState (BulkInsertState)
 
void ReleaseBulkInsertStatePin (BulkInsertState bistate)
 
Oid heap_insert (Relation relation, HeapTuple tup, CommandId cid, int options, BulkInsertState bistate)
 
void heap_multi_insert (Relation relation, HeapTuple *tuples, int ntuples, CommandId cid, int options, BulkInsertState bistate)
 
HTSU_Result heap_delete (Relation relation, ItemPointer tid, CommandId cid, Snapshot crosscheck, bool wait, HeapUpdateFailureData *hufd)
 
void heap_finish_speculative (Relation relation, HeapTuple tuple)
 
void heap_abort_speculative (Relation relation, HeapTuple tuple)
 
HTSU_Result heap_update (Relation relation, ItemPointer otid, HeapTuple newtup, CommandId cid, Snapshot crosscheck, bool wait, HeapUpdateFailureData *hufd, LockTupleMode *lockmode)
 
HTSU_Result heap_lock_tuple (Relation relation, HeapTuple tuple, CommandId cid, LockTupleMode mode, LockWaitPolicy wait_policy, bool follow_update, Buffer *buffer, HeapUpdateFailureData *hufd)
 
void heap_inplace_update (Relation relation, HeapTuple tuple)
 
bool heap_freeze_tuple (HeapTupleHeader tuple, TransactionId cutoff_xid, TransactionId cutoff_multi)
 
bool heap_tuple_needs_freeze (HeapTupleHeader tuple, TransactionId cutoff_xid, MultiXactId cutoff_multi, Buffer buf)
 
bool heap_tuple_needs_eventual_freeze (HeapTupleHeader tuple)
 
Oid simple_heap_insert (Relation relation, HeapTuple tup)
 
void simple_heap_delete (Relation relation, ItemPointer tid)
 
void simple_heap_update (Relation relation, ItemPointer otid, HeapTuple tup)
 
void heap_sync (Relation relation)
 
void heap_update_snapshot (HeapScanDesc scan, Snapshot snapshot)
 
void heap_page_prune_opt (Relation relation, Buffer buffer)
 
int heap_page_prune (Relation relation, Buffer buffer, TransactionId OldestXmin, bool report_stats, TransactionId *latestRemovedXid)
 
void heap_page_prune_execute (Buffer buffer, OffsetNumber *redirected, int nredirected, OffsetNumber *nowdead, int ndead, OffsetNumber *nowunused, int nunused)
 
void heap_get_root_tuples (Page page, OffsetNumber *root_offsets)
 
void ss_report_location (Relation rel, BlockNumber location)
 
BlockNumber ss_get_location (Relation rel, BlockNumber relnblocks)
 
void SyncScanShmemInit (void)
 
Size SyncScanShmemSize (void)
 

Macro Definition Documentation

#define heap_close (   r,
 
)    relation_close(r,l)

Definition at line 97 of file heapam.h.

Referenced by acquire_inherited_sample_rows(), AcquireRewriteLocks(), AddEnumLabel(), AddNewAttributeTuples(), addRangeTableEntry(), AddRoleMems(), AfterTriggerSetState(), AggregateCreate(), AlterCollation(), AlterConstraintNamespaces(), AlterDatabase(), AlterDatabaseOwner(), AlterDomainAddConstraint(), AlterDomainDefault(), AlterDomainDropConstraint(), AlterDomainNotNull(), AlterDomainValidateConstraint(), AlterEventTrigger(), AlterEventTriggerOwner(), AlterEventTriggerOwner_oid(), AlterExtensionNamespace(), AlterForeignDataWrapper(), AlterForeignDataWrapperOwner(), AlterForeignDataWrapperOwner_oid(), AlterForeignServer(), AlterForeignServerOwner(), AlterForeignServerOwner_oid(), AlterFunction(), AlterObjectNamespace_oid(), AlterOperator(), AlterPolicy(), AlterPublication(), AlterPublicationOwner(), AlterPublicationOwner_oid(), AlterRole(), AlterSchemaOwner(), AlterSchemaOwner_oid(), AlterSequence(), AlterSetting(), AlterSubscription(), AlterSubscriptionOwner(), AlterSubscriptionOwner_oid(), AlterTableMoveAll(), AlterTableNamespaceInternal(), AlterTableSpaceOptions(), AlterTSConfiguration(), AlterTSDictionary(), AlterTypeNamespaceInternal(), AlterTypeOwner(), AlterTypeOwner_oid(), AlterTypeOwnerInternal(), AlterUserMapping(), AppendAttributeTuples(), ApplyExtensionUpdates(), AssignTypeArrayOid(), ATAddCheckConstraint(), ATAddForeignKeyConstraint(), ATExecAddColumn(), ATExecAddIdentity(), ATExecAddInherit(), ATExecAddOf(), ATExecAlterColumnGenericOptions(), ATExecAlterColumnType(), ATExecAlterConstraint(), ATExecAttachPartition(), ATExecChangeOwner(), ATExecDetachPartition(), ATExecDisableRowSecurity(), ATExecDropColumn(), ATExecDropConstraint(), ATExecDropIdentity(), ATExecDropInherit(), ATExecDropNotNull(), ATExecDropOf(), ATExecEnableRowSecurity(), ATExecForceNoForceRowSecurity(), ATExecGenericOptions(), ATExecSetIdentity(), ATExecSetNotNull(), ATExecSetOptions(), ATExecSetRelOptions(), ATExecSetStatistics(), ATExecSetStorage(), ATExecSetTableSpace(), ATExecValidateConstraint(), ATPrepChangePersistence(), ATRewriteTable(), ATRewriteTables(), AttrDefaultFetch(), boot_openrel(), BootstrapToastTable(), bringetbitmap(), brinvacuumcleanup(), bt_index_check_internal(), build_indices(), build_physical_tlist(), BuildRelationExtStatistics(), CatalogCacheInitializeCache(), change_owner_fix_column_acls(), changeDependencyFor(), changeDependencyOnOwner(), check_db_file_conflict(), check_selective_binary_conversion(), CheckAndCreateToastTable(), CheckConstraintFetch(), checkSharedDependencies(), ChooseConstraintName(), close_lo_relation(), closerel(), CloseTableList(), cluster(), CollationCreate(), ConstraintNameIsUsed(), ConversionCreate(), copy_heap_data(), CopyFrom(), copyTemplateDependencies(), CountDBSubscriptions(), create_proc_lang(), create_toast_table(), CreateAccessMethod(), CreateCast(), CreateComments(), CreateConstraintEntry(), createdb(), CreateForeignDataWrapper(), CreateForeignServer(), CreateForeignTable(), CreateInheritance(), CreateOpFamily(), CreatePolicy(), CreatePublication(), CreateRole(), CreateSharedComments(), CreateSubscription(), CreateTableSpace(), CreateTransform(), CreateTrigger(), CreateUserMapping(), currtid_byrelname(), currtid_byreloid(), currtid_for_view(), database_to_xmlschema_internal(), DefineIndex(), DefineOpClass(), DefineQueryRewrite(), DefineRelation(), DefineSequence(), DefineTSConfiguration(), DefineTSDictionary(), DefineTSParser(), DefineTSTemplate(), DeleteAttributeTuples(), DeleteComments(), deleteDependencyRecordsFor(), deleteDependencyRecordsForClass(), DeleteInitPrivs(), deleteOneObject(), DeleteRelationTuple(), DeleteSecurityLabel(), DeleteSequenceTuple(), DeleteSharedComments(), deleteSharedDependencyRecordsFor(), DeleteSharedSecurityLabel(), DeleteSystemAttributeTuples(), DelRoleMems(), deparseColumnRef(), deparseFromExprForRel(), deparseSelectSql(), do_autovacuum(), DoCopy(), drop_parent_dependency(), DropCastById(), dropDatabaseDependencies(), dropdb(), DropProceduralLanguageById(), DropRole(), DropSetting(), DropSubscription(), DropTableSpace(), DropTransformById(), EnableDisableRule(), EnableDisableTrigger(), ENRMetadataGetTupDesc(), enum_endpoint(), enum_range_internal(), EnumValuesCreate(), EnumValuesDelete(), EventTriggerSQLDropAddObject(), exec_object_restorecon(), ExecAlterExtensionStmt(), ExecAlterObjectDependsStmt(), ExecAlterObjectSchemaStmt(), ExecAlterOwnerStmt(), ExecCleanUpTriggerState(), ExecCloseScanRelation(), ExecEndModifyTable(), ExecEndPlan(), ExecGrant_Database(), ExecGrant_Fdw(), ExecGrant_ForeignServer(), ExecGrant_Function(), ExecGrant_Language(), ExecGrant_Largeobject(), ExecGrant_Namespace(), ExecGrant_Relation(), ExecGrant_Tablespace(), ExecGrant_Type(), ExecInitModifyTable(), ExecRefreshMatView(), ExecRenameStmt(), ExecuteTruncate(), expand_inherited_rtentry(), expand_targetlist(), extension_config_remove(), find_inheritance_children(), find_language_template(), find_typed_table_dependencies(), finish_heap_swap(), fireRIRrules(), free_parsestate(), generate_partition_qual(), get_actual_variable_range(), get_constraint_index(), get_database_list(), get_database_oid(), get_db_info(), get_domain_constraint_oid(), get_extension_name(), get_extension_oid(), get_extension_schema(), get_file_fdw_attribute_options(), get_index_constraint(), get_object_address_relobject(), get_partition_parent(), get_partition_qual_relid(), get_pkey_attnames(), get_primary_key_attnos(), get_rel_oids(), get_relation_constraint_oid(), get_relation_constraints(), get_relation_data_width(), get_relation_info(), get_relation_policy_oid(), get_row_security_policies(), get_subscription_list(), get_tablespace_name(), get_tablespace_oid(), get_trigger_oid(), GetAllTablesPublicationRelations(), GetAllTablesPublications(), GetComment(), getConstraintTypeDescription(), GetDatabaseTuple(), GetDatabaseTupleByOid(), GetDefaultOpClass(), getExtensionOfObject(), getObjectDescription(), getObjectIdentityParts(), getOwnedSequences(), GetPublicationRelations(), getRelationsInNamespace(), GetSecurityLabel(), GetSharedSecurityLabel(), GetSubscriptionNotReadyRelations(), GetSubscriptionRelations(), GetSubscriptionRelState(), gettype(), GrantRole(), has_row_triggers(), has_superclass(), heap_create_with_catalog(), heap_drop_with_catalog(), heap_sync(), heap_truncate(), heap_truncate_find_FKs(), heap_truncate_one_rel(), index_build(), index_constraint_create(), index_create(), index_drop(), index_set_state_flags(), index_update_stats(), infer_arbiter_indexes(), insert_event_trigger_tuple(), InsertExtensionTuple(), InsertRule(), intorel_shutdown(), isQueryUsingTempRelation_walker(), LargeObjectCreate(), LargeObjectDrop(), LargeObjectExists(), load_domaintype_info(), load_enum_cache_data(), logicalrep_rel_close(), LogicalRepSyncTableStart(), lookup_ts_config_cache(), LookupOpclassInfo(), make_new_heap(), make_ruledef(), make_viewdef(), makeArrayTypeName(), mark_index_clustered(), MergeAttributes(), MergeAttributesIntoExisting(), MergeConstraintsIntoExisting(), MergeWithExistingConstraint(), movedb(), myLargeObjectExists(), NamespaceCreate(), objectsInSchemaToOids(), OpenTableList(), OperatorCreate(), OperatorShellMake(), OperatorUpd(), performDeletion(), performMultipleDeletions(), pg_event_trigger_ddl_commands(), pg_extension_config_dump(), pg_extension_ownercheck(), pg_get_constraintdef_worker(), pg_get_replica_identity_index(), pg_get_serial_sequence(), pg_get_triggerdef_worker(), pg_identify_object(), pg_largeobject_aclmask_snapshot(), pg_largeobject_ownercheck(), pgrowlocks(), pgstat_collect_oids(), postgresPlanDirectModify(), postgresPlanForeignModify(), ProcedureCreate(), process_settings(), publication_add_relation(), RangeCreate(), RangeDelete(), rebuild_relation(), recordExtensionInitPrivWorker(), recordMultipleDependencies(), recordSharedDependencyOn(), refresh_by_match_merge(), reindex_index(), reindex_relation(), ReindexMultipleTables(), relation_has_policies(), relation_mark_replica_identity(), RelationBuildRowSecurity(), RelationBuildRuleLock(), RelationBuildTriggers(), RelationBuildTupleDesc(), RelationGetExclusionInfo(), RelationGetFKeyList(), RelationGetIndexList(), RelationGetStatExtList(), RelationRemoveInheritance(), RelationSetNewRelfilenode(), RelidByRelfilenode(), remove_dbtablespaces(), RemoveAccessMethodById(), RemoveAmOpEntryById(), RemoveAmProcEntryById(), RemoveAttrDefault(), RemoveAttrDefaultById(), RemoveAttributeById(), RemoveCollationById(), RemoveConstraintById(), RemoveConversionById(), RemoveDefaultACLById(), RemoveEventTriggerById(), RemoveExtensionById(), RemoveForeignDataWrapperById(), RemoveForeignServerById(), RemoveFunctionById(), RemoveInheritance(), RemoveObjects(), RemoveOpClassById(), RemoveOperatorById(), RemoveOpFamilyById(), RemovePartitionKeyByRelId(), RemovePolicyById(), RemovePublicationById(), RemovePublicationRelById(), RemoveRewriteRuleById(), RemoveRoleFromObjectACL(), RemoveRoleFromObjectPolicy(), RemoveSchemaById(), RemoveStatistics(), RemoveStatisticsById(), RemoveSubscriptionRel(), RemoveTriggerById(), RemoveTSConfigurationById(), RemoveTSDictionaryById(), RemoveTSParserById(), RemoveTSTemplateById(), RemoveTypeById(), RemoveUserMappingById(), rename_policy(), renameatt_internal(), RenameConstraint(), RenameConstraintById(), RenameDatabase(), RenameEnumLabel(), RenameRelationInternal(), RenameRewriteRule(), RenameRole(), RenameSchema(), RenameTableSpace(), renametrig(), RenameType(), RenameTypeInternal(), replorigin_create(), replorigin_drop(), RewriteQuery(), rewriteTargetView(), RI_FKey_cascade_del(), RI_FKey_cascade_upd(), RI_FKey_check(), RI_FKey_setdefault_del(), RI_FKey_setdefault_upd(), RI_FKey_setnull_del(), RI_FKey_setnull_upd(), ri_restrict_del(), ri_restrict_upd(), ScanPgRelation(), schema_to_xmlschema_internal(), SearchCatCache(), SearchCatCacheList(), sepgsql_attribute_post_create(), sepgsql_database_post_create(), sepgsql_index_modify(), sepgsql_proc_post_create(), sepgsql_proc_setattr(), sepgsql_relation_post_create(), sepgsql_relation_setattr(), sepgsql_schema_post_create(), sequenceIsOwned(), SetDefaultACL(), SetFunctionArgType(), SetFunctionReturnType(), SetMatViewPopulatedState(), SetRelationHasSubclass(), SetRelationNumChecks(), SetRelationRuleStatus(), SetSecurityLabel(), SetSharedSecurityLabel(), SetSubscriptionRelState(), setTargetTable(), shdepDropOwned(), shdepReassignOwned(), StoreAttrDefault(), StoreCatalogInheritance(), storeOperators(), StorePartitionBound(), StorePartitionKey(), storeProcedures(), swap_relation_files(), table_to_xml_and_xmlschema(), table_to_xmlschema(), ThereIsAtLeastOneRole(), toast_delete_datum(), toast_fetch_datum(), toast_fetch_datum_slice(), toast_get_valid_index(), toast_save_datum(), toastid_valueid_exists(), transformIndexConstraint(), transformIndexStmt(), transformRuleStmt(), transformTableLikeClause(), transientrel_shutdown(), TypeCreate(), typeInheritsFrom(), TypeShellMake(), update_attstats(), updateAclDependencies(), UpdateIndexRelation(), vac_truncate_clog(), vac_update_datfrozenxid(), vac_update_relstats(), validate_index(), validateDomainConstraint(), and ValidatePartitionConstraints().

#define HEAP_INSERT_FROZEN   0x0004

Definition at line 30 of file heapam.h.

Referenced by CopyFrom(), heap_prepare_insert(), and transientrel_startup().

#define HEAP_INSERT_SKIP_FSM   0x0002
#define HEAP_INSERT_SPECULATIVE   0x0008

Definition at line 31 of file heapam.h.

Referenced by ExecInsert(), heap_insert(), and toast_insert_or_update().

#define HeapScanIsValid (   scan)    PointerIsValid(scan)

Definition at line 107 of file heapam.h.

#define MaxLockTupleMode   LockTupleExclusive

Definition at line 50 of file heapam.h.

Typedef Documentation

Definition at line 33 of file heapam.h.

Definition at line 100 of file heapam.h.

Definition at line 101 of file heapam.h.

Enumeration Type Documentation

Enumerator
LockTupleKeyShare 
LockTupleShare 
LockTupleNoKeyExclusive 
LockTupleExclusive 

Definition at line 38 of file heapam.h.

39 {
40  /* SELECT FOR KEY SHARE */
42  /* SELECT FOR SHARE */
44  /* SELECT FOR NO KEY UPDATE, and UPDATEs that don't modify key columns */
46  /* SELECT FOR UPDATE, UPDATEs that modify key columns, and DELETE */
LockTupleMode
Definition: heapam.h:38

Function Documentation

void FreeBulkInsertState ( BulkInsertState  )

Definition at line 2349 of file heapam.c.

References BulkInsertStateData::current_buf, FreeAccessStrategy(), InvalidBuffer, pfree(), ReleaseBuffer(), and BulkInsertStateData::strategy.

Referenced by ATRewriteTable(), CopyFrom(), intorel_shutdown(), and transientrel_shutdown().

2350 {
2351  if (bistate->current_buf != InvalidBuffer)
2352  ReleaseBuffer(bistate->current_buf);
2353  FreeAccessStrategy(bistate->strategy);
2354  pfree(bistate);
2355 }
#define InvalidBuffer
Definition: buf.h:25
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
void pfree(void *pointer)
Definition: mcxt.c:950
void FreeAccessStrategy(BufferAccessStrategy strategy)
Definition: freelist.c:597
BulkInsertState GetBulkInsertState ( void  )

Definition at line 2335 of file heapam.c.

References BAS_BULKWRITE, BulkInsertStateData::current_buf, GetAccessStrategy(), InvalidBuffer, palloc(), and BulkInsertStateData::strategy.

Referenced by ATRewriteTable(), CopyFrom(), intorel_startup(), and transientrel_startup().

2336 {
2337  BulkInsertState bistate;
2338 
2339  bistate = (BulkInsertState) palloc(sizeof(BulkInsertStateData));
2341  bistate->current_buf = InvalidBuffer;
2342  return bistate;
2343 }
BufferAccessStrategy GetAccessStrategy(BufferAccessStrategyType btype)
Definition: freelist.c:542
#define InvalidBuffer
Definition: buf.h:25
struct BulkInsertStateData * BulkInsertState
Definition: heapam.h:33
BufferAccessStrategy strategy
Definition: hio.h:33
void * palloc(Size size)
Definition: mcxt.c:849
Buffer current_buf
Definition: hio.h:34
void heap_abort_speculative ( Relation  relation,
HeapTuple  tuple 
)

Definition at line 6104 of file heapam.c.

References Assert, buffer, BUFFER_LOCK_EXCLUSIVE, BUFFER_LOCK_UNLOCK, BufferGetPage, compute_infobits(), elog, END_CRIT_SECTION, ERROR, xl_heap_delete::flags, GetCurrentTransactionId(), HEAP_KEYS_UPDATED, HEAP_MOVED, HEAP_XMAX_BITS, HeapTupleHasExternal, HeapTupleHeaderIsHeapOnly, HeapTupleHeaderIsSpeculative, HeapTupleHeaderSetXmin, xl_heap_delete::infobits_set, InvalidTransactionId, IsToastRelation(), ItemIdGetLength, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, ItemPointerIsValid, LockBuffer(), MarkBufferDirty(), xl_heap_delete::offnum, PageGetItem, PageGetItemId, PageIsAllVisible, PageSetLSN, PageSetPrunable, pgstat_count_heap_delete(), ReadBuffer(), RecentGlobalXmin, REGBUF_STANDARD, RelationGetRelid, RelationNeedsWAL, ReleaseBuffer(), SizeOfHeapDelete, START_CRIT_SECTION, HeapTupleHeaderData::t_choice, HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, HeapTupleHeaderData::t_heap, HeapTupleHeaderData::t_infomask, HeapTupleHeaderData::t_infomask2, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, HeapTupleFields::t_xmin, toast_delete(), TransactionIdIsValid, XLH_DELETE_IS_SUPER, XLOG_HEAP_DELETE, XLogBeginInsert(), XLogInsert(), XLogRegisterBuffer(), XLogRegisterData(), and xl_heap_delete::xmax.

Referenced by ExecInsert(), and toast_delete_datum().

6105 {
6107  ItemPointer tid = &(tuple->t_self);
6108  ItemId lp;
6109  HeapTupleData tp;
6110  Page page;
6111  BlockNumber block;
6112  Buffer buffer;
6113 
6114  Assert(ItemPointerIsValid(tid));
6115 
6116  block = ItemPointerGetBlockNumber(tid);
6117  buffer = ReadBuffer(relation, block);
6118  page = BufferGetPage(buffer);
6119 
6121 
6122  /*
6123  * Page can't be all visible, we just inserted into it, and are still
6124  * running.
6125  */
6126  Assert(!PageIsAllVisible(page));
6127 
6128  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
6129  Assert(ItemIdIsNormal(lp));
6130 
6131  tp.t_tableOid = RelationGetRelid(relation);
6132  tp.t_data = (HeapTupleHeader) PageGetItem(page, lp);
6133  tp.t_len = ItemIdGetLength(lp);
6134  tp.t_self = *tid;
6135 
6136  /*
6137  * Sanity check that the tuple really is a speculatively inserted tuple,
6138  * inserted by us.
6139  */
6140  if (tp.t_data->t_choice.t_heap.t_xmin != xid)
6141  elog(ERROR, "attempted to kill a tuple inserted by another transaction");
6142  if (!(IsToastRelation(relation) || HeapTupleHeaderIsSpeculative(tp.t_data)))
6143  elog(ERROR, "attempted to kill a non-speculative tuple");
6145 
6146  /*
6147  * No need to check for serializable conflicts here. There is never a
6148  * need for a combocid, either. No need to extract replica identity, or
6149  * do anything special with infomask bits.
6150  */
6151 
6153 
6154  /*
6155  * The tuple will become DEAD immediately. Flag that this page
6156  * immediately is a candidate for pruning by setting xmin to
6157  * RecentGlobalXmin. That's not pretty, but it doesn't seem worth
6158  * inventing a nicer API for this.
6159  */
6162 
6163  /* store transaction information of xact deleting the tuple */
6166 
6167  /*
6168  * Set the tuple header xmin to InvalidTransactionId. This makes the
6169  * tuple immediately invisible everyone. (In particular, to any
6170  * transactions waiting on the speculative token, woken up later.)
6171  */
6173 
6174  /* Clear the speculative insertion token too */
6175  tp.t_data->t_ctid = tp.t_self;
6176 
6177  MarkBufferDirty(buffer);
6178 
6179  /*
6180  * XLOG stuff
6181  *
6182  * The WAL records generated here match heap_delete(). The same recovery
6183  * routines are used.
6184  */
6185  if (RelationNeedsWAL(relation))
6186  {
6187  xl_heap_delete xlrec;
6188  XLogRecPtr recptr;
6189 
6190  xlrec.flags = XLH_DELETE_IS_SUPER;
6192  tp.t_data->t_infomask2);
6194  xlrec.xmax = xid;
6195 
6196  XLogBeginInsert();
6197  XLogRegisterData((char *) &xlrec, SizeOfHeapDelete);
6198  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6199 
6200  /* No replica identity & replication origin logged */
6201 
6202  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_DELETE);
6203 
6204  PageSetLSN(page, recptr);
6205  }
6206 
6207  END_CRIT_SECTION();
6208 
6209  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
6210 
6211  if (HeapTupleHasExternal(&tp))
6212  {
6213  Assert(!IsToastRelation(relation));
6214  toast_delete(relation, &tp, true);
6215  }
6216 
6217  /*
6218  * Never need to mark tuple for invalidation, since catalogs don't support
6219  * speculative insertion
6220  */
6221 
6222  /* Now we can release the buffer */
6223  ReleaseBuffer(buffer);
6224 
6225  /* count deletion, as we counted the insertion too */
6226  pgstat_count_heap_delete(relation);
6227 }
#define ItemPointerIsValid(pointer)
Definition: itemptr.h:60
#define BUFFER_LOCK_UNLOCK
Definition: bufmgr.h:87
bool IsToastRelation(Relation relation)
Definition: catalog.c:136
#define HEAP_XMAX_BITS
Definition: htup_details.h:256
union HeapTupleHeaderData::@45 t_choice
#define XLH_DELETE_IS_SUPER
Definition: heapam_xlog.h:95
static uint8 compute_infobits(uint16 infomask, uint16 infomask2)
Definition: heapam.c:2968
HeapTupleFields t_heap
Definition: htup_details.h:146
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:397
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define HeapTupleHeaderIsSpeculative(tup)
Definition: htup_details.h:423
#define PageSetPrunable(page, xid)
Definition: bufpage.h:394
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
uint32 BlockNumber
Definition: block.h:31
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define BUFFER_LOCK_EXCLUSIVE
Definition: bufmgr.h:89
OffsetNumber offnum
Definition: heapam_xlog.h:105
HeapTupleHeader t_data
Definition: htup.h:67
#define HeapTupleHeaderIsHeapOnly(tup)
Definition: htup_details.h:502
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
#define ERROR
Definition: elog.h:43
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
TransactionId xmax
Definition: heapam_xlog.h:104
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:417
uint32 t_len
Definition: htup.h:64
#define SizeOfHeapDelete
Definition: heapam_xlog.h:110
TransactionId RecentGlobalXmin
Definition: snapmgr.c:166
#define REGBUF_STANDARD
Definition: xloginsert.h:34
#define InvalidTransactionId
Definition: transam.h:31
Oid t_tableOid
Definition: htup.h:66
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
TransactionId t_xmin
Definition: htup_details.h:118
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define HEAP_KEYS_UPDATED
Definition: htup_details.h:264
#define HEAP_MOVED
Definition: htup_details.h:202
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
uint8 infobits_set
Definition: heapam_xlog.h:106
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define RelationNeedsWAL(relation)
Definition: rel.h:505
void pgstat_count_heap_delete(Relation rel)
Definition: pgstat.c:1953
#define HeapTupleHasExternal(tuple)
Definition: htup_details.h:674
void toast_delete(Relation rel, HeapTuple oldtup, bool is_speculative)
Definition: tuptoaster.c:464
#define elog
Definition: elog.h:219
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define TransactionIdIsValid(xid)
Definition: transam.h:41
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
#define XLOG_HEAP_DELETE
Definition: heapam_xlog.h:33
#define RelationGetRelid(relation)
Definition: rel.h:416
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
#define HeapTupleHeaderSetXmin(tup, xid)
Definition: htup_details.h:313
HeapScanDesc heap_beginscan ( Relation  relation,
Snapshot  snapshot,
int  nkeys,
ScanKey  key 
)

Definition at line 1397 of file heapam.c.

References heap_beginscan_internal().

Referenced by AlterDomainNotNull(), ATRewriteTable(), copy_heap_data(), CopyTo(), DefineQueryRewrite(), pgrowlocks(), pgstat_collect_oids(), RelationFindReplTupleSeq(), SeqNext(), validateCheckConstraint(), validateDomainConstraint(), and validateForeignKeyConstraint().

1399 {
1400  return heap_beginscan_internal(relation, snapshot, nkeys, key, NULL,
1401  true, true, true, false, false, false);
1402 }
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
HeapScanDesc heap_beginscan_bm ( Relation  relation,
Snapshot  snapshot,
int  nkeys,
ScanKey  key 
)

Definition at line 1425 of file heapam.c.

References heap_beginscan_internal().

Referenced by ExecInitBitmapHeapScan().

1427 {
1428  return heap_beginscan_internal(relation, snapshot, nkeys, key, NULL,
1429  false, false, true, true, false, false);
1430 }
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
HeapScanDesc heap_beginscan_catalog ( Relation  relation,
int  nkeys,
ScanKey  key 
)

Definition at line 1405 of file heapam.c.

References GetCatalogSnapshot(), heap_beginscan_internal(), RegisterSnapshot(), and RelationGetRelid.

Referenced by AlterTableMoveAll(), AlterTableSpaceOptions(), boot_openrel(), check_db_file_conflict(), createdb(), do_autovacuum(), DropSetting(), DropTableSpace(), find_typed_table_dependencies(), get_database_list(), get_rel_oids(), get_subscription_list(), get_tables_to_cluster(), get_tablespace_name(), get_tablespace_oid(), GetAllTablesPublicationRelations(), getRelationsInNamespace(), gettype(), index_update_stats(), objectsInSchemaToOids(), ReindexMultipleTables(), remove_dbtablespaces(), RemoveConversionById(), RemoveSubscriptionRel(), RenameTableSpace(), ThereIsAtLeastOneRole(), and vac_truncate_clog().

1406 {
1407  Oid relid = RelationGetRelid(relation);
1408  Snapshot snapshot = RegisterSnapshot(GetCatalogSnapshot(relid));
1409 
1410  return heap_beginscan_internal(relation, snapshot, nkeys, key, NULL,
1411  true, true, true, false, false, true);
1412 }
Snapshot RegisterSnapshot(Snapshot snapshot)
Definition: snapmgr.c:863
Snapshot GetCatalogSnapshot(Oid relid)
Definition: snapmgr.c:440
unsigned int Oid
Definition: postgres_ext.h:31
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
#define RelationGetRelid(relation)
Definition: rel.h:416
HeapScanDesc heap_beginscan_parallel ( Relation  ,
ParallelHeapScanDesc   
)

Definition at line 1652 of file heapam.c.

References Assert, heap_beginscan_internal(), ParallelHeapScanDescData::phs_relid, ParallelHeapScanDescData::phs_snapshot_data, RegisterSnapshot(), RelationGetRelid, and RestoreSnapshot().

Referenced by ExecSeqScanInitializeDSM(), and ExecSeqScanInitializeWorker().

1653 {
1654  Snapshot snapshot;
1655 
1656  Assert(RelationGetRelid(relation) == parallel_scan->phs_relid);
1657  snapshot = RestoreSnapshot(parallel_scan->phs_snapshot_data);
1658  RegisterSnapshot(snapshot);
1659 
1660  return heap_beginscan_internal(relation, snapshot, 0, NULL, parallel_scan,
1661  true, true, true, false, false, true);
1662 }
Snapshot RestoreSnapshot(char *start_address)
Definition: snapmgr.c:2121
Snapshot RegisterSnapshot(Snapshot snapshot)
Definition: snapmgr.c:863
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
#define Assert(condition)
Definition: c.h:676
#define RelationGetRelid(relation)
Definition: rel.h:416
HeapScanDesc heap_beginscan_sampling ( Relation  relation,
Snapshot  snapshot,
int  nkeys,
ScanKey  key,
bool  allow_strat,
bool  allow_sync,
bool  allow_pagemode 
)

Definition at line 1433 of file heapam.c.

References heap_beginscan_internal().

Referenced by tablesample_init().

1436 {
1437  return heap_beginscan_internal(relation, snapshot, nkeys, key, NULL,
1438  allow_strat, allow_sync, allow_pagemode,
1439  false, true, false);
1440 }
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
HeapScanDesc heap_beginscan_strat ( Relation  relation,
Snapshot  snapshot,
int  nkeys,
ScanKey  key,
bool  allow_strat,
bool  allow_sync 
)

Definition at line 1415 of file heapam.c.

References heap_beginscan_internal().

Referenced by IndexBuildHeapRangeScan(), IndexCheckExclusion(), pgstat_heap(), systable_beginscan(), and validate_index_heapscan().

1418 {
1419  return heap_beginscan_internal(relation, snapshot, nkeys, key, NULL,
1420  allow_strat, allow_sync, true,
1421  false, false, false);
1422 }
static HeapScanDesc heap_beginscan_internal(Relation relation, Snapshot snapshot, int nkeys, ScanKey key, ParallelHeapScanDesc parallel_scan, bool allow_strat, bool allow_sync, bool allow_pagemode, bool is_bitmapscan, bool is_samplescan, bool temp_snap)
Definition: heapam.c:1443
#define NULL
Definition: c.h:229
HTSU_Result heap_delete ( Relation  relation,
ItemPointer  tid,
CommandId  cid,
Snapshot  crosscheck,
bool  wait,
HeapUpdateFailureData hufd 
)

Definition at line 3027 of file heapam.c.

References Assert, buffer, BUFFER_LOCK_EXCLUSIVE, BUFFER_LOCK_UNLOCK, BufferGetBlockNumber(), BufferGetPage, CacheInvalidateHeapTuple(), CheckForSerializableConflictIn(), HeapUpdateFailureData::cmax, compute_infobits(), compute_new_xmax_infomask(), HeapUpdateFailureData::ctid, DoesMultiXactIdConflict(), END_CRIT_SECTION, ereport, errcode(), errmsg(), ERROR, ExtractReplicaIdentity(), xl_heap_delete::flags, GetCurrentTransactionId(), heap_acquire_tuplock(), heap_freetuple(), HEAP_KEYS_UPDATED, HEAP_MOVED, HEAP_XMAX_BITS, HEAP_XMAX_INVALID, HEAP_XMAX_IS_LOCKED_ONLY, HEAP_XMAX_IS_MULTI, HeapTupleBeingUpdated, HeapTupleHasExternal, HeapTupleHeaderAdjustCmax(), HeapTupleHeaderClearHotUpdated, HeapTupleHeaderGetCmax(), HeapTupleHeaderGetRawXmax, HeapTupleHeaderGetUpdateXid, HeapTupleHeaderIsOnlyLocked(), HeapTupleHeaderSetCmax, HeapTupleHeaderSetXmax, HeapTupleInvisible, HeapTupleMayBeUpdated, HeapTupleSatisfiesUpdate(), HeapTupleSatisfiesVisibility, HeapTupleSelfUpdated, HeapTupleUpdated, xl_heap_delete::infobits_set, InvalidBuffer, InvalidCommandId, InvalidSnapshot, IsInParallelMode(), ItemIdGetLength, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, ItemPointerIsValid, LockBuffer(), LockTupleExclusive, LockWaitBlock, log_heap_new_cid(), MarkBufferDirty(), MultiXactIdSetOldestMember(), MultiXactIdWait(), MultiXactStatusUpdate, NULL, xl_heap_delete::offnum, PageClearAllVisible, PageGetItem, PageGetItemId, PageIsAllVisible, PageSetLSN, PageSetPrunable, pgstat_count_heap_delete(), RelationData::rd_rel, ReadBuffer(), REGBUF_STANDARD, RelationGetRelid, RelationIsAccessibleInLogicalDecoding, RelationNeedsWAL, ReleaseBuffer(), RELKIND_MATVIEW, RELKIND_RELATION, REPLICA_IDENTITY_FULL, result, SizeOfHeapDelete, SizeOfHeapHeader, SizeofHeapTupleHeader, START_CRIT_SECTION, HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, xl_heap_header::t_hoff, HeapTupleHeaderData::t_hoff, xl_heap_header::t_infomask, HeapTupleHeaderData::t_infomask, xl_heap_header::t_infomask2, HeapTupleHeaderData::t_infomask2, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, toast_delete(), TransactionIdEquals, TransactionIdIsCurrentTransactionId(), UnlockReleaseBuffer(), UnlockTupleTuplock, UpdateXmaxHintBits(), visibilitymap_clear(), visibilitymap_pin(), VISIBILITYMAP_VALID_BITS, XactLockTableWait(), XLH_DELETE_ALL_VISIBLE_CLEARED, XLH_DELETE_CONTAINS_OLD_KEY, XLH_DELETE_CONTAINS_OLD_TUPLE, XLOG_HEAP_DELETE, XLOG_INCLUDE_ORIGIN, XLogBeginInsert(), XLogInsert(), XLogRegisterBuffer(), XLogRegisterData(), XLogSetRecordFlags(), XLTW_Delete, HeapUpdateFailureData::xmax, xl_heap_delete::xmax, and xmax_infomask_changed().

Referenced by ExecDelete(), and simple_heap_delete().

3030 {
3033  ItemId lp;
3034  HeapTupleData tp;
3035  Page page;
3036  BlockNumber block;
3037  Buffer buffer;
3038  Buffer vmbuffer = InvalidBuffer;
3039  TransactionId new_xmax;
3040  uint16 new_infomask,
3041  new_infomask2;
3042  bool have_tuple_lock = false;
3043  bool iscombo;
3044  bool all_visible_cleared = false;
3045  HeapTuple old_key_tuple = NULL; /* replica identity of the tuple */
3046  bool old_key_copied = false;
3047 
3048  Assert(ItemPointerIsValid(tid));
3049 
3050  /*
3051  * Forbid this during a parallel operation, lest it allocate a combocid.
3052  * Other workers might need that combocid for visibility checks, and we
3053  * have no provision for broadcasting it to them.
3054  */
3055  if (IsInParallelMode())
3056  ereport(ERROR,
3057  (errcode(ERRCODE_INVALID_TRANSACTION_STATE),
3058  errmsg("cannot delete tuples during a parallel operation")));
3059 
3060  block = ItemPointerGetBlockNumber(tid);
3061  buffer = ReadBuffer(relation, block);
3062  page = BufferGetPage(buffer);
3063 
3064  /*
3065  * Before locking the buffer, pin the visibility map page if it appears to
3066  * be necessary. Since we haven't got the lock yet, someone else might be
3067  * in the middle of changing this, so we'll need to recheck after we have
3068  * the lock.
3069  */
3070  if (PageIsAllVisible(page))
3071  visibilitymap_pin(relation, block, &vmbuffer);
3072 
3074 
3075  /*
3076  * If we didn't pin the visibility map page and the page has become all
3077  * visible while we were busy locking the buffer, we'll have to unlock and
3078  * re-lock, to avoid holding the buffer lock across an I/O. That's a bit
3079  * unfortunate, but hopefully shouldn't happen often.
3080  */
3081  if (vmbuffer == InvalidBuffer && PageIsAllVisible(page))
3082  {
3083  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3084  visibilitymap_pin(relation, block, &vmbuffer);
3086  }
3087 
3088  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
3089  Assert(ItemIdIsNormal(lp));
3090 
3091  tp.t_tableOid = RelationGetRelid(relation);
3092  tp.t_data = (HeapTupleHeader) PageGetItem(page, lp);
3093  tp.t_len = ItemIdGetLength(lp);
3094  tp.t_self = *tid;
3095 
3096 l1:
3097  result = HeapTupleSatisfiesUpdate(&tp, cid, buffer);
3098 
3099  if (result == HeapTupleInvisible)
3100  {
3101  UnlockReleaseBuffer(buffer);
3102  ereport(ERROR,
3103  (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
3104  errmsg("attempted to delete invisible tuple")));
3105  }
3106  else if (result == HeapTupleBeingUpdated && wait)
3107  {
3108  TransactionId xwait;
3109  uint16 infomask;
3110 
3111  /* must copy state data before unlocking buffer */
3112  xwait = HeapTupleHeaderGetRawXmax(tp.t_data);
3113  infomask = tp.t_data->t_infomask;
3114 
3115  /*
3116  * Sleep until concurrent transaction ends -- except when there's a
3117  * single locker and it's our own transaction. Note we don't care
3118  * which lock mode the locker has, because we need the strongest one.
3119  *
3120  * Before sleeping, we need to acquire tuple lock to establish our
3121  * priority for the tuple (see heap_lock_tuple). LockTuple will
3122  * release us when we are next-in-line for the tuple.
3123  *
3124  * If we are forced to "start over" below, we keep the tuple lock;
3125  * this arranges that we stay at the head of the line while rechecking
3126  * tuple state.
3127  */
3128  if (infomask & HEAP_XMAX_IS_MULTI)
3129  {
3130  /* wait for multixact */
3131  if (DoesMultiXactIdConflict((MultiXactId) xwait, infomask,
3133  {
3134  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3135 
3136  /* acquire tuple lock, if necessary */
3138  LockWaitBlock, &have_tuple_lock);
3139 
3140  /* wait for multixact */
3142  relation, &(tp.t_self), XLTW_Delete,
3143  NULL);
3145 
3146  /*
3147  * If xwait had just locked the tuple then some other xact
3148  * could update this tuple before we get to this point. Check
3149  * for xmax change, and start over if so.
3150  */
3151  if (xmax_infomask_changed(tp.t_data->t_infomask, infomask) ||
3153  xwait))
3154  goto l1;
3155  }
3156 
3157  /*
3158  * You might think the multixact is necessarily done here, but not
3159  * so: it could have surviving members, namely our own xact or
3160  * other subxacts of this backend. It is legal for us to delete
3161  * the tuple in either case, however (the latter case is
3162  * essentially a situation of upgrading our former shared lock to
3163  * exclusive). We don't bother changing the on-disk hint bits
3164  * since we are about to overwrite the xmax altogether.
3165  */
3166  }
3167  else if (!TransactionIdIsCurrentTransactionId(xwait))
3168  {
3169  /*
3170  * Wait for regular transaction to end; but first, acquire tuple
3171  * lock.
3172  */
3173  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3175  LockWaitBlock, &have_tuple_lock);
3176  XactLockTableWait(xwait, relation, &(tp.t_self), XLTW_Delete);
3178 
3179  /*
3180  * xwait is done, but if xwait had just locked the tuple then some
3181  * other xact could update this tuple before we get to this point.
3182  * Check for xmax change, and start over if so.
3183  */
3184  if (xmax_infomask_changed(tp.t_data->t_infomask, infomask) ||
3186  xwait))
3187  goto l1;
3188 
3189  /* Otherwise check if it committed or aborted */
3190  UpdateXmaxHintBits(tp.t_data, buffer, xwait);
3191  }
3192 
3193  /*
3194  * We may overwrite if previous xmax aborted, or if it committed but
3195  * only locked the tuple without updating it.
3196  */
3197  if ((tp.t_data->t_infomask & HEAP_XMAX_INVALID) ||
3200  result = HeapTupleMayBeUpdated;
3201  else
3202  result = HeapTupleUpdated;
3203  }
3204 
3205  if (crosscheck != InvalidSnapshot && result == HeapTupleMayBeUpdated)
3206  {
3207  /* Perform additional check for transaction-snapshot mode RI updates */
3208  if (!HeapTupleSatisfiesVisibility(&tp, crosscheck, buffer))
3209  result = HeapTupleUpdated;
3210  }
3211 
3212  if (result != HeapTupleMayBeUpdated)
3213  {
3214  Assert(result == HeapTupleSelfUpdated ||
3215  result == HeapTupleUpdated ||
3216  result == HeapTupleBeingUpdated);
3218  hufd->ctid = tp.t_data->t_ctid;
3220  if (result == HeapTupleSelfUpdated)
3221  hufd->cmax = HeapTupleHeaderGetCmax(tp.t_data);
3222  else
3223  hufd->cmax = InvalidCommandId;
3224  UnlockReleaseBuffer(buffer);
3225  if (have_tuple_lock)
3226  UnlockTupleTuplock(relation, &(tp.t_self), LockTupleExclusive);
3227  if (vmbuffer != InvalidBuffer)
3228  ReleaseBuffer(vmbuffer);
3229  return result;
3230  }
3231 
3232  /*
3233  * We're about to do the actual delete -- check for conflict first, to
3234  * avoid possibly having to roll back work we've just done.
3235  *
3236  * This is safe without a recheck as long as there is no possibility of
3237  * another process scanning the page between this check and the delete
3238  * being visible to the scan (i.e., an exclusive buffer content lock is
3239  * continuously held from this point until the tuple delete is visible).
3240  */
3241  CheckForSerializableConflictIn(relation, &tp, buffer);
3242 
3243  /* replace cid with a combo cid if necessary */
3244  HeapTupleHeaderAdjustCmax(tp.t_data, &cid, &iscombo);
3245 
3246  /*
3247  * Compute replica identity tuple before entering the critical section so
3248  * we don't PANIC upon a memory allocation failure.
3249  */
3250  old_key_tuple = ExtractReplicaIdentity(relation, &tp, true, &old_key_copied);
3251 
3252  /*
3253  * If this is the first possibly-multixact-able operation in the current
3254  * transaction, set my per-backend OldestMemberMXactId setting. We can be
3255  * certain that the transaction will never become a member of any older
3256  * MultiXactIds than that. (We have to do this even if we end up just
3257  * using our own TransactionId below, since some other backend could
3258  * incorporate our XID into a MultiXact immediately afterwards.)
3259  */
3261 
3264  xid, LockTupleExclusive, true,
3265  &new_xmax, &new_infomask, &new_infomask2);
3266 
3268 
3269  /*
3270  * If this transaction commits, the tuple will become DEAD sooner or
3271  * later. Set flag that this page is a candidate for pruning once our xid
3272  * falls below the OldestXmin horizon. If the transaction finally aborts,
3273  * the subsequent page pruning will be a no-op and the hint will be
3274  * cleared.
3275  */
3276  PageSetPrunable(page, xid);
3277 
3278  if (PageIsAllVisible(page))
3279  {
3280  all_visible_cleared = true;
3281  PageClearAllVisible(page);
3282  visibilitymap_clear(relation, BufferGetBlockNumber(buffer),
3283  vmbuffer, VISIBILITYMAP_VALID_BITS);
3284  }
3285 
3286  /* store transaction information of xact deleting the tuple */
3289  tp.t_data->t_infomask |= new_infomask;
3290  tp.t_data->t_infomask2 |= new_infomask2;
3292  HeapTupleHeaderSetXmax(tp.t_data, new_xmax);
3293  HeapTupleHeaderSetCmax(tp.t_data, cid, iscombo);
3294  /* Make sure there is no forward chain link in t_ctid */
3295  tp.t_data->t_ctid = tp.t_self;
3296 
3297  MarkBufferDirty(buffer);
3298 
3299  /*
3300  * XLOG stuff
3301  *
3302  * NB: heap_abort_speculative() uses the same xlog record and replay
3303  * routines.
3304  */
3305  if (RelationNeedsWAL(relation))
3306  {
3307  xl_heap_delete xlrec;
3308  XLogRecPtr recptr;
3309 
3310  /* For logical decode we need combocids to properly decode the catalog */
3312  log_heap_new_cid(relation, &tp);
3313 
3314  xlrec.flags = all_visible_cleared ? XLH_DELETE_ALL_VISIBLE_CLEARED : 0;
3316  tp.t_data->t_infomask2);
3318  xlrec.xmax = new_xmax;
3319 
3320  if (old_key_tuple != NULL)
3321  {
3322  if (relation->rd_rel->relreplident == REPLICA_IDENTITY_FULL)
3324  else
3326  }
3327 
3328  XLogBeginInsert();
3329  XLogRegisterData((char *) &xlrec, SizeOfHeapDelete);
3330 
3331  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
3332 
3333  /*
3334  * Log replica identity of the deleted tuple if there is one
3335  */
3336  if (old_key_tuple != NULL)
3337  {
3338  xl_heap_header xlhdr;
3339 
3340  xlhdr.t_infomask2 = old_key_tuple->t_data->t_infomask2;
3341  xlhdr.t_infomask = old_key_tuple->t_data->t_infomask;
3342  xlhdr.t_hoff = old_key_tuple->t_data->t_hoff;
3343 
3344  XLogRegisterData((char *) &xlhdr, SizeOfHeapHeader);
3345  XLogRegisterData((char *) old_key_tuple->t_data
3347  old_key_tuple->t_len
3349  }
3350 
3351  /* filtering by origin on a row level is much more efficient */
3353 
3354  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_DELETE);
3355 
3356  PageSetLSN(page, recptr);
3357  }
3358 
3359  END_CRIT_SECTION();
3360 
3361  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3362 
3363  if (vmbuffer != InvalidBuffer)
3364  ReleaseBuffer(vmbuffer);
3365 
3366  /*
3367  * If the tuple has toasted out-of-line attributes, we need to delete
3368  * those items too. We have to do this before releasing the buffer
3369  * because we need to look at the contents of the tuple, but it's OK to
3370  * release the content lock on the buffer first.
3371  */
3372  if (relation->rd_rel->relkind != RELKIND_RELATION &&
3373  relation->rd_rel->relkind != RELKIND_MATVIEW)
3374  {
3375  /* toast table entries should never be recursively toasted */
3377  }
3378  else if (HeapTupleHasExternal(&tp))
3379  toast_delete(relation, &tp, false);
3380 
3381  /*
3382  * Mark tuple for invalidation from system caches at next command
3383  * boundary. We have to do this before releasing the buffer because we
3384  * need to look at the contents of the tuple.
3385  */
3386  CacheInvalidateHeapTuple(relation, &tp, NULL);
3387 
3388  /* Now we can release the buffer */
3389  ReleaseBuffer(buffer);
3390 
3391  /*
3392  * Release the lmgr tuple lock, if we had it.
3393  */
3394  if (have_tuple_lock)
3395  UnlockTupleTuplock(relation, &(tp.t_self), LockTupleExclusive);
3396 
3397  pgstat_count_heap_delete(relation);
3398 
3399  if (old_key_tuple != NULL && old_key_copied)
3400  heap_freetuple(old_key_tuple);
3401 
3402  return HeapTupleMayBeUpdated;
3403 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
bool HeapTupleHeaderIsOnlyLocked(HeapTupleHeader tuple)
Definition: tqual.c:1585
#define ItemPointerIsValid(pointer)
Definition: itemptr.h:60
#define BUFFER_LOCK_UNLOCK
Definition: bufmgr.h:87
#define SizeofHeapTupleHeader
Definition: htup_details.h:170
static XLogRecPtr log_heap_new_cid(Relation relation, HeapTuple tup)
Definition: heapam.c:7744
#define HEAP_XMAX_BITS
Definition: htup_details.h:256
static uint8 compute_infobits(uint16 infomask, uint16 infomask2)
Definition: heapam.c:2968
void CacheInvalidateHeapTuple(Relation relation, HeapTuple tuple, HeapTuple newtuple)
Definition: inval.c:1094
#define TransactionIdEquals(id1, id2)
Definition: transam.h:43
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:397
HTSU_Result HeapTupleSatisfiesUpdate(HeapTuple htup, CommandId curcid, Buffer buffer)
Definition: tqual.c:460
bool TransactionIdIsCurrentTransactionId(TransactionId xid)
Definition: xact.c:773
void visibilitymap_pin(Relation rel, BlockNumber heapBlk, Buffer *buf)
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
static bool xmax_infomask_changed(uint16 new_infomask, uint16 old_infomask)
Definition: heapam.c:2990
#define HeapTupleHeaderClearHotUpdated(tup)
Definition: htup_details.h:497
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define RELKIND_MATVIEW
Definition: pg_class.h:165
#define InvalidBuffer
Definition: buf.h:25
uint16 t_infomask2
Definition: heapam_xlog.h:122
#define PageSetPrunable(page, xid)
Definition: bufpage.h:394
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
int errcode(int sqlerrcode)
Definition: elog.c:575
#define XLOG_INCLUDE_ORIGIN
Definition: xlog.h:191
return result
Definition: formatting.c:1633
uint32 BlockNumber
Definition: block.h:31
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define BUFFER_LOCK_EXCLUSIVE
Definition: bufmgr.h:89
Form_pg_class rd_rel
Definition: rel.h:114
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1373
void CheckForSerializableConflictIn(Relation relation, HeapTuple tuple, Buffer buffer)
Definition: predicate.c:4324
#define UnlockTupleTuplock(rel, tup, mode)
Definition: heapam.c:183
#define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer)
Definition: tqual.h:45
OffsetNumber offnum
Definition: heapam_xlog.h:105
void MultiXactIdSetOldestMember(void)
Definition: multixact.c:623
#define VISIBILITYMAP_VALID_BITS
Definition: visibilitymap.h:28
HeapTupleHeader t_data
Definition: htup.h:67
#define HeapTupleHeaderGetRawXmax(tup)
Definition: htup_details.h:369
unsigned short uint16
Definition: c.h:267
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
bool IsInParallelMode(void)
Definition: xact.c:913
bool visibilitymap_clear(Relation rel, BlockNumber heapBlk, Buffer buf, uint8 flags)
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
#define REPLICA_IDENTITY_FULL
Definition: pg_class.h:179
#define ERROR
Definition: elog.h:43
#define HEAP_XMAX_INVALID
Definition: htup_details.h:193
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
TransactionId xmax
Definition: heapam_xlog.h:104
static void MultiXactIdWait(MultiXactId multi, MultiXactStatus status, uint16 infomask, Relation rel, ItemPointer ctid, XLTW_Oper oper, int *remaining)
Definition: heapam.c:7160
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:417
uint32 t_len
Definition: htup.h:64
#define SizeOfHeapDelete
Definition: heapam_xlog.h:110
#define REGBUF_STANDARD
Definition: xloginsert.h:34
#define XLH_DELETE_CONTAINS_OLD_KEY
Definition: heapam_xlog.h:94
CommandId cmax
Definition: heapam.h:72
#define HeapTupleHeaderSetXmax(tup, xid)
Definition: htup_details.h:374
HTSU_Result
Definition: snapshot.h:119
Oid t_tableOid
Definition: htup.h:66
void XLogSetRecordFlags(uint8 flags)
Definition: xloginsert.c:397
#define HeapTupleHeaderSetCmax(tup, cid, iscombo)
Definition: htup_details.h:399
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define ereport(elevel, rest)
Definition: elog.h:122
static void compute_new_xmax_infomask(TransactionId xmax, uint16 old_infomask, uint16 old_infomask2, TransactionId add_to_xmax, LockTupleMode mode, bool is_update, TransactionId *result_xmax, uint16 *result_infomask, uint16 *result_infomask2)
Definition: heapam.c:5272
TransactionId xmax
Definition: heapam.h:71
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
#define InvalidSnapshot
Definition: snapshot.h:25
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
#define RelationIsAccessibleInLogicalDecoding(relation)
Definition: rel.h:559
#define InvalidCommandId
Definition: c.h:414
#define HEAP_XMAX_IS_LOCKED_ONLY(infomask)
Definition: htup_details.h:216
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define HEAP_KEYS_UPDATED
Definition: htup_details.h:264
#define HEAP_XMAX_IS_MULTI
Definition: htup_details.h:194
static void UpdateXmaxHintBits(HeapTupleHeader tuple, Buffer buffer, TransactionId xid)
Definition: heapam.c:2313
#define HEAP_MOVED
Definition: htup_details.h:202
static bool heap_acquire_tuplock(Relation relation, ItemPointer tid, LockTupleMode mode, LockWaitPolicy wait_policy, bool *have_tuple_lock)
Definition: heapam.c:5223
TransactionId MultiXactId
Definition: c.h:407
#define PageClearAllVisible(page)
Definition: bufpage.h:385
void XactLockTableWait(TransactionId xid, Relation rel, ItemPointer ctid, XLTW_Oper oper)
Definition: lmgr.c:554
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
uint8 infobits_set
Definition: heapam_xlog.h:106
static HeapTuple ExtractReplicaIdentity(Relation rel, HeapTuple tup, bool key_modified, bool *copy)
Definition: heapam.c:7820
CommandId HeapTupleHeaderGetCmax(HeapTupleHeader tup)
Definition: combocid.c:119
static bool DoesMultiXactIdConflict(MultiXactId multi, uint16 infomask, LockTupleMode lockmode)
Definition: heapam.c:6993
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
uint16 t_infomask
Definition: heapam_xlog.h:123
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define RelationNeedsWAL(relation)
Definition: rel.h:505
void pgstat_count_heap_delete(Relation rel)
Definition: pgstat.c:1953
void HeapTupleHeaderAdjustCmax(HeapTupleHeader tup, CommandId *cmax, bool *iscombo)
Definition: combocid.c:154
BlockNumber BufferGetBlockNumber(Buffer buffer)
Definition: bufmgr.c:2605
#define HeapTupleHasExternal(tuple)
Definition: htup_details.h:674
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define XLH_DELETE_ALL_VISIBLE_CLEARED
Definition: heapam_xlog.h:92
void toast_delete(Relation rel, HeapTuple oldtup, bool is_speculative)
Definition: tuptoaster.c:464
ItemPointerData ctid
Definition: heapam.h:70
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define RELKIND_RELATION
Definition: pg_class.h:160
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
#define XLOG_HEAP_DELETE
Definition: heapam_xlog.h:33
#define RelationGetRelid(relation)
Definition: rel.h:416
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
#define SizeOfHeapHeader
Definition: heapam_xlog.h:127
Pointer Page
Definition: bufpage.h:74
#define XLH_DELETE_CONTAINS_OLD_TUPLE
Definition: heapam_xlog.h:93
void heap_endscan ( HeapScanDesc  scan)

Definition at line 1580 of file heapam.c.

References BufferIsValid, FreeAccessStrategy(), pfree(), RelationDecrementReferenceCount(), ReleaseBuffer(), HeapScanDescData::rs_cbuf, HeapScanDescData::rs_key, HeapScanDescData::rs_rd, HeapScanDescData::rs_snapshot, HeapScanDescData::rs_strategy, HeapScanDescData::rs_temp_snap, and UnregisterSnapshot().

Referenced by AlterDomainNotNull(), AlterTableMoveAll(), AlterTableSpaceOptions(), ATRewriteTable(), boot_openrel(), check_db_file_conflict(), copy_heap_data(), CopyTo(), createdb(), DefineQueryRewrite(), do_autovacuum(), DropSetting(), DropTableSpace(), ExecEndBitmapHeapScan(), ExecEndSampleScan(), ExecEndSeqScan(), find_typed_table_dependencies(), get_database_list(), get_rel_oids(), get_subscription_list(), get_tables_to_cluster(), get_tablespace_name(), get_tablespace_oid(), GetAllTablesPublicationRelations(), getRelationsInNamespace(), gettype(), index_update_stats(), IndexBuildHeapRangeScan(), IndexCheckExclusion(), objectsInSchemaToOids(), pgrowlocks(), pgstat_collect_oids(), pgstat_heap(), ReindexMultipleTables(), RelationFindReplTupleSeq(), remove_dbtablespaces(), RemoveConversionById(), RemoveSubscriptionRel(), RenameTableSpace(), systable_endscan(), ThereIsAtLeastOneRole(), vac_truncate_clog(), validate_index_heapscan(), validateCheckConstraint(), validateDomainConstraint(), and validateForeignKeyConstraint().

1581 {
1582  /* Note: no locking manipulations needed */
1583 
1584  /*
1585  * unpin scan buffers
1586  */
1587  if (BufferIsValid(scan->rs_cbuf))
1588  ReleaseBuffer(scan->rs_cbuf);
1589 
1590  /*
1591  * decrement relation reference count and free scan descriptor storage
1592  */
1594 
1595  if (scan->rs_key)
1596  pfree(scan->rs_key);
1597 
1598  if (scan->rs_strategy != NULL)
1600 
1601  if (scan->rs_temp_snap)
1603 
1604  pfree(scan);
1605 }
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
void pfree(void *pointer)
Definition: mcxt.c:950
void RelationDecrementReferenceCount(Relation rel)
Definition: relcache.c:2144
Snapshot rs_snapshot
Definition: relscan.h:49
void UnregisterSnapshot(Snapshot snapshot)
Definition: snapmgr.c:905
bool rs_temp_snap
Definition: relscan.h:57
BufferAccessStrategy rs_strategy
Definition: relscan.h:64
Relation rs_rd
Definition: relscan.h:48
Buffer rs_cbuf
Definition: relscan.h:71
void FreeAccessStrategy(BufferAccessStrategy strategy)
Definition: freelist.c:597
#define NULL
Definition: c.h:229
#define BufferIsValid(bufnum)
Definition: bufmgr.h:114
ScanKey rs_key
Definition: relscan.h:51
bool heap_fetch ( Relation  relation,
Snapshot  snapshot,
HeapTuple  tuple,
Buffer userbuf,
bool  keep_buf,
Relation  stats_relation 
)

Definition at line 1878 of file heapam.c.

References buffer, BUFFER_LOCK_SHARE, BUFFER_LOCK_UNLOCK, BufferGetPage, CheckForSerializableConflictOut(), HeapTupleSatisfiesVisibility, InvalidBuffer, ItemIdGetLength, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), NULL, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, pgstat_count_heap_fetch, PredicateLockTuple(), ReadBuffer(), RelationGetRelid, ReleaseBuffer(), HeapTupleData::t_data, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, and TestForOldSnapshot().

Referenced by AfterTriggerExecute(), EvalPlanQualFetch(), EvalPlanQualFetchRowMarks(), ExecCheckTIDVisible(), ExecDelete(), ExecLockRows(), heap_lock_updated_tuple_rec(), and TidNext().

1884 {
1885  ItemPointer tid = &(tuple->t_self);
1886  ItemId lp;
1887  Buffer buffer;
1888  Page page;
1889  OffsetNumber offnum;
1890  bool valid;
1891 
1892  /*
1893  * Fetch and pin the appropriate page of the relation.
1894  */
1895  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(tid));
1896 
1897  /*
1898  * Need share lock on buffer to examine tuple commit status.
1899  */
1900  LockBuffer(buffer, BUFFER_LOCK_SHARE);
1901  page = BufferGetPage(buffer);
1902  TestForOldSnapshot(snapshot, relation, page);
1903 
1904  /*
1905  * We'd better check for out-of-range offnum in case of VACUUM since the
1906  * TID was obtained.
1907  */
1908  offnum = ItemPointerGetOffsetNumber(tid);
1909  if (offnum < FirstOffsetNumber || offnum > PageGetMaxOffsetNumber(page))
1910  {
1911  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1912  if (keep_buf)
1913  *userbuf = buffer;
1914  else
1915  {
1916  ReleaseBuffer(buffer);
1917  *userbuf = InvalidBuffer;
1918  }
1919  tuple->t_data = NULL;
1920  return false;
1921  }
1922 
1923  /*
1924  * get the item line pointer corresponding to the requested tid
1925  */
1926  lp = PageGetItemId(page, offnum);
1927 
1928  /*
1929  * Must check for deleted tuple.
1930  */
1931  if (!ItemIdIsNormal(lp))
1932  {
1933  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1934  if (keep_buf)
1935  *userbuf = buffer;
1936  else
1937  {
1938  ReleaseBuffer(buffer);
1939  *userbuf = InvalidBuffer;
1940  }
1941  tuple->t_data = NULL;
1942  return false;
1943  }
1944 
1945  /*
1946  * fill in *tuple fields
1947  */
1948  tuple->t_data = (HeapTupleHeader) PageGetItem(page, lp);
1949  tuple->t_len = ItemIdGetLength(lp);
1950  tuple->t_tableOid = RelationGetRelid(relation);
1951 
1952  /*
1953  * check time qualification of tuple, then release lock
1954  */
1955  valid = HeapTupleSatisfiesVisibility(tuple, snapshot, buffer);
1956 
1957  if (valid)
1958  PredicateLockTuple(relation, tuple, snapshot);
1959 
1960  CheckForSerializableConflictOut(valid, relation, tuple, buffer, snapshot);
1961 
1962  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1963 
1964  if (valid)
1965  {
1966  /*
1967  * All checks passed, so return the tuple as valid. Caller is now
1968  * responsible for releasing the buffer.
1969  */
1970  *userbuf = buffer;
1971 
1972  /* Count the successful fetch against appropriate rel, if any */
1973  if (stats_relation != NULL)
1974  pgstat_count_heap_fetch(stats_relation);
1975 
1976  return true;
1977  }
1978 
1979  /* Tuple failed time qual, but maybe caller wants to see it anyway. */
1980  if (keep_buf)
1981  *userbuf = buffer;
1982  else
1983  {
1984  ReleaseBuffer(buffer);
1985  *userbuf = InvalidBuffer;
1986  }
1987 
1988  return false;
1989 }
#define BUFFER_LOCK_UNLOCK
Definition: bufmgr.h:87
static void TestForOldSnapshot(Snapshot snapshot, Relation relation, Page page)
Definition: bufmgr.h:265
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define InvalidBuffer
Definition: buf.h:25
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
void CheckForSerializableConflictOut(bool visible, Relation relation, HeapTuple tuple, Buffer buffer, Snapshot snapshot)
Definition: predicate.c:3943
#define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer)
Definition: tqual.h:45
uint16 OffsetNumber
Definition: off.h:24
HeapTupleHeader t_data
Definition: htup.h:67
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
ItemPointerData t_self
Definition: htup.h:65
#define pgstat_count_heap_fetch(rel)
Definition: pgstat.h:1261
uint32 t_len
Definition: htup.h:64
Oid t_tableOid
Definition: htup.h:66
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define NULL
Definition: c.h:229
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
void PredicateLockTuple(Relation relation, HeapTuple tuple, Snapshot snapshot)
Definition: predicate.c:2541
#define BUFFER_LOCK_SHARE
Definition: bufmgr.h:88
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
int Buffer
Definition: buf.h:23
#define RelationGetRelid(relation)
Definition: rel.h:416
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
void heap_finish_speculative ( Relation  relation,
HeapTuple  tuple 
)

Definition at line 6013 of file heapam.c.

References Assert, buffer, BUFFER_LOCK_EXCLUSIVE, BufferGetPage, elog, END_CRIT_SECTION, ERROR, HeapTupleHeaderIsSpeculative, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), MarkBufferDirty(), MaxOffsetNumber, NULL, xl_heap_confirm::offnum, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, PageSetLSN, ReadBuffer(), REGBUF_STANDARD, RelationNeedsWAL, SizeOfHeapConfirm, SpecTokenOffsetNumber, START_CRIT_SECTION, StaticAssertStmt, HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, HeapTupleData::t_self, UnlockReleaseBuffer(), XLOG_HEAP_CONFIRM, XLOG_INCLUDE_ORIGIN, XLogBeginInsert(), XLogInsert(), XLogRegisterBuffer(), XLogRegisterData(), and XLogSetRecordFlags().

Referenced by ExecInsert().

6014 {
6015  Buffer buffer;
6016  Page page;
6017  OffsetNumber offnum;
6018  ItemId lp = NULL;
6019  HeapTupleHeader htup;
6020 
6021  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(&(tuple->t_self)));
6023  page = (Page) BufferGetPage(buffer);
6024 
6025  offnum = ItemPointerGetOffsetNumber(&(tuple->t_self));
6026  if (PageGetMaxOffsetNumber(page) >= offnum)
6027  lp = PageGetItemId(page, offnum);
6028 
6029  if (PageGetMaxOffsetNumber(page) < offnum || !ItemIdIsNormal(lp))
6030  elog(ERROR, "invalid lp");
6031 
6032  htup = (HeapTupleHeader) PageGetItem(page, lp);
6033 
6034  /* SpecTokenOffsetNumber should be distinguishable from any real offset */
6036  "invalid speculative token constant");
6037 
6038  /* NO EREPORT(ERROR) from here till changes are logged */
6040 
6042 
6043  MarkBufferDirty(buffer);
6044 
6045  /*
6046  * Replace the speculative insertion token with a real t_ctid, pointing to
6047  * itself like it does on regular tuples.
6048  */
6049  htup->t_ctid = tuple->t_self;
6050 
6051  /* XLOG stuff */
6052  if (RelationNeedsWAL(relation))
6053  {
6054  xl_heap_confirm xlrec;
6055  XLogRecPtr recptr;
6056 
6057  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
6058 
6059  XLogBeginInsert();
6060 
6061  /* We want the same filtering on this as on a plain insert */
6063 
6064  XLogRegisterData((char *) &xlrec, SizeOfHeapConfirm);
6065  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6066 
6067  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_CONFIRM);
6068 
6069  PageSetLSN(page, recptr);
6070  }
6071 
6072  END_CRIT_SECTION();
6073 
6074  UnlockReleaseBuffer(buffer);
6075 }
OffsetNumber offnum
Definition: heapam_xlog.h:274
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define MaxOffsetNumber
Definition: off.h:28
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define HeapTupleHeaderIsSpeculative(tup)
Definition: htup_details.h:423
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
#define XLOG_INCLUDE_ORIGIN
Definition: xlog.h:191
#define BUFFER_LOCK_EXCLUSIVE
Definition: bufmgr.h:89
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
uint16 OffsetNumber
Definition: off.h:24
HeapTupleHeader t_data
Definition: htup.h:67
#define StaticAssertStmt(condition, errmessage)
Definition: c.h:758
#define SpecTokenOffsetNumber
Definition: htup_details.h:285
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
#define ERROR
Definition: elog.h:43
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
#define REGBUF_STANDARD
Definition: xloginsert.h:34
void XLogSetRecordFlags(uint8 flags)
Definition: xloginsert.c:397
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define SizeOfHeapConfirm
Definition: heapam_xlog.h:277
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define RelationNeedsWAL(relation)
Definition: rel.h:505
#define elog
Definition: elog.h:219
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
#define XLOG_HEAP_CONFIRM
Definition: heapam_xlog.h:37
bool heap_freeze_tuple ( HeapTupleHeader  tuple,
TransactionId  cutoff_xid,
TransactionId  cutoff_multi 
)

Definition at line 6819 of file heapam.c.

References heap_execute_freeze_tuple(), and heap_prepare_freeze_tuple().

Referenced by rewrite_heap_tuple().

6821 {
6823  bool do_freeze;
6824  bool tuple_totally_frozen;
6825 
6826  do_freeze = heap_prepare_freeze_tuple(tuple, cutoff_xid, cutoff_multi,
6827  &frz, &tuple_totally_frozen);
6828 
6829  /*
6830  * Note that because this is not a WAL-logged operation, we don't need to
6831  * fill in the offset in the freeze record.
6832  */
6833 
6834  if (do_freeze)
6835  heap_execute_freeze_tuple(tuple, &frz);
6836  return do_freeze;
6837 }
void heap_execute_freeze_tuple(HeapTupleHeader tuple, xl_heap_freeze_tuple *frz)
Definition: heapam.c:6798
bool heap_prepare_freeze_tuple(HeapTupleHeader tuple, TransactionId cutoff_xid, TransactionId cutoff_multi, xl_heap_freeze_tuple *frz, bool *totally_frozen_p)
Definition: heapam.c:6620
void heap_get_latest_tid ( Relation  relation,
Snapshot  snapshot,
ItemPointer  tid 
)

Definition at line 2183 of file heapam.c.

References buffer, BUFFER_LOCK_SHARE, BufferGetPage, CheckForSerializableConflictOut(), elog, ERROR, HEAP_XMAX_INVALID, HeapTupleHeaderGetUpdateXid, HeapTupleHeaderGetXmin, HeapTupleHeaderIsOnlyLocked(), HeapTupleSatisfiesVisibility, InvalidTransactionId, ItemIdGetLength, ItemIdIsNormal, ItemPointerEquals(), ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, ItemPointerIsValid, LockBuffer(), PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, ReadBuffer(), RelationGetNumberOfBlocks, RelationGetRelationName, RelationGetRelid, HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, HeapTupleHeaderData::t_infomask, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, TestForOldSnapshot(), TransactionIdEquals, TransactionIdIsValid, and UnlockReleaseBuffer().

Referenced by currtid_byrelname(), currtid_byreloid(), and TidNext().

2186 {
2187  BlockNumber blk;
2188  ItemPointerData ctid;
2189  TransactionId priorXmax;
2190 
2191  /* this is to avoid Assert failures on bad input */
2192  if (!ItemPointerIsValid(tid))
2193  return;
2194 
2195  /*
2196  * Since this can be called with user-supplied TID, don't trust the input
2197  * too much. (RelationGetNumberOfBlocks is an expensive check, so we
2198  * don't check t_ctid links again this way. Note that it would not do to
2199  * call it just once and save the result, either.)
2200  */
2201  blk = ItemPointerGetBlockNumber(tid);
2202  if (blk >= RelationGetNumberOfBlocks(relation))
2203  elog(ERROR, "block number %u is out of range for relation \"%s\"",
2204  blk, RelationGetRelationName(relation));
2205 
2206  /*
2207  * Loop to chase down t_ctid links. At top of loop, ctid is the tuple we
2208  * need to examine, and *tid is the TID we will return if ctid turns out
2209  * to be bogus.
2210  *
2211  * Note that we will loop until we reach the end of the t_ctid chain.
2212  * Depending on the snapshot passed, there might be at most one visible
2213  * version of the row, but we don't try to optimize for that.
2214  */
2215  ctid = *tid;
2216  priorXmax = InvalidTransactionId; /* cannot check first XMIN */
2217  for (;;)
2218  {
2219  Buffer buffer;
2220  Page page;
2221  OffsetNumber offnum;
2222  ItemId lp;
2223  HeapTupleData tp;
2224  bool valid;
2225 
2226  /*
2227  * Read, pin, and lock the page.
2228  */
2229  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(&ctid));
2230  LockBuffer(buffer, BUFFER_LOCK_SHARE);
2231  page = BufferGetPage(buffer);
2232  TestForOldSnapshot(snapshot, relation, page);
2233 
2234  /*
2235  * Check for bogus item number. This is not treated as an error
2236  * condition because it can happen while following a t_ctid link. We
2237  * just assume that the prior tid is OK and return it unchanged.
2238  */
2239  offnum = ItemPointerGetOffsetNumber(&ctid);
2240  if (offnum < FirstOffsetNumber || offnum > PageGetMaxOffsetNumber(page))
2241  {
2242  UnlockReleaseBuffer(buffer);
2243  break;
2244  }
2245  lp = PageGetItemId(page, offnum);
2246  if (!ItemIdIsNormal(lp))
2247  {
2248  UnlockReleaseBuffer(buffer);
2249  break;
2250  }
2251 
2252  /* OK to access the tuple */
2253  tp.t_self = ctid;
2254  tp.t_data = (HeapTupleHeader) PageGetItem(page, lp);
2255  tp.t_len = ItemIdGetLength(lp);
2256  tp.t_tableOid = RelationGetRelid(relation);
2257 
2258  /*
2259  * After following a t_ctid link, we might arrive at an unrelated
2260  * tuple. Check for XMIN match.
2261  */
2262  if (TransactionIdIsValid(priorXmax) &&
2264  {
2265  UnlockReleaseBuffer(buffer);
2266  break;
2267  }
2268 
2269  /*
2270  * Check time qualification of tuple; if visible, set it as the new
2271  * result candidate.
2272  */
2273  valid = HeapTupleSatisfiesVisibility(&tp, snapshot, buffer);
2274  CheckForSerializableConflictOut(valid, relation, &tp, buffer, snapshot);
2275  if (valid)
2276  *tid = ctid;
2277 
2278  /*
2279  * If there's a valid t_ctid link, follow it, else we're done.
2280  */
2281  if ((tp.t_data->t_infomask & HEAP_XMAX_INVALID) ||
2284  {
2285  UnlockReleaseBuffer(buffer);
2286  break;
2287  }
2288 
2289  ctid = tp.t_data->t_ctid;
2290  priorXmax = HeapTupleHeaderGetUpdateXid(tp.t_data);
2291  UnlockReleaseBuffer(buffer);
2292  } /* end of loop */
2293 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
bool HeapTupleHeaderIsOnlyLocked(HeapTupleHeader tuple)
Definition: tqual.c:1585
#define ItemPointerIsValid(pointer)
Definition: itemptr.h:60
static void TestForOldSnapshot(Snapshot snapshot, Relation relation, Page page)
Definition: bufmgr.h:265
#define TransactionIdEquals(id1, id2)
Definition: transam.h:43
uint32 TransactionId
Definition: c.h:397
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
uint32 BlockNumber
Definition: block.h:31
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
void CheckForSerializableConflictOut(bool visible, Relation relation, HeapTuple tuple, Buffer buffer, Snapshot snapshot)
Definition: predicate.c:3943
#define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer)
Definition: tqual.h:45
uint16 OffsetNumber
Definition: off.h:24
HeapTupleHeader t_data
Definition: htup.h:67
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
#define ERROR
Definition: elog.h:43
#define HEAP_XMAX_INVALID
Definition: htup_details.h:193
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
uint32 t_len
Definition: htup.h:64
#define InvalidTransactionId
Definition: transam.h:31
#define RelationGetRelationName(relation)
Definition: rel.h:436
Oid t_tableOid
Definition: htup.h:66
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define RelationGetNumberOfBlocks(reln)
Definition: bufmgr.h:199
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
#define HeapTupleHeaderGetXmin(tup)
Definition: htup_details.h:307
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
bool ItemPointerEquals(ItemPointer pointer1, ItemPointer pointer2)
Definition: itemptr.c:29
#define BUFFER_LOCK_SHARE
Definition: bufmgr.h:88
#define elog
Definition: elog.h:219
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define TransactionIdIsValid(xid)
Definition: transam.h:41
int Buffer
Definition: buf.h:23
#define RelationGetRelid(relation)
Definition: rel.h:416
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
void heap_get_root_tuples ( Page  page,
OffsetNumber root_offsets 
)

Definition at line 743 of file pruneheap.c.

References Assert, FirstOffsetNumber, HeapTupleHeaderGetUpdateXid, HeapTupleHeaderGetXmin, HeapTupleHeaderIsHeapOnly, HeapTupleHeaderIsHotUpdated, InvalidTransactionId, ItemIdGetRedirect, ItemIdIsDead, ItemIdIsNormal, ItemIdIsRedirected, ItemIdIsUsed, ItemPointerGetOffsetNumber, MaxHeapTuplesPerPage, MemSet, OffsetNumberNext, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, HeapTupleHeaderData::t_ctid, TransactionIdEquals, and TransactionIdIsValid.

Referenced by IndexBuildHeapRangeScan(), and validate_index_heapscan().

744 {
745  OffsetNumber offnum,
746  maxoff;
747 
748  MemSet(root_offsets, 0, MaxHeapTuplesPerPage * sizeof(OffsetNumber));
749 
750  maxoff = PageGetMaxOffsetNumber(page);
751  for (offnum = FirstOffsetNumber; offnum <= maxoff; offnum = OffsetNumberNext(offnum))
752  {
753  ItemId lp = PageGetItemId(page, offnum);
754  HeapTupleHeader htup;
755  OffsetNumber nextoffnum;
756  TransactionId priorXmax;
757 
758  /* skip unused and dead items */
759  if (!ItemIdIsUsed(lp) || ItemIdIsDead(lp))
760  continue;
761 
762  if (ItemIdIsNormal(lp))
763  {
764  htup = (HeapTupleHeader) PageGetItem(page, lp);
765 
766  /*
767  * Check if this tuple is part of a HOT-chain rooted at some other
768  * tuple. If so, skip it for now; we'll process it when we find
769  * its root.
770  */
771  if (HeapTupleHeaderIsHeapOnly(htup))
772  continue;
773 
774  /*
775  * This is either a plain tuple or the root of a HOT-chain.
776  * Remember it in the mapping.
777  */
778  root_offsets[offnum - 1] = offnum;
779 
780  /* If it's not the start of a HOT-chain, we're done with it */
781  if (!HeapTupleHeaderIsHotUpdated(htup))
782  continue;
783 
784  /* Set up to scan the HOT-chain */
785  nextoffnum = ItemPointerGetOffsetNumber(&htup->t_ctid);
786  priorXmax = HeapTupleHeaderGetUpdateXid(htup);
787  }
788  else
789  {
790  /* Must be a redirect item. We do not set its root_offsets entry */
792  /* Set up to scan the HOT-chain */
793  nextoffnum = ItemIdGetRedirect(lp);
794  priorXmax = InvalidTransactionId;
795  }
796 
797  /*
798  * Now follow the HOT-chain and collect other tuples in the chain.
799  *
800  * Note: Even though this is a nested loop, the complexity of the
801  * function is O(N) because a tuple in the page should be visited not
802  * more than twice, once in the outer loop and once in HOT-chain
803  * chases.
804  */
805  for (;;)
806  {
807  lp = PageGetItemId(page, nextoffnum);
808 
809  /* Check for broken chains */
810  if (!ItemIdIsNormal(lp))
811  break;
812 
813  htup = (HeapTupleHeader) PageGetItem(page, lp);
814 
815  if (TransactionIdIsValid(priorXmax) &&
816  !TransactionIdEquals(priorXmax, HeapTupleHeaderGetXmin(htup)))
817  break;
818 
819  /* Remember the root line pointer for this item */
820  root_offsets[nextoffnum - 1] = offnum;
821 
822  /* Advance to next chain member, if any */
823  if (!HeapTupleHeaderIsHotUpdated(htup))
824  break;
825 
826  nextoffnum = ItemPointerGetOffsetNumber(&htup->t_ctid);
827  priorXmax = HeapTupleHeaderGetUpdateXid(htup);
828  }
829  }
830 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
#define ItemIdIsRedirected(itemId)
Definition: itemid.h:105
#define TransactionIdEquals(id1, id2)
Definition: transam.h:43
uint32 TransactionId
Definition: c.h:397
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define ItemIdGetRedirect(itemId)
Definition: itemid.h:77
#define ItemIdIsUsed(itemId)
Definition: itemid.h:91
#define MaxHeapTuplesPerPage
Definition: htup_details.h:575
#define MemSet(start, val, len)
Definition: c.h:858
#define ItemIdIsDead(itemId)
Definition: itemid.h:112
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
uint16 OffsetNumber
Definition: off.h:24
#define HeapTupleHeaderIsHeapOnly(tup)
Definition: htup_details.h:502
ItemPointerData t_ctid
Definition: htup_details.h:150
#define FirstOffsetNumber
Definition: off.h:27
#define InvalidTransactionId
Definition: transam.h:31
#define HeapTupleHeaderIsHotUpdated(tup)
Definition: htup_details.h:485
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
#define Assert(condition)
Definition: c.h:676
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
#define HeapTupleHeaderGetXmin(tup)
Definition: htup_details.h:307
#define OffsetNumberNext(offsetNumber)
Definition: off.h:53
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define TransactionIdIsValid(xid)
Definition: transam.h:41
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
HeapTuple heap_getnext ( HeapScanDesc  scan,
ScanDirection  direction 
)

Definition at line 1810 of file heapam.c.

References HEAPDEBUG_1, HEAPDEBUG_2, HEAPDEBUG_3, heapgettup(), heapgettup_pagemode(), NULL, pgstat_count_heap_getnext, HeapScanDescData::rs_ctup, HeapScanDescData::rs_key, HeapScanDescData::rs_nkeys, HeapScanDescData::rs_pageatatime, HeapScanDescData::rs_rd, and HeapTupleData::t_data.

Referenced by AlterDomainNotNull(), AlterTableMoveAll(), AlterTableSpaceOptions(), ATRewriteTable(), boot_openrel(), check_db_file_conflict(), copy_heap_data(), CopyTo(), createdb(), DefineQueryRewrite(), do_autovacuum(), DropSetting(), DropTableSpace(), find_typed_table_dependencies(), get_database_list(), get_rel_oids(), get_subscription_list(), get_tables_to_cluster(), get_tablespace_name(), get_tablespace_oid(), GetAllTablesPublicationRelations(), getRelationsInNamespace(), gettype(), index_update_stats(), IndexBuildHeapRangeScan(), IndexCheckExclusion(), objectsInSchemaToOids(), pgrowlocks(), pgstat_collect_oids(), pgstat_heap(), ReindexMultipleTables(), RelationFindReplTupleSeq(), remove_dbtablespaces(), RemoveConversionById(), RemoveSubscriptionRel(), RenameTableSpace(), SeqNext(), systable_getnext(), ThereIsAtLeastOneRole(), vac_truncate_clog(), validate_index_heapscan(), validateCheckConstraint(), validateDomainConstraint(), and validateForeignKeyConstraint().

1811 {
1812  /* Note: no locking manipulations needed */
1813 
1814  HEAPDEBUG_1; /* heap_getnext( info ) */
1815 
1816  if (scan->rs_pageatatime)
1817  heapgettup_pagemode(scan, direction,
1818  scan->rs_nkeys, scan->rs_key);
1819  else
1820  heapgettup(scan, direction, scan->rs_nkeys, scan->rs_key);
1821 
1822  if (scan->rs_ctup.t_data == NULL)
1823  {
1824  HEAPDEBUG_2; /* heap_getnext returning EOS */
1825  return NULL;
1826  }
1827 
1828  /*
1829  * if we get here it means we have a new current scan tuple, so point to
1830  * the proper return buffer and return the tuple.
1831  */
1832  HEAPDEBUG_3; /* heap_getnext returning tuple */
1833 
1835 
1836  return &(scan->rs_ctup);
1837 }
#define HEAPDEBUG_2
Definition: heapam.c:1804
HeapTupleData rs_ctup
Definition: relscan.h:69
HeapTupleHeader t_data
Definition: htup.h:67
bool rs_pageatatime
Definition: relscan.h:54
#define HEAPDEBUG_1
Definition: heapam.c:1803
static void heapgettup(HeapScanDesc scan, ScanDirection dir, int nkeys, ScanKey key)
Definition: heapam.c:481
Relation rs_rd
Definition: relscan.h:48
#define NULL
Definition: c.h:229
#define HEAPDEBUG_3
Definition: heapam.c:1805
#define pgstat_count_heap_getnext(rel)
Definition: pgstat.h:1256
static void heapgettup_pagemode(HeapScanDesc scan, ScanDirection dir, int nkeys, ScanKey key)
Definition: heapam.c:785
ScanKey rs_key
Definition: relscan.h:51
bool heap_hot_search ( ItemPointer  tid,
Relation  relation,
Snapshot  snapshot,
bool all_dead 
)

Definition at line 2155 of file heapam.c.

References buffer, BUFFER_LOCK_SHARE, BUFFER_LOCK_UNLOCK, heap_hot_search_buffer(), ItemPointerGetBlockNumber, LockBuffer(), ReadBuffer(), ReleaseBuffer(), and result.

Referenced by _bt_check_unique(), and unique_key_recheck().

2157 {
2158  bool result;
2159  Buffer buffer;
2160  HeapTupleData heapTuple;
2161 
2162  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(tid));
2163  LockBuffer(buffer, BUFFER_LOCK_SHARE);
2164  result = heap_hot_search_buffer(tid, relation, buffer, snapshot,
2165  &heapTuple, all_dead, true);
2166  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
2167  ReleaseBuffer(buffer);
2168  return result;
2169 }
#define BUFFER_LOCK_UNLOCK
Definition: bufmgr.h:87
return result
Definition: formatting.c:1633
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
bool heap_hot_search_buffer(ItemPointer tid, Relation relation, Buffer buffer, Snapshot snapshot, HeapTuple heapTuple, bool *all_dead, bool first_call)
Definition: heapam.c:2013
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define BUFFER_LOCK_SHARE
Definition: bufmgr.h:88
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
int Buffer
Definition: buf.h:23
bool heap_hot_search_buffer ( ItemPointer  tid,
Relation  relation,
Buffer  buffer,
Snapshot  snapshot,
HeapTuple  heapTuple,
bool all_dead,
bool  first_call 
)

Definition at line 2013 of file heapam.c.

References Assert, BufferGetBlockNumber(), BufferGetPage, CheckForSerializableConflictOut(), HeapTupleHeaderGetUpdateXid, HeapTupleHeaderGetXmin, HeapTupleIsHeapOnly, HeapTupleIsHotUpdated, HeapTupleIsSurelyDead(), HeapTupleSatisfiesVisibility, InvalidTransactionId, ItemIdGetLength, ItemIdGetRedirect, ItemIdIsNormal, ItemIdIsRedirected, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, ItemPointerSet, ItemPointerSetOffsetNumber, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, PredicateLockTuple(), RecentGlobalXmin, RelationGetRelid, skip(), HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, TransactionIdEquals, and TransactionIdIsValid.

Referenced by bitgetpage(), heap_hot_search(), and index_fetch_heap().

2016 {
2017  Page dp = (Page) BufferGetPage(buffer);
2018  TransactionId prev_xmax = InvalidTransactionId;
2019  OffsetNumber offnum;
2020  bool at_chain_start;
2021  bool valid;
2022  bool skip;
2023 
2024  /* If this is not the first call, previous call returned a (live!) tuple */
2025  if (all_dead)
2026  *all_dead = first_call;
2027 
2029 
2031  offnum = ItemPointerGetOffsetNumber(tid);
2032  at_chain_start = first_call;
2033  skip = !first_call;
2034 
2035  heapTuple->t_self = *tid;
2036 
2037  /* Scan through possible multiple members of HOT-chain */
2038  for (;;)
2039  {
2040  ItemId lp;
2041 
2042  /* check for bogus TID */
2043  if (offnum < FirstOffsetNumber || offnum > PageGetMaxOffsetNumber(dp))
2044  break;
2045 
2046  lp = PageGetItemId(dp, offnum);
2047 
2048  /* check for unused, dead, or redirected items */
2049  if (!ItemIdIsNormal(lp))
2050  {
2051  /* We should only see a redirect at start of chain */
2052  if (ItemIdIsRedirected(lp) && at_chain_start)
2053  {
2054  /* Follow the redirect */
2055  offnum = ItemIdGetRedirect(lp);
2056  at_chain_start = false;
2057  continue;
2058  }
2059  /* else must be end of chain */
2060  break;
2061  }
2062 
2063  heapTuple->t_data = (HeapTupleHeader) PageGetItem(dp, lp);
2064  heapTuple->t_len = ItemIdGetLength(lp);
2065  heapTuple->t_tableOid = RelationGetRelid(relation);
2066  ItemPointerSetOffsetNumber(&heapTuple->t_self, offnum);
2067 
2068  /*
2069  * Shouldn't see a HEAP_ONLY tuple at chain start.
2070  */
2071  if (at_chain_start && HeapTupleIsHeapOnly(heapTuple))
2072  break;
2073 
2074  /*
2075  * The xmin should match the previous xmax value, else chain is
2076  * broken.
2077  */
2078  if (TransactionIdIsValid(prev_xmax) &&
2079  !TransactionIdEquals(prev_xmax,
2080  HeapTupleHeaderGetXmin(heapTuple->t_data)))
2081  break;
2082 
2083  /*
2084  * When first_call is true (and thus, skip is initially false) we'll
2085  * return the first tuple we find. But on later passes, heapTuple
2086  * will initially be pointing to the tuple we returned last time.
2087  * Returning it again would be incorrect (and would loop forever), so
2088  * we skip it and return the next match we find.
2089  */
2090  if (!skip)
2091  {
2092  /*
2093  * For the benefit of logical decoding, have t_self point at the
2094  * element of the HOT chain we're currently investigating instead
2095  * of the root tuple of the HOT chain. This is important because
2096  * the *Satisfies routine for historical mvcc snapshots needs the
2097  * correct tid to decide about the visibility in some cases.
2098  */
2099  ItemPointerSet(&(heapTuple->t_self), BufferGetBlockNumber(buffer), offnum);
2100 
2101  /* If it's visible per the snapshot, we must return it */
2102  valid = HeapTupleSatisfiesVisibility(heapTuple, snapshot, buffer);
2103  CheckForSerializableConflictOut(valid, relation, heapTuple,
2104  buffer, snapshot);
2105  /* reset to original, non-redirected, tid */
2106  heapTuple->t_self = *tid;
2107 
2108  if (valid)
2109  {
2110  ItemPointerSetOffsetNumber(tid, offnum);
2111  PredicateLockTuple(relation, heapTuple, snapshot);
2112  if (all_dead)
2113  *all_dead = false;
2114  return true;
2115  }
2116  }
2117  skip = false;
2118 
2119  /*
2120  * If we can't see it, maybe no one else can either. At caller
2121  * request, check whether all chain members are dead to all
2122  * transactions.
2123  */
2124  if (all_dead && *all_dead &&
2126  *all_dead = false;
2127 
2128  /*
2129  * Check to see if HOT chain continues past this tuple; if so fetch
2130  * the next offnum and loop around.
2131  */
2132  if (HeapTupleIsHotUpdated(heapTuple))
2133  {
2136  offnum = ItemPointerGetOffsetNumber(&heapTuple->t_data->t_ctid);
2137  at_chain_start = false;
2138  prev_xmax = HeapTupleHeaderGetUpdateXid(heapTuple->t_data);
2139  }
2140  else
2141  break; /* end of chain */
2142  }
2143 
2144  return false;
2145 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
static void skip(struct vars *v)
Definition: regc_lex.c:1109
#define ItemIdIsRedirected(itemId)
Definition: itemid.h:105
#define TransactionIdEquals(id1, id2)
Definition: transam.h:43
uint32 TransactionId
Definition: c.h:397
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define ItemIdGetRedirect(itemId)
Definition: itemid.h:77
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
void CheckForSerializableConflictOut(bool visible, Relation relation, HeapTuple tuple, Buffer buffer, Snapshot snapshot)
Definition: predicate.c:3943
bool HeapTupleIsSurelyDead(HeapTuple htup, TransactionId OldestXmin)
Definition: tqual.c:1409
#define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer)
Definition: tqual.h:45
uint16 OffsetNumber
Definition: off.h:24
HeapTupleHeader t_data
Definition: htup.h:67
#define HeapTupleIsHotUpdated(tuple)
Definition: htup_details.h:677
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
uint32 t_len
Definition: htup.h:64
TransactionId RecentGlobalXmin
Definition: snapmgr.c:166
#define InvalidTransactionId
Definition: transam.h:31
Oid t_tableOid
Definition: htup.h:66
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
#define HeapTupleIsHeapOnly(tuple)
Definition: htup_details.h:686
#define Assert(condition)
Definition: c.h:676
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
#define HeapTupleHeaderGetXmin(tup)
Definition: htup_details.h:307
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
void PredicateLockTuple(Relation relation, HeapTuple tuple, Snapshot snapshot)
Definition: predicate.c:2541
#define ItemPointerSetOffsetNumber(pointer, offsetNumber)
Definition: itemptr.h:126
BlockNumber BufferGetBlockNumber(Buffer buffer)
Definition: bufmgr.c:2605
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define TransactionIdIsValid(xid)
Definition: transam.h:41
#define RelationGetRelid(relation)
Definition: rel.h:416
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
#define ItemPointerSet(pointer, blockNumber, offNum)
Definition: itemptr.h:105
void heap_inplace_update ( Relation  relation,
HeapTuple  tuple 
)

Definition at line 6245 of file heapam.c.

References buffer, BUFFER_LOCK_EXCLUSIVE, BufferGetPage, CacheInvalidateHeapTuple(), elog, END_CRIT_SECTION, ereport, errcode(), errmsg(), ERROR, IsBootstrapProcessingMode, IsInParallelMode(), ItemIdGetLength, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), MarkBufferDirty(), NULL, xl_heap_inplace::offnum, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, PageSetLSN, ReadBuffer(), REGBUF_STANDARD, RelationNeedsWAL, SizeOfHeapInplace, START_CRIT_SECTION, HeapTupleData::t_data, HeapTupleHeaderData::t_hoff, HeapTupleData::t_len, HeapTupleData::t_self, UnlockReleaseBuffer(), XLOG_HEAP_INPLACE, XLogBeginInsert(), XLogInsert(), XLogRegisterBufData(), XLogRegisterBuffer(), and XLogRegisterData().

Referenced by create_toast_table(), index_set_state_flags(), index_update_stats(), vac_update_datfrozenxid(), and vac_update_relstats().

6246 {
6247  Buffer buffer;
6248  Page page;
6249  OffsetNumber offnum;
6250  ItemId lp = NULL;
6251  HeapTupleHeader htup;
6252  uint32 oldlen;
6253  uint32 newlen;
6254 
6255  /*
6256  * For now, parallel operations are required to be strictly read-only.
6257  * Unlike a regular update, this should never create a combo CID, so it
6258  * might be possible to relax this restriction, but not without more
6259  * thought and testing. It's not clear that it would be useful, anyway.
6260  */
6261  if (IsInParallelMode())
6262  ereport(ERROR,
6263  (errcode(ERRCODE_INVALID_TRANSACTION_STATE),
6264  errmsg("cannot update tuples during a parallel operation")));
6265 
6266  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(&(tuple->t_self)));
6268  page = (Page) BufferGetPage(buffer);
6269 
6270  offnum = ItemPointerGetOffsetNumber(&(tuple->t_self));
6271  if (PageGetMaxOffsetNumber(page) >= offnum)
6272  lp = PageGetItemId(page, offnum);
6273 
6274  if (PageGetMaxOffsetNumber(page) < offnum || !ItemIdIsNormal(lp))
6275  elog(ERROR, "invalid lp");
6276 
6277  htup = (HeapTupleHeader) PageGetItem(page, lp);
6278 
6279  oldlen = ItemIdGetLength(lp) - htup->t_hoff;
6280  newlen = tuple->t_len - tuple->t_data->t_hoff;
6281  if (oldlen != newlen || htup->t_hoff != tuple->t_data->t_hoff)
6282  elog(ERROR, "wrong tuple length");
6283 
6284  /* NO EREPORT(ERROR) from here till changes are logged */
6286 
6287  memcpy((char *) htup + htup->t_hoff,
6288  (char *) tuple->t_data + tuple->t_data->t_hoff,
6289  newlen);
6290 
6291  MarkBufferDirty(buffer);
6292 
6293  /* XLOG stuff */
6294  if (RelationNeedsWAL(relation))
6295  {
6296  xl_heap_inplace xlrec;
6297  XLogRecPtr recptr;
6298 
6299  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
6300 
6301  XLogBeginInsert();
6302  XLogRegisterData((char *) &xlrec, SizeOfHeapInplace);
6303 
6304  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6305  XLogRegisterBufData(0, (char *) htup + htup->t_hoff, newlen);
6306 
6307  /* inplace updates aren't decoded atm, don't log the origin */
6308 
6309  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_INPLACE);
6310 
6311  PageSetLSN(page, recptr);
6312  }
6313 
6314  END_CRIT_SECTION();
6315 
6316  UnlockReleaseBuffer(buffer);
6317 
6318  /*
6319  * Send out shared cache inval if necessary. Note that because we only
6320  * pass the new version of the tuple, this mustn't be used for any
6321  * operations that could change catcache lookup keys. But we aren't
6322  * bothering with index updates either, so that's true a fortiori.
6323  */
6325  CacheInvalidateHeapTuple(relation, tuple, NULL);
6326 }
void XLogRegisterBufData(uint8 block_id, char *data, int len)
Definition: xloginsert.c:361
void CacheInvalidateHeapTuple(Relation relation, HeapTuple tuple, HeapTuple newtuple)
Definition: inval.c:1094
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define SizeOfHeapInplace
Definition: heapam_xlog.h:286
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
int errcode(int sqlerrcode)
Definition: elog.c:575
#define BUFFER_LOCK_EXCLUSIVE
Definition: bufmgr.h:89
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
uint16 OffsetNumber
Definition: off.h:24
HeapTupleHeader t_data
Definition: htup.h:67
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
bool IsInParallelMode(void)
Definition: xact.c:913
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
uint32 t_len
Definition: htup.h:64
#define REGBUF_STANDARD
Definition: xloginsert.h:34
unsigned int uint32
Definition: c.h:268
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define ereport(elevel, rest)
Definition: elog.h:122
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
OffsetNumber offnum
Definition: heapam_xlog.h:282
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define XLOG_HEAP_INPLACE
Definition: heapam_xlog.h:39
#define RelationNeedsWAL(relation)
Definition: rel.h:505
#define IsBootstrapProcessingMode()
Definition: miscadmin.h:368
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define elog
Definition: elog.h:219
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
Oid heap_insert ( Relation  relation,
HeapTuple  tup,
CommandId  cid,
int  options,
BulkInsertState  bistate 
)

Definition at line 2412 of file heapam.c.

References Assert, buffer, BufferGetBlockNumber(), BufferGetPage, CacheInvalidateHeapTuple(), CheckForSerializableConflictIn(), END_CRIT_SECTION, FirstOffsetNumber, xl_heap_insert::flags, GetCurrentTransactionId(), heap_freetuple(), HEAP_INSERT_SKIP_WAL, HEAP_INSERT_SPECULATIVE, heap_prepare_insert(), HeapTupleGetOid, InvalidBuffer, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, log_heap_new_cid(), MarkBufferDirty(), xl_heap_insert::offnum, PageClearAllVisible, PageGetMaxOffsetNumber, PageIsAllVisible, PageSetLSN, pgstat_count_heap_insert(), REGBUF_KEEP_DATA, REGBUF_STANDARD, REGBUF_WILL_INIT, RelationGetBufferForTuple(), RelationIsAccessibleInLogicalDecoding, RelationIsLogicallyLogged, RelationNeedsWAL, RelationPutHeapTuple(), ReleaseBuffer(), SizeOfHeapHeader, SizeOfHeapInsert, SizeofHeapTupleHeader, START_CRIT_SECTION, HeapTupleData::t_data, xl_heap_header::t_hoff, HeapTupleHeaderData::t_hoff, xl_heap_header::t_infomask, HeapTupleHeaderData::t_infomask, xl_heap_header::t_infomask2, HeapTupleHeaderData::t_infomask2, HeapTupleData::t_len, HeapTupleData::t_self, UnlockReleaseBuffer(), visibilitymap_clear(), VISIBILITYMAP_VALID_BITS, XLH_INSERT_ALL_VISIBLE_CLEARED, XLH_INSERT_CONTAINS_NEW_TUPLE, XLH_INSERT_IS_SPECULATIVE, XLOG_HEAP_INIT_PAGE, XLOG_HEAP_INSERT, XLOG_INCLUDE_ORIGIN, XLogBeginInsert(), XLogInsert(), XLogRegisterBufData(), XLogRegisterBuffer(), XLogRegisterData(), and XLogSetRecordFlags().

Referenced by ATRewriteTable(), CopyFrom(), ExecInsert(), intorel_receive(), simple_heap_insert(), toast_save_datum(), and transientrel_receive().

2414 {
2416  HeapTuple heaptup;
2417  Buffer buffer;
2418  Buffer vmbuffer = InvalidBuffer;
2419  bool all_visible_cleared = false;
2420 
2421  /*
2422  * Fill in tuple header fields, assign an OID, and toast the tuple if
2423  * necessary.
2424  *
2425  * Note: below this point, heaptup is the data we actually intend to store
2426  * into the relation; tup is the caller's original untoasted data.
2427  */
2428  heaptup = heap_prepare_insert(relation, tup, xid, cid, options);
2429 
2430  /*
2431  * Find buffer to insert this tuple into. If the page is all visible,
2432  * this will also pin the requisite visibility map page.
2433  */
2434  buffer = RelationGetBufferForTuple(relation, heaptup->t_len,
2435  InvalidBuffer, options, bistate,
2436  &vmbuffer, NULL);
2437 
2438  /*
2439  * We're about to do the actual insert -- but check for conflict first, to
2440  * avoid possibly having to roll back work we've just done.
2441  *
2442  * This is safe without a recheck as long as there is no possibility of
2443  * another process scanning the page between this check and the insert
2444  * being visible to the scan (i.e., an exclusive buffer content lock is
2445  * continuously held from this point until the tuple insert is visible).
2446  *
2447  * For a heap insert, we only need to check for table-level SSI locks. Our
2448  * new tuple can't possibly conflict with existing tuple locks, and heap
2449  * page locks are only consolidated versions of tuple locks; they do not
2450  * lock "gaps" as index page locks do. So we don't need to specify a
2451  * buffer when making the call, which makes for a faster check.
2452  */
2454 
2455  /* NO EREPORT(ERROR) from here till changes are logged */
2457 
2458  RelationPutHeapTuple(relation, buffer, heaptup,
2459  (options & HEAP_INSERT_SPECULATIVE) != 0);
2460 
2461  if (PageIsAllVisible(BufferGetPage(buffer)))
2462  {
2463  all_visible_cleared = true;
2465  visibilitymap_clear(relation,
2466  ItemPointerGetBlockNumber(&(heaptup->t_self)),
2467  vmbuffer, VISIBILITYMAP_VALID_BITS);
2468  }
2469 
2470  /*
2471  * XXX Should we set PageSetPrunable on this page ?
2472  *
2473  * The inserting transaction may eventually abort thus making this tuple
2474  * DEAD and hence available for pruning. Though we don't want to optimize
2475  * for aborts, if no other tuple in this page is UPDATEd/DELETEd, the
2476  * aborted tuple will never be pruned until next vacuum is triggered.
2477  *
2478  * If you do add PageSetPrunable here, add it in heap_xlog_insert too.
2479  */
2480 
2481  MarkBufferDirty(buffer);
2482 
2483  /* XLOG stuff */
2484  if (!(options & HEAP_INSERT_SKIP_WAL) && RelationNeedsWAL(relation))
2485  {
2486  xl_heap_insert xlrec;
2487  xl_heap_header xlhdr;
2488  XLogRecPtr recptr;
2489  Page page = BufferGetPage(buffer);
2490  uint8 info = XLOG_HEAP_INSERT;
2491  int bufflags = 0;
2492 
2493  /*
2494  * If this is a catalog, we need to transmit combocids to properly
2495  * decode, so log that as well.
2496  */
2498  log_heap_new_cid(relation, heaptup);
2499 
2500  /*
2501  * If this is the single and first tuple on page, we can reinit the
2502  * page instead of restoring the whole thing. Set flag, and hide
2503  * buffer references from XLogInsert.
2504  */
2505  if (ItemPointerGetOffsetNumber(&(heaptup->t_self)) == FirstOffsetNumber &&
2507  {
2508  info |= XLOG_HEAP_INIT_PAGE;
2509  bufflags |= REGBUF_WILL_INIT;
2510  }
2511 
2512  xlrec.offnum = ItemPointerGetOffsetNumber(&heaptup->t_self);
2513  xlrec.flags = 0;
2514  if (all_visible_cleared)
2519 
2520  /*
2521  * For logical decoding, we need the tuple even if we're doing a full
2522  * page write, so make sure it's included even if we take a full-page
2523  * image. (XXX We could alternatively store a pointer into the FPW).
2524  */
2525  if (RelationIsLogicallyLogged(relation))
2526  {
2528  bufflags |= REGBUF_KEEP_DATA;
2529  }
2530 
2531  XLogBeginInsert();
2532  XLogRegisterData((char *) &xlrec, SizeOfHeapInsert);
2533 
2534  xlhdr.t_infomask2 = heaptup->t_data->t_infomask2;
2535  xlhdr.t_infomask = heaptup->t_data->t_infomask;
2536  xlhdr.t_hoff = heaptup->t_data->t_hoff;
2537 
2538  /*
2539  * note we mark xlhdr as belonging to buffer; if XLogInsert decides to
2540  * write the whole page to the xlog, we don't need to store
2541  * xl_heap_header in the xlog.
2542  */
2543  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD | bufflags);
2544  XLogRegisterBufData(0, (char *) &xlhdr, SizeOfHeapHeader);
2545  /* PG73FORMAT: write bitmap [+ padding] [+ oid] + data */
2547  (char *) heaptup->t_data + SizeofHeapTupleHeader,
2548  heaptup->t_len - SizeofHeapTupleHeader);
2549 
2550  /* filtering by origin on a row level is much more efficient */
2552 
2553  recptr = XLogInsert(RM_HEAP_ID, info);
2554 
2555  PageSetLSN(page, recptr);
2556  }
2557 
2558  END_CRIT_SECTION();
2559 
2560  UnlockReleaseBuffer(buffer);
2561  if (vmbuffer != InvalidBuffer)
2562  ReleaseBuffer(vmbuffer);
2563 
2564  /*
2565  * If tuple is cachable, mark it for invalidation from the caches in case
2566  * we abort. Note it is OK to do this after releasing the buffer, because
2567  * the heaptup data structure is all in local memory, not in the shared
2568  * buffer.
2569  */
2570  CacheInvalidateHeapTuple(relation, heaptup, NULL);
2571 
2572  /* Note: speculative insertions are counted too, even if aborted later */
2573  pgstat_count_heap_insert(relation, 1);
2574 
2575  /*
2576  * If heaptup is a private copy, release it. Don't forget to copy t_self
2577  * back to the caller's image, too.
2578  */
2579  if (heaptup != tup)
2580  {
2581  tup->t_self = heaptup->t_self;
2582  heap_freetuple(heaptup);
2583  }
2584 
2585  return HeapTupleGetOid(tup);
2586 }
void XLogRegisterBufData(uint8 block_id, char *data, int len)
Definition: xloginsert.c:361
#define SizeofHeapTupleHeader
Definition: htup_details.h:170
#define XLOG_HEAP_INSERT
Definition: heapam_xlog.h:32
static XLogRecPtr log_heap_new_cid(Relation relation, HeapTuple tup)
Definition: heapam.c:7744
void CacheInvalidateHeapTuple(Relation relation, HeapTuple tuple, HeapTuple newtuple)
Definition: inval.c:1094
static HeapTuple heap_prepare_insert(Relation relation, HeapTuple tup, TransactionId xid, CommandId cid, int options)
Definition: heapam.c:2596
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:397
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
unsigned char uint8
Definition: c.h:266
#define XLH_INSERT_IS_SPECULATIVE
Definition: heapam_xlog.h:68
#define InvalidBuffer
Definition: buf.h:25
#define REGBUF_WILL_INIT
Definition: xloginsert.h:32
uint16 t_infomask2
Definition: heapam_xlog.h:122
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
#define XLOG_INCLUDE_ORIGIN
Definition: xlog.h:191
#define HEAP_INSERT_SKIP_WAL
Definition: heapam.h:28
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define RelationIsLogicallyLogged(relation)
Definition: rel.h:575
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1373
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
void RelationPutHeapTuple(Relation relation, Buffer buffer, HeapTuple tuple, bool token)
Definition: hio.c:36
void CheckForSerializableConflictIn(Relation relation, HeapTuple tuple, Buffer buffer)
Definition: predicate.c:4324
#define XLOG_HEAP_INIT_PAGE
Definition: heapam_xlog.h:46
#define HEAP_INSERT_SPECULATIVE
Definition: heapam.h:31
#define VISIBILITYMAP_VALID_BITS
Definition: visibilitymap.h:28
HeapTupleHeader t_data
Definition: htup.h:67
bool visibilitymap_clear(Relation rel, BlockNumber heapBlk, Buffer buf, uint8 flags)
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
#define XLH_INSERT_CONTAINS_NEW_TUPLE
Definition: heapam_xlog.h:69
ItemPointerData t_self
Definition: htup.h:65
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:417
uint32 t_len
Definition: htup.h:64
#define FirstOffsetNumber
Definition: off.h:27
#define REGBUF_STANDARD
Definition: xloginsert.h:34
Buffer RelationGetBufferForTuple(Relation relation, Size len, Buffer otherBuffer, int options, BulkInsertState bistate, Buffer *vmbuffer, Buffer *vmbuffer_other)
Definition: hio.c:297
void XLogSetRecordFlags(uint8 flags)
Definition: xloginsert.c:397
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
#define RelationIsAccessibleInLogicalDecoding(relation)
Definition: rel.h:559
#define REGBUF_KEEP_DATA
Definition: xloginsert.h:37
#define PageClearAllVisible(page)
Definition: bufpage.h:385
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
uint16 t_infomask
Definition: heapam_xlog.h:123
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define RelationNeedsWAL(relation)
Definition: rel.h:505
#define SizeOfHeapInsert
Definition: heapam_xlog.h:138
#define XLH_INSERT_ALL_VISIBLE_CLEARED
Definition: heapam_xlog.h:66
BlockNumber BufferGetBlockNumber(Buffer buffer)
Definition: bufmgr.c:2605
void pgstat_count_heap_insert(Relation rel, PgStat_Counter n)
Definition: pgstat.c:1907
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
OffsetNumber offnum
Definition: heapam_xlog.h:132
#define SizeOfHeapHeader
Definition: heapam_xlog.h:127
Pointer Page
Definition: bufpage.h:74
HTSU_Result heap_lock_tuple ( Relation  relation,
HeapTuple  tuple,
CommandId  cid,
LockTupleMode  mode,
LockWaitPolicy  wait_policy,
bool  follow_update,
Buffer buffer,
HeapUpdateFailureData hufd 
)

Definition at line 4557 of file heapam.c.

References Assert, BUFFER_LOCK_EXCLUSIVE, BUFFER_LOCK_UNLOCK, BufferGetPage, BufferIsValid, HeapUpdateFailureData::cmax, compute_infobits(), compute_new_xmax_infomask(), ConditionalMultiXactIdWait(), ConditionalXactLockTableWait(), HeapUpdateFailureData::ctid, DoesMultiXactIdConflict(), elog, END_CRIT_SECTION, ereport, errcode(), errmsg(), ERROR, xl_heap_lock::flags, get_mxact_status_for_lock(), GetCurrentTransactionId(), GetMultiXactIdMembers(), heap_acquire_tuplock(), HEAP_KEYS_UPDATED, heap_lock_updated_tuple(), HEAP_XMAX_BITS, HEAP_XMAX_INVALID, HEAP_XMAX_IS_EXCL_LOCKED, HEAP_XMAX_IS_KEYSHR_LOCKED, HEAP_XMAX_IS_LOCKED_ONLY, HEAP_XMAX_IS_MULTI, HEAP_XMAX_IS_SHR_LOCKED, HeapTupleBeingUpdated, HeapTupleHeaderClearHotUpdated, HeapTupleHeaderGetCmax(), HeapTupleHeaderGetRawXmax, HeapTupleHeaderGetUpdateXid, HeapTupleHeaderIsOnlyLocked(), HeapTupleHeaderSetXmax, HeapTupleInvisible, HeapTupleMayBeUpdated, HeapTupleSatisfiesUpdate(), HeapTupleSelfUpdated, HeapTupleUpdated, HeapTupleWouldBlock, i, xl_heap_lock::infobits_set, InvalidBuffer, InvalidCommandId, ItemIdGetLength, ItemIdIsNormal, ItemPointerCopy, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), xl_heap_lock::locking_xid, LockTupleExclusive, LockTupleKeyShare, LockTupleNoKeyExclusive, LockTupleShare, LockWaitBlock, LockWaitError, LockWaitSkip, MarkBufferDirty(), MultiXactIdSetOldestMember(), MultiXactIdWait(), MultiXactStatusNoKeyUpdate, xl_heap_lock::offnum, PageGetItem, PageGetItemId, PageIsAllVisible, PageSetLSN, pfree(), ReadBuffer(), REGBUF_STANDARD, RelationGetRelationName, RelationGetRelid, RelationNeedsWAL, ReleaseBuffer(), result, SizeOfHeapLock, START_CRIT_SECTION, status(), HeapTupleHeaderData::t_ctid, HeapTupleData::t_data, HeapTupleHeaderData::t_infomask, HeapTupleHeaderData::t_infomask2, HeapTupleData::t_len, HeapTupleData::t_self, HeapTupleData::t_tableOid, TransactionIdEquals, TransactionIdIsCurrentTransactionId(), TUPLOCK_from_mxstatus, UnlockTupleTuplock, UpdateXmaxHintBits(), VISIBILITYMAP_ALL_FROZEN, visibilitymap_clear(), visibilitymap_pin(), XactLockTableWait(), XLH_LOCK_ALL_FROZEN_CLEARED, XLOG_HEAP_LOCK, XLogBeginInsert(), XLogInsert(), XLogRegisterBuffer(), XLogRegisterData(), XLTW_Lock, HeapUpdateFailureData::xmax, and xmax_infomask_changed().

Referenced by EvalPlanQualFetch(), ExecLockRows(), ExecOnConflictUpdate(), GetTupleForTrigger(), RelationFindReplTupleByIndex(), and RelationFindReplTupleSeq().

4561 {
4563  ItemPointer tid = &(tuple->t_self);
4564  ItemId lp;
4565  Page page;
4566  Buffer vmbuffer = InvalidBuffer;
4567  BlockNumber block;
4568  TransactionId xid,
4569  xmax;
4570  uint16 old_infomask,
4571  new_infomask,
4572  new_infomask2;
4573  bool first_time = true;
4574  bool have_tuple_lock = false;
4575  bool cleared_all_frozen = false;
4576 
4577  *buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(tid));
4578  block = ItemPointerGetBlockNumber(tid);
4579 
4580  /*
4581  * Before locking the buffer, pin the visibility map page if it appears to
4582  * be necessary. Since we haven't got the lock yet, someone else might be
4583  * in the middle of changing this, so we'll need to recheck after we have
4584  * the lock.
4585  */
4587  visibilitymap_pin(relation, block, &vmbuffer);
4588 
4590 
4591  page = BufferGetPage(*buffer);
4592  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
4593  Assert(ItemIdIsNormal(lp));
4594 
4595  tuple->t_data = (HeapTupleHeader) PageGetItem(page, lp);
4596  tuple->t_len = ItemIdGetLength(lp);
4597  tuple->t_tableOid = RelationGetRelid(relation);
4598 
4599 l3:
4600  result = HeapTupleSatisfiesUpdate(tuple, cid, *buffer);
4601 
4602  if (result == HeapTupleInvisible)
4603  {
4604  /*
4605  * This is possible, but only when locking a tuple for ON CONFLICT
4606  * UPDATE. We return this value here rather than throwing an error in
4607  * order to give that case the opportunity to throw a more specific
4608  * error.
4609  */
4610  result = HeapTupleInvisible;
4611  goto out_locked;
4612  }
4613  else if (result == HeapTupleBeingUpdated || result == HeapTupleUpdated)
4614  {
4615  TransactionId xwait;
4616  uint16 infomask;
4617  uint16 infomask2;
4618  bool require_sleep;
4619  ItemPointerData t_ctid;
4620 
4621  /* must copy state data before unlocking buffer */
4622  xwait = HeapTupleHeaderGetRawXmax(tuple->t_data);
4623  infomask = tuple->t_data->t_infomask;
4624  infomask2 = tuple->t_data->t_infomask2;
4625  ItemPointerCopy(&tuple->t_data->t_ctid, &t_ctid);
4626 
4628 
4629  /*
4630  * If any subtransaction of the current top transaction already holds
4631  * a lock as strong as or stronger than what we're requesting, we
4632  * effectively hold the desired lock already. We *must* succeed
4633  * without trying to take the tuple lock, else we will deadlock
4634  * against anyone wanting to acquire a stronger lock.
4635  *
4636  * Note we only do this the first time we loop on the HTSU result;
4637  * there is no point in testing in subsequent passes, because
4638  * evidently our own transaction cannot have acquired a new lock after
4639  * the first time we checked.
4640  */
4641  if (first_time)
4642  {
4643  first_time = false;
4644 
4645  if (infomask & HEAP_XMAX_IS_MULTI)
4646  {
4647  int i;
4648  int nmembers;
4649  MultiXactMember *members;
4650 
4651  /*
4652  * We don't need to allow old multixacts here; if that had
4653  * been the case, HeapTupleSatisfiesUpdate would have returned
4654  * MayBeUpdated and we wouldn't be here.
4655  */
4656  nmembers =
4657  GetMultiXactIdMembers(xwait, &members, false,
4658  HEAP_XMAX_IS_LOCKED_ONLY(infomask));
4659 
4660  for (i = 0; i < nmembers; i++)
4661  {
4662  /* only consider members of our own transaction */
4663  if (!TransactionIdIsCurrentTransactionId(members[i].xid))
4664  continue;
4665 
4666  if (TUPLOCK_from_mxstatus(members[i].status) >= mode)
4667  {
4668  pfree(members);
4669  result = HeapTupleMayBeUpdated;
4670  goto out_unlocked;
4671  }
4672  }
4673 
4674  if (members)
4675  pfree(members);
4676  }
4677  else if (TransactionIdIsCurrentTransactionId(xwait))
4678  {
4679  switch (mode)
4680  {
4681  case LockTupleKeyShare:
4682  Assert(HEAP_XMAX_IS_KEYSHR_LOCKED(infomask) ||
4683  HEAP_XMAX_IS_SHR_LOCKED(infomask) ||
4684  HEAP_XMAX_IS_EXCL_LOCKED(infomask));
4685  result = HeapTupleMayBeUpdated;
4686  goto out_unlocked;
4687  case LockTupleShare:
4688  if (HEAP_XMAX_IS_SHR_LOCKED(infomask) ||
4689  HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4690  {
4691  result = HeapTupleMayBeUpdated;
4692  goto out_unlocked;
4693  }
4694  break;
4696  if (HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4697  {
4698  result = HeapTupleMayBeUpdated;
4699  goto out_unlocked;
4700  }
4701  break;
4702  case LockTupleExclusive:
4703  if (HEAP_XMAX_IS_EXCL_LOCKED(infomask) &&
4704  infomask2 & HEAP_KEYS_UPDATED)
4705  {
4706  result = HeapTupleMayBeUpdated;
4707  goto out_unlocked;
4708  }
4709  break;
4710  }
4711  }
4712  }
4713 
4714  /*
4715  * Initially assume that we will have to wait for the locking
4716  * transaction(s) to finish. We check various cases below in which
4717  * this can be turned off.
4718  */
4719  require_sleep = true;
4720  if (mode == LockTupleKeyShare)
4721  {
4722  /*
4723  * If we're requesting KeyShare, and there's no update present, we
4724  * don't need to wait. Even if there is an update, we can still
4725  * continue if the key hasn't been modified.
4726  *
4727  * However, if there are updates, we need to walk the update chain
4728  * to mark future versions of the row as locked, too. That way,
4729  * if somebody deletes that future version, we're protected
4730  * against the key going away. This locking of future versions
4731  * could block momentarily, if a concurrent transaction is
4732  * deleting a key; or it could return a value to the effect that
4733  * the transaction deleting the key has already committed. So we
4734  * do this before re-locking the buffer; otherwise this would be
4735  * prone to deadlocks.
4736  *
4737  * Note that the TID we're locking was grabbed before we unlocked
4738  * the buffer. For it to change while we're not looking, the
4739  * other properties we're testing for below after re-locking the
4740  * buffer would also change, in which case we would restart this
4741  * loop above.
4742  */
4743  if (!(infomask2 & HEAP_KEYS_UPDATED))
4744  {
4745  bool updated;
4746 
4747  updated = !HEAP_XMAX_IS_LOCKED_ONLY(infomask);
4748 
4749  /*
4750  * If there are updates, follow the update chain; bail out if
4751  * that cannot be done.
4752  */
4753  if (follow_updates && updated)
4754  {
4755  HTSU_Result res;
4756 
4757  res = heap_lock_updated_tuple(relation, tuple, &t_ctid,
4759  mode);
4760  if (res != HeapTupleMayBeUpdated)
4761  {
4762  result = res;
4763  /* recovery code expects to have buffer lock held */
4765  goto failed;
4766  }
4767  }
4768 
4770 
4771  /*
4772  * Make sure it's still an appropriate lock, else start over.
4773  * Also, if it wasn't updated before we released the lock, but
4774  * is updated now, we start over too; the reason is that we
4775  * now need to follow the update chain to lock the new
4776  * versions.
4777  */
4778  if (!HeapTupleHeaderIsOnlyLocked(tuple->t_data) &&
4779  ((tuple->t_data->t_infomask2 & HEAP_KEYS_UPDATED) ||
4780  !updated))
4781  goto l3;
4782 
4783  /* Things look okay, so we can skip sleeping */
4784  require_sleep = false;
4785 
4786  /*
4787  * Note we allow Xmax to change here; other updaters/lockers
4788  * could have modified it before we grabbed the buffer lock.
4789  * However, this is not a problem, because with the recheck we
4790  * just did we ensure that they still don't conflict with the
4791  * lock we want.
4792  */
4793  }
4794  }
4795  else if (mode == LockTupleShare)
4796  {
4797  /*
4798  * If we're requesting Share, we can similarly avoid sleeping if
4799  * there's no update and no exclusive lock present.
4800  */
4801  if (HEAP_XMAX_IS_LOCKED_ONLY(infomask) &&
4802  !HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4803  {
4805 
4806  /*
4807  * Make sure it's still an appropriate lock, else start over.
4808  * See above about allowing xmax to change.
4809  */
4810  if (!HEAP_XMAX_IS_LOCKED_ONLY(tuple->t_data->t_infomask) ||
4812  goto l3;
4813  require_sleep = false;
4814  }
4815  }
4816  else if (mode == LockTupleNoKeyExclusive)
4817  {
4818  /*
4819  * If we're requesting NoKeyExclusive, we might also be able to
4820  * avoid sleeping; just ensure that there no conflicting lock
4821  * already acquired.
4822  */
4823  if (infomask & HEAP_XMAX_IS_MULTI)
4824  {
4825  if (!DoesMultiXactIdConflict((MultiXactId) xwait, infomask,
4826  mode))
4827  {
4828  /*
4829  * No conflict, but if the xmax changed under us in the
4830  * meantime, start over.
4831  */
4833  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4835  xwait))
4836  goto l3;
4837 
4838  /* otherwise, we're good */
4839  require_sleep = false;
4840  }
4841  }
4842  else if (HEAP_XMAX_IS_KEYSHR_LOCKED(infomask))
4843  {
4845 
4846  /* if the xmax changed in the meantime, start over */
4847  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4850  xwait))
4851  goto l3;
4852  /* otherwise, we're good */
4853  require_sleep = false;
4854  }
4855  }
4856 
4857  /*
4858  * As a check independent from those above, we can also avoid sleeping
4859  * if the current transaction is the sole locker of the tuple. Note
4860  * that the strength of the lock already held is irrelevant; this is
4861  * not about recording the lock in Xmax (which will be done regardless
4862  * of this optimization, below). Also, note that the cases where we
4863  * hold a lock stronger than we are requesting are already handled
4864  * above by not doing anything.
4865  *
4866  * Note we only deal with the non-multixact case here; MultiXactIdWait
4867  * is well equipped to deal with this situation on its own.
4868  */
4869  if (require_sleep && !(infomask & HEAP_XMAX_IS_MULTI) &&
4871  {
4872  /* ... but if the xmax changed in the meantime, start over */
4874  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4876  xwait))
4877  goto l3;
4879  require_sleep = false;
4880  }
4881 
4882  /*
4883  * Time to sleep on the other transaction/multixact, if necessary.
4884  *
4885  * If the other transaction is an update that's already committed,
4886  * then sleeping cannot possibly do any good: if we're required to
4887  * sleep, get out to raise an error instead.
4888  *
4889  * By here, we either have already acquired the buffer exclusive lock,
4890  * or we must wait for the locking transaction or multixact; so below
4891  * we ensure that we grab buffer lock after the sleep.
4892  */
4893  if (require_sleep && result == HeapTupleUpdated)
4894  {
4896  goto failed;
4897  }
4898  else if (require_sleep)
4899  {
4900  /*
4901  * Acquire tuple lock to establish our priority for the tuple, or
4902  * die trying. LockTuple will release us when we are next-in-line
4903  * for the tuple. We must do this even if we are share-locking.
4904  *
4905  * If we are forced to "start over" below, we keep the tuple lock;
4906  * this arranges that we stay at the head of the line while
4907  * rechecking tuple state.
4908  */
4909  if (!heap_acquire_tuplock(relation, tid, mode, wait_policy,
4910  &have_tuple_lock))
4911  {
4912  /*
4913  * This can only happen if wait_policy is Skip and the lock
4914  * couldn't be obtained.
4915  */
4916  result = HeapTupleWouldBlock;
4917  /* recovery code expects to have buffer lock held */
4919  goto failed;
4920  }
4921 
4922  if (infomask & HEAP_XMAX_IS_MULTI)
4923  {
4925 
4926  /* We only ever lock tuples, never update them */
4927  if (status >= MultiXactStatusNoKeyUpdate)
4928  elog(ERROR, "invalid lock mode in heap_lock_tuple");
4929 
4930  /* wait for multixact to end, or die trying */
4931  switch (wait_policy)
4932  {
4933  case LockWaitBlock:
4934  MultiXactIdWait((MultiXactId) xwait, status, infomask,
4935  relation, &tuple->t_self, XLTW_Lock, NULL);
4936  break;
4937  case LockWaitSkip:
4939  status, infomask, relation,
4940  NULL))
4941  {
4942  result = HeapTupleWouldBlock;
4943  /* recovery code expects to have buffer lock held */
4945  goto failed;
4946  }
4947  break;
4948  case LockWaitError:
4950  status, infomask, relation,
4951  NULL))
4952  ereport(ERROR,
4953  (errcode(ERRCODE_LOCK_NOT_AVAILABLE),
4954  errmsg("could not obtain lock on row in relation \"%s\"",
4955  RelationGetRelationName(relation))));
4956 
4957  break;
4958  }
4959 
4960  /*
4961  * Of course, the multixact might not be done here: if we're
4962  * requesting a light lock mode, other transactions with light
4963  * locks could still be alive, as well as locks owned by our
4964  * own xact or other subxacts of this backend. We need to
4965  * preserve the surviving MultiXact members. Note that it
4966  * isn't absolutely necessary in the latter case, but doing so
4967  * is simpler.
4968  */
4969  }
4970  else
4971  {
4972  /* wait for regular transaction to end, or die trying */
4973  switch (wait_policy)
4974  {
4975  case LockWaitBlock:
4976  XactLockTableWait(xwait, relation, &tuple->t_self,
4977  XLTW_Lock);
4978  break;
4979  case LockWaitSkip:
4980  if (!ConditionalXactLockTableWait(xwait))
4981  {
4982  result = HeapTupleWouldBlock;
4983  /* recovery code expects to have buffer lock held */
4985  goto failed;
4986  }
4987  break;
4988  case LockWaitError:
4989  if (!ConditionalXactLockTableWait(xwait))
4990  ereport(ERROR,
4991  (errcode(ERRCODE_LOCK_NOT_AVAILABLE),
4992  errmsg("could not obtain lock on row in relation \"%s\"",
4993  RelationGetRelationName(relation))));
4994  break;
4995  }
4996  }
4997 
4998  /* if there are updates, follow the update chain */
4999  if (follow_updates && !HEAP_XMAX_IS_LOCKED_ONLY(infomask))
5000  {
5001  HTSU_Result res;
5002 
5003  res = heap_lock_updated_tuple(relation, tuple, &t_ctid,
5005  mode);
5006  if (res != HeapTupleMayBeUpdated)
5007  {
5008  result = res;
5009  /* recovery code expects to have buffer lock held */
5011  goto failed;
5012  }
5013  }
5014 
5016 
5017  /*
5018  * xwait is done, but if xwait had just locked the tuple then some
5019  * other xact could update this tuple before we get to this point.
5020  * Check for xmax change, and start over if so.
5021  */
5022  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
5024  xwait))
5025  goto l3;
5026 
5027  if (!(infomask & HEAP_XMAX_IS_MULTI))
5028  {
5029  /*
5030  * Otherwise check if it committed or aborted. Note we cannot
5031  * be here if the tuple was only locked by somebody who didn't
5032  * conflict with us; that would have been handled above. So
5033  * that transaction must necessarily be gone by now. But
5034  * don't check for this in the multixact case, because some
5035  * locker transactions might still be running.
5036  */
5037  UpdateXmaxHintBits(tuple->t_data, *buffer, xwait);
5038  }
5039  }
5040 
5041  /* By here, we're certain that we hold buffer exclusive lock again */
5042 
5043  /*
5044  * We may lock if previous xmax aborted, or if it committed but only
5045  * locked the tuple without updating it; or if we didn't have to wait
5046  * at all for whatever reason.
5047  */
5048  if (!require_sleep ||
5049  (tuple->t_data->t_infomask & HEAP_XMAX_INVALID) ||
5052  result = HeapTupleMayBeUpdated;
5053  else
5054  result = HeapTupleUpdated;
5055  }
5056 
5057 failed:
5058  if (result != HeapTupleMayBeUpdated)
5059  {
5060  Assert(result == HeapTupleSelfUpdated || result == HeapTupleUpdated ||
5061  result == HeapTupleWouldBlock);
5062  Assert(!(tuple->t_data->t_infomask & HEAP_XMAX_INVALID));
5063  hufd->ctid = tuple->t_data->t_ctid;
5064  hufd->xmax = HeapTupleHeaderGetUpdateXid(tuple->t_data);
5065  if (result == HeapTupleSelfUpdated)
5066  hufd->cmax = HeapTupleHeaderGetCmax(tuple->t_data);
5067  else
5068  hufd->cmax = InvalidCommandId;
5069  goto out_locked;
5070  }
5071 
5072  /*
5073  * If we didn't pin the visibility map page and the page has become all
5074  * visible while we were busy locking the buffer, or during some
5075  * subsequent window during which we had it unlocked, we'll have to unlock
5076  * and re-lock, to avoid holding the buffer lock across I/O. That's a bit
5077  * unfortunate, especially since we'll now have to recheck whether the
5078  * tuple has been locked or updated under us, but hopefully it won't
5079  * happen very often.
5080  */
5081  if (vmbuffer == InvalidBuffer && PageIsAllVisible(page))
5082  {
5084  visibilitymap_pin(relation, block, &vmbuffer);
5086  goto l3;
5087  }
5088 
5089  xmax = HeapTupleHeaderGetRawXmax(tuple->t_data);
5090  old_infomask = tuple->t_data->t_infomask;
5091 
5092  /*
5093  * If this is the first possibly-multixact-able operation in the current
5094  * transaction, set my per-backend OldestMemberMXactId setting. We can be
5095  * certain that the transaction will never become a member of any older
5096  * MultiXactIds than that. (We have to do this even if we end up just
5097  * using our own TransactionId below, since some other backend could
5098  * incorporate our XID into a MultiXact immediately afterwards.)
5099  */
5101 
5102  /*
5103  * Compute the new xmax and infomask to store into the tuple. Note we do
5104  * not modify the tuple just yet, because that would leave it in the wrong
5105  * state if multixact.c elogs.
5106  */
5107  compute_new_xmax_infomask(xmax, old_infomask, tuple->t_data->t_infomask2,
5108  GetCurrentTransactionId(), mode, false,
5109  &xid, &new_infomask, &new_infomask2);
5110 
5112 
5113  /*
5114  * Store transaction information of xact locking the tuple.
5115  *
5116  * Note: Cmax is meaningless in this context, so don't set it; this avoids
5117  * possibly generating a useless combo CID. Moreover, if we're locking a
5118  * previously updated tuple, it's important to preserve the Cmax.
5119  *
5120  * Also reset the HOT UPDATE bit, but only if there's no update; otherwise
5121  * we would break the HOT chain.
5122  */
5123  tuple->t_data->t_infomask &= ~HEAP_XMAX_BITS;
5124  tuple->t_data->t_infomask2 &= ~HEAP_KEYS_UPDATED;
5125  tuple->t_data->t_infomask |= new_infomask;
5126  tuple->t_data->t_infomask2 |= new_infomask2;
5127  if (HEAP_XMAX_IS_LOCKED_ONLY(new_infomask))
5129  HeapTupleHeaderSetXmax(tuple->t_data, xid);
5130 
5131  /*
5132  * Make sure there is no forward chain link in t_ctid. Note that in the
5133  * cases where the tuple has been updated, we must not overwrite t_ctid,
5134  * because it was set by the updater. Moreover, if the tuple has been
5135  * updated, we need to follow the update chain to lock the new versions of
5136  * the tuple as well.
5137  */
5138  if (HEAP_XMAX_IS_LOCKED_ONLY(new_infomask))
5139  tuple->t_data->t_ctid = *tid;
5140 
5141  /* Clear only the all-frozen bit on visibility map if needed */
5142  if (PageIsAllVisible(page) &&
5143  visibilitymap_clear(relation, block, vmbuffer,
5145  cleared_all_frozen = true;
5146 
5147 
5149 
5150  /*
5151  * XLOG stuff. You might think that we don't need an XLOG record because
5152  * there is no state change worth restoring after a crash. You would be
5153  * wrong however: we have just written either a TransactionId or a
5154  * MultiXactId that may never have been seen on disk before, and we need
5155  * to make sure that there are XLOG entries covering those ID numbers.
5156  * Else the same IDs might be re-used after a crash, which would be
5157  * disastrous if this page made it to disk before the crash. Essentially
5158  * we have to enforce the WAL log-before-data rule even in this case.
5159  * (Also, in a PITR log-shipping or 2PC environment, we have to have XLOG
5160  * entries for everything anyway.)
5161  */
5162  if (RelationNeedsWAL(relation))
5163  {
5164  xl_heap_lock xlrec;
5165  XLogRecPtr recptr;
5166 
5167  XLogBeginInsert();
5169 
5170  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
5171  xlrec.locking_xid = xid;
5172  xlrec.infobits_set = compute_infobits(new_infomask,
5173  tuple->t_data->t_infomask2);
5174  xlrec.flags = cleared_all_frozen ? XLH_LOCK_ALL_FROZEN_CLEARED : 0;
5175  XLogRegisterData((char *) &xlrec, SizeOfHeapLock);
5176 
5177  /* we don't decode row locks atm, so no need to log the origin */
5178 
5179  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_LOCK);
5180 
5181  PageSetLSN(page, recptr);
5182  }
5183 
5184  END_CRIT_SECTION();
5185 
5186  result = HeapTupleMayBeUpdated;
5187 
5188 out_locked:
5190 
5191 out_unlocked:
5192  if (BufferIsValid(vmbuffer))
5193  ReleaseBuffer(vmbuffer);
5194 
5195  /*
5196  * Don't update the visibility map here. Locking a tuple doesn't change
5197  * visibility info.
5198  */
5199 
5200  /*
5201  * Now that we have successfully marked the tuple as locked, we can
5202  * release the lmgr tuple lock, if we had it.
5203  */
5204  if (have_tuple_lock)
5205  UnlockTupleTuplock(relation, tid, mode);
5206 
5207  return result;
5208 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
bool HeapTupleHeaderIsOnlyLocked(HeapTupleHeader tuple)
Definition: tqual.c:1585
MultiXactStatus
Definition: multixact.h:40
#define BUFFER_LOCK_UNLOCK
Definition: bufmgr.h:87
#define HEAP_XMAX_BITS
Definition: htup_details.h:256
OffsetNumber offnum
Definition: heapam_xlog.h:253
static uint8 compute_infobits(uint16 infomask, uint16 infomask2)
Definition: heapam.c:2968
#define TransactionIdEquals(id1, id2)
Definition: transam.h:43
#define PageIsAllVisible(page)
Definition: bufpage.h:381
#define XLH_LOCK_ALL_FROZEN_CLEARED
Definition: heapam_xlog.h:247
TransactionId locking_xid
Definition: heapam_xlog.h:252
uint32 TransactionId
Definition: c.h:397
HTSU_Result HeapTupleSatisfiesUpdate(HeapTuple htup, CommandId curcid, Buffer buffer)
Definition: tqual.c:460
bool TransactionIdIsCurrentTransactionId(TransactionId xid)
Definition: xact.c:773
void visibilitymap_pin(Relation rel, BlockNumber heapBlk, Buffer *buf)
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
HeapTupleHeaderData * HeapTupleHeader
Definition: htup.h:23
#define VISIBILITYMAP_ALL_FROZEN
Definition: visibilitymap.h:27
static bool xmax_infomask_changed(uint16 new_infomask, uint16 old_infomask)
Definition: heapam.c:2990
#define HeapTupleHeaderClearHotUpdated(tup)
Definition: htup_details.h:497
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define InvalidBuffer
Definition: buf.h:25
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
int errcode(int sqlerrcode)
Definition: elog.c:575
return result
Definition: formatting.c:1633
uint32 BlockNumber
Definition: block.h:31
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define BUFFER_LOCK_EXCLUSIVE
Definition: bufmgr.h:89
#define UnlockTupleTuplock(rel, tup, mode)
Definition: heapam.c:183
bool ConditionalXactLockTableWait(TransactionId xid)
Definition: lmgr.c:607
#define HEAP_XMAX_IS_SHR_LOCKED(infomask)
Definition: htup_details.h:248
void MultiXactIdSetOldestMember(void)
Definition: multixact.c:623
HeapTupleHeader t_data
Definition: htup.h:67
#define HeapTupleHeaderGetRawXmax(tup)
Definition: htup_details.h:369
unsigned short uint16
Definition: c.h:267
void pfree(void *pointer)
Definition: mcxt.c:950
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
bool visibilitymap_clear(Relation rel, BlockNumber heapBlk, Buffer buf, uint8 flags)
#define ERROR
Definition: elog.h:43
#define HEAP_XMAX_INVALID
Definition: htup_details.h:193
int8 infobits_set
Definition: heapam_xlog.h:254
ItemPointerData t_ctid
Definition: htup_details.h:150
ItemPointerData t_self
Definition: htup.h:65
static void MultiXactIdWait(MultiXactId multi, MultiXactStatus status, uint16 infomask, Relation rel, ItemPointer ctid, XLTW_Oper oper, int *remaining)
Definition: heapam.c:7160
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:417
uint32 t_len
Definition: htup.h:64
#define REGBUF_STANDARD
Definition: xloginsert.h:34
CommandId cmax
Definition: heapam.h:72
#define HeapTupleHeaderSetXmax(tup, xid)
Definition: htup_details.h:374
HTSU_Result
Definition: snapshot.h:119
#define RelationGetRelationName(relation)
Definition: rel.h:436
Oid t_tableOid
Definition: htup.h:66
#define SizeOfHeapLock
Definition: heapam_xlog.h:258
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define ereport(elevel, rest)
Definition: elog.h:122
static void compute_new_xmax_infomask(TransactionId xmax, uint16 old_infomask, uint16 old_infomask2, TransactionId add_to_xmax, LockTupleMode mode, bool is_update, TransactionId *result_xmax, uint16 *result_infomask, uint16 *result_infomask2)
Definition: heapam.c:5272
TransactionId xmax
Definition: heapam.h:71
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
#define InvalidCommandId
Definition: c.h:414
#define HEAP_XMAX_IS_LOCKED_ONLY(infomask)
Definition: htup_details.h:216
void LockBuffer(Buffer buffer, int mode)
Definition: bufmgr.c:3546
#define HEAP_KEYS_UPDATED
Definition: htup_details.h:264
#define HEAP_XMAX_IS_MULTI
Definition: htup_details.h:194
static void UpdateXmaxHintBits(HeapTupleHeader tuple, Buffer buffer, TransactionId xid)
Definition: heapam.c:2313
static bool heap_acquire_tuplock(Relation relation, ItemPointer tid, LockTupleMode mode, LockWaitPolicy wait_policy, bool *have_tuple_lock)
Definition: heapam.c:5223
TransactionId MultiXactId
Definition: c.h:407
void XactLockTableWait(TransactionId xid, Relation rel, ItemPointer ctid, XLTW_Oper oper)
Definition: lmgr.c:554
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
Definition: lmgr.h:29
CommandId HeapTupleHeaderGetCmax(HeapTupleHeader tup)
Definition: combocid.c:119
static bool DoesMultiXactIdConflict(MultiXactId multi, uint16 infomask, LockTupleMode lockmode)
Definition: heapam.c:6993
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
Buffer ReadBuffer(Relation reln, BlockNumber blockNum)
Definition: bufmgr.c:594
#define BufferIsValid(bufnum)
Definition: bufmgr.h:114
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
#define RelationNeedsWAL(relation)
Definition: rel.h:505
#define TUPLOCK_from_mxstatus(status)
Definition: heapam.c:203
static HTSU_Result heap_lock_updated_tuple(Relation rel, HeapTuple tuple, ItemPointer ctid, TransactionId xid, LockTupleMode mode)
Definition: heapam.c:5973
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define XLOG_HEAP_LOCK
Definition: heapam_xlog.h:38
int i
static MultiXactStatus get_mxact_status_for_lock(LockTupleMode mode, bool is_update)
Definition: heapam.c:4504
ItemPointerData ctid
Definition: heapam.h:70
#define HEAP_XMAX_IS_EXCL_LOCKED(infomask)
Definition: htup_details.h:250
int GetMultiXactIdMembers(MultiXactId multi, MultiXactMember **members, bool from_pgupgrade, bool onlyLock)
Definition: multixact.c:1202
#define elog
Definition: elog.h:219
#define ItemPointerGetBlockNumber(pointer)
Definition: itemptr.h:76
#define HEAP_XMAX_IS_KEYSHR_LOCKED(infomask)
Definition: htup_details.h:252
static void static void status(const char *fmt,...) pg_attribute_printf(1
Definition: pg_regress.c:224
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
#define RelationGetRelid(relation)
Definition: rel.h:416
static bool ConditionalMultiXactIdWait(MultiXactId multi, MultiXactStatus status, uint16 infomask, Relation rel, int *remaining)
Definition: heapam.c:7182
#define PageGetItem(page, itemId)
Definition: bufpage.h:336
Pointer Page
Definition: bufpage.h:74
#define ItemPointerCopy(fromPointer, toPointer)
Definition: itemptr.h:139
void heap_multi_insert ( Relation  relation,
HeapTuple tuples,
int  ntuples,
CommandId  cid,
int  options,
BulkInsertState  bistate 
)

Definition at line 2674 of file heapam.c.

References Assert, buffer, BufferGetBlockNumber(), BufferGetPage, CacheInvalidateHeapTuple(), CHECK_FOR_INTERRUPTS, CheckForSerializableConflictIn(), xl_multi_insert_tuple::datalen, END_CRIT_SECTION, FirstOffsetNumber, xl_heap_multi_insert::flags, GetCurrentTransactionId(), HEAP_DEFAULT_FILLFACTOR, HEAP_INSERT_SKIP_WAL, heap_prepare_insert(), i, init(), InvalidBuffer, IsCatalogRelation(), ItemPointerGetOffsetNumber, log_heap_new_cid(), MarkBufferDirty(), MAXALIGN, xl_heap_multi_insert::ntuples, NULL, xl_heap_multi_insert::offsets, PageClearAllVisible, PageGetHeapFreeSpace(), PageGetMaxOffsetNumber, PageIsAllVisible, PageSetLSN, palloc(), pgstat_count_heap_insert(), REGBUF_KEEP_DATA, REGBUF_STANDARD, REGBUF_WILL_INIT, RelationGetBufferForTuple(), RelationGetTargetPageFreeSpace, RelationIsAccessibleInLogicalDecoding, RelationIsLogicallyLogged, RelationNeedsWAL, RelationPutHeapTuple(), ReleaseBuffer(), SHORTALIGN, SizeOfHeapMultiInsert, SizeofHeapTupleHeader, SizeOfMultiInsertTuple, START_CRIT_SECTION, HeapTupleData::t_data, HeapTupleHeaderData::t_hoff, xl_multi_insert_tuple::t_hoff, HeapTupleHeaderData::t_infomask, xl_multi_insert_tuple::t_infomask, HeapTupleHeaderData::t_infomask2, xl_multi_insert_tuple::t_infomask2, HeapTupleData::t_len, HeapTupleData::t_self, UnlockReleaseBuffer(), visibilitymap_clear(), VISIBILITYMAP_VALID_BITS, XLH_INSERT_ALL_VISIBLE_CLEARED, XLH_INSERT_CONTAINS_NEW_TUPLE, XLH_INSERT_LAST_IN_MULTI, XLOG_HEAP2_MULTI_INSERT, XLOG_HEAP_INIT_PAGE, XLOG_INCLUDE_ORIGIN, XLogBeginInsert(), XLogInsert(), XLogRegisterBufData(), XLogRegisterBuffer(), XLogRegisterData(), and XLogSetRecordFlags().

Referenced by CopyFromInsertBatch().

2676 {
2678  HeapTuple *heaptuples;
2679  int i;
2680  int ndone;
2681  char *scratch = NULL;
2682  Page page;
2683  bool needwal;
2684  Size saveFreeSpace;
2685  bool need_tuple_data = RelationIsLogicallyLogged(relation);
2686  bool need_cids = RelationIsAccessibleInLogicalDecoding(relation);
2687 
2688  needwal = !(options & HEAP_INSERT_SKIP_WAL) && RelationNeedsWAL(relation);
2689  saveFreeSpace = RelationGetTargetPageFreeSpace(relation,
2691 
2692  /* Toast and set header data in all the tuples */
2693  heaptuples = palloc(ntuples * sizeof(HeapTuple));
2694  for (i = 0; i < ntuples; i++)
2695  heaptuples[i] = heap_prepare_insert(relation, tuples[i],
2696  xid, cid, options);
2697 
2698  /*
2699  * Allocate some memory to use for constructing the WAL record. Using
2700  * palloc() within a critical section is not safe, so we allocate this
2701  * beforehand.
2702  */
2703  if (needwal)
2704  scratch = palloc(BLCKSZ);
2705 
2706  /*
2707  * We're about to do the actual inserts -- but check for conflict first,
2708  * to minimize the possibility of having to roll back work we've just
2709  * done.
2710  *
2711  * A check here does not definitively prevent a serialization anomaly;
2712  * that check MUST be done at least past the point of acquiring an
2713  * exclusive buffer content lock on every buffer that will be affected,
2714  * and MAY be done after all inserts are reflected in the buffers and
2715  * those locks are released; otherwise there race condition. Since
2716  * multiple buffers can be locked and unlocked in the loop below, and it
2717  * would not be feasible to identify and lock all of those buffers before
2718  * the loop, we must do a final check at the end.
2719  *
2720  * The check here could be omitted with no loss of correctness; it is
2721  * present strictly as an optimization.
2722  *
2723  * For heap inserts, we only need to check for table-level SSI locks. Our
2724  * new tuples can't possibly conflict with existing tuple locks, and heap
2725  * page locks are only consolidated versions of tuple locks; they do not
2726  * lock "gaps" as index page locks do. So we don't need to specify a
2727  * buffer when making the call, which makes for a faster check.
2728  */
2730 
2731  ndone = 0;
2732  while (ndone < ntuples)
2733  {
2734  Buffer buffer;
2735  Buffer vmbuffer = InvalidBuffer;
2736  bool all_visible_cleared = false;
2737  int nthispage;
2738 
2740 
2741  /*
2742  * Find buffer where at least the next tuple will fit. If the page is
2743  * all-visible, this will also pin the requisite visibility map page.
2744  */
2745  buffer = RelationGetBufferForTuple(relation, heaptuples[ndone]->t_len,
2746  InvalidBuffer, options, bistate,
2747  &vmbuffer, NULL);
2748  page = BufferGetPage(buffer);
2749 
2750  /* NO EREPORT(ERROR) from here till changes are logged */
2752 
2753  /*
2754  * RelationGetBufferForTuple has ensured that the first tuple fits.
2755  * Put that on the page, and then as many other tuples as fit.
2756  */
2757  RelationPutHeapTuple(relation, buffer, heaptuples[ndone], false);
2758  for (nthispage = 1; ndone + nthispage < ntuples; nthispage++)
2759  {
2760  HeapTuple heaptup = heaptuples[ndone + nthispage];
2761 
2762  if (PageGetHeapFreeSpace(page) < MAXALIGN(heaptup->t_len) + saveFreeSpace)
2763  break;
2764 
2765  RelationPutHeapTuple(relation, buffer, heaptup, false);
2766 
2767  /*
2768  * We don't use heap_multi_insert for catalog tuples yet, but
2769  * better be prepared...
2770  */
2771  if (needwal && need_cids)
2772  log_heap_new_cid(relation, heaptup);
2773  }
2774 
2775  if (PageIsAllVisible(page))
2776  {
2777  all_visible_cleared = true;
2778  PageClearAllVisible(page);
2779  visibilitymap_clear(relation,
2780  BufferGetBlockNumber(buffer),
2781  vmbuffer, VISIBILITYMAP_VALID_BITS);
2782  }
2783 
2784  /*
2785  * XXX Should we set PageSetPrunable on this page ? See heap_insert()
2786  */
2787 
2788  MarkBufferDirty(buffer);
2789 
2790  /* XLOG stuff */
2791  if (needwal)
2792  {
2793  XLogRecPtr recptr;
2794  xl_heap_multi_insert *xlrec;
2796  char *tupledata;
2797  int totaldatalen;
2798  char *scratchptr = scratch;
2799  bool init;
2800  int bufflags = 0;
2801 
2802  /*
2803  * If the page was previously empty, we can reinit the page
2804  * instead of restoring the whole thing.
2805  */
2806  init = (ItemPointerGetOffsetNumber(&(heaptuples[ndone]->t_self)) == FirstOffsetNumber &&
2807  PageGetMaxOffsetNumber(page) == FirstOffsetNumber + nthispage - 1);
2808 
2809  /* allocate xl_heap_multi_insert struct from the scratch area */
2810  xlrec = (xl_heap_multi_insert *) scratchptr;
2811  scratchptr += SizeOfHeapMultiInsert;
2812 
2813  /*
2814  * Allocate offsets array. Unless we're reinitializing the page,
2815  * in that case the tuples are stored in order starting at
2816  * FirstOffsetNumber and we don't need to store the offsets
2817  * explicitly.
2818  */
2819  if (!init)
2820  scratchptr += nthispage * sizeof(OffsetNumber);
2821 
2822  /* the rest of the scratch space is used for tuple data */
2823  tupledata = scratchptr;
2824 
2825  xlrec->flags = all_visible_cleared ? XLH_INSERT_ALL_VISIBLE_CLEARED : 0;
2826  xlrec->ntuples = nthispage;
2827 
2828  /*
2829  * Write out an xl_multi_insert_tuple and the tuple data itself
2830  * for each tuple.
2831  */
2832  for (i = 0; i < nthispage; i++)
2833  {
2834  HeapTuple heaptup = heaptuples[ndone + i];
2835  xl_multi_insert_tuple *tuphdr;
2836  int datalen;
2837 
2838  if (!init)
2839  xlrec->offsets[i] = ItemPointerGetOffsetNumber(&heaptup->t_self);
2840  /* xl_multi_insert_tuple needs two-byte alignment. */
2841  tuphdr = (xl_multi_insert_tuple *) SHORTALIGN(scratchptr);
2842  scratchptr = ((char *) tuphdr) + SizeOfMultiInsertTuple;
2843 
2844  tuphdr->t_infomask2 = heaptup->t_data->t_infomask2;
2845  tuphdr->t_infomask = heaptup->t_data->t_infomask;
2846  tuphdr->t_hoff = heaptup->t_data->t_hoff;
2847 
2848  /* write bitmap [+ padding] [+ oid] + data */
2849  datalen = heaptup->t_len - SizeofHeapTupleHeader;
2850  memcpy(scratchptr,
2851  (char *) heaptup->t_data + SizeofHeapTupleHeader,
2852  datalen);
2853  tuphdr->datalen = datalen;
2854  scratchptr += datalen;
2855  }
2856  totaldatalen = scratchptr - tupledata;
2857  Assert((scratchptr - scratch) < BLCKSZ);
2858 
2859  if (need_tuple_data)
2861 
2862  /*
2863  * Signal that this is the last xl_heap_multi_insert record
2864  * emitted by this call to heap_multi_insert(). Needed for logical
2865  * decoding so it knows when to cleanup temporary data.
2866  */
2867  if (ndone + nthispage == ntuples)
2868  xlrec->flags |= XLH_INSERT_LAST_IN_MULTI;
2869 
2870  if (init)
2871  {
2872  info |= XLOG_HEAP_INIT_PAGE;
2873  bufflags |= REGBUF_WILL_INIT;
2874  }
2875 
2876  /*
2877  * If we're doing logical decoding, include the new tuple data
2878  * even if we take a full-page image of the page.
2879  */
2880  if (need_tuple_data)
2881  bufflags |= REGBUF_KEEP_DATA;
2882 
2883  XLogBeginInsert();
2884  XLogRegisterData((char *) xlrec, tupledata - scratch);
2885  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD | bufflags);
2886 
2887  XLogRegisterBufData(0, tupledata, totaldatalen);
2888 
2889  /* filtering by origin on a row level is much more efficient */
2891 
2892  recptr = XLogInsert(RM_HEAP2_ID, info);
2893 
2894  PageSetLSN(page, recptr);
2895  }
2896 
2897  END_CRIT_SECTION();
2898 
2899  UnlockReleaseBuffer(buffer);
2900  if (vmbuffer != InvalidBuffer)
2901  ReleaseBuffer(vmbuffer);
2902 
2903  ndone += nthispage;
2904  }
2905 
2906  /*
2907  * We're done with the actual inserts. Check for conflicts again, to
2908  * ensure that all rw-conflicts in to these inserts are detected. Without
2909  * this final check, a sequential scan of the heap may have locked the
2910  * table after the "before" check, missing one opportunity to detect the
2911  * conflict, and then scanned the table before the new tuples were there,
2912  * missing the other chance to detect the conflict.
2913  *
2914  * For heap inserts, we only need to check for table-level SSI locks. Our
2915  * new tuples can't possibly conflict with existing tuple locks, and heap
2916  * page locks are only consolidated versions of tuple locks; they do not
2917  * lock "gaps" as index page locks do. So we don't need to specify a
2918  * buffer when making the call.
2919  */
2921 
2922  /*
2923  * If tuples are cachable, mark them for invalidation from the caches in
2924  * case we abort. Note it is OK to do this after releasing the buffer,
2925  * because the heaptuples data structure is all in local memory, not in
2926  * the shared buffer.
2927  */
2928  if (IsCatalogRelation(relation))
2929  {
2930  for (i = 0; i < ntuples; i++)
2931  CacheInvalidateHeapTuple(relation, heaptuples[i], NULL);
2932  }
2933 
2934  /*
2935  * Copy t_self fields back to the caller's original tuples. This does
2936  * nothing for untoasted tuples (tuples[i] == heaptuples[i)], but it's
2937  * probably faster to always copy than check.
2938  */
2939  for (i = 0; i < ntuples; i++)
2940  tuples[i]->t_self = heaptuples[i]->t_self;
2941 
2942  pgstat_count_heap_insert(relation, ntuples);
2943 }
void XLogRegisterBufData(uint8 block_id, char *data, int len)
Definition: xloginsert.c:361
#define SizeofHeapTupleHeader
Definition: htup_details.h:170
bool IsCatalogRelation(Relation relation)
Definition: catalog.c:92
static XLogRecPtr log_heap_new_cid(Relation relation, HeapTuple tup)
Definition: heapam.c:7744
void CacheInvalidateHeapTuple(Relation relation, HeapTuple tuple, HeapTuple newtuple)
Definition: inval.c:1094
static HeapTuple heap_prepare_insert(Relation relation, HeapTuple tup, TransactionId xid, CommandId cid, int options)
Definition: heapam.c:2596
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:397
OffsetNumber offsets[FLEXIBLE_ARRAY_MEMBER]
Definition: heapam_xlog.h:155
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
void XLogRegisterBuffer(uint8 block_id, Buffer buffer, uint8 flags)
Definition: xloginsert.c:213
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
unsigned char uint8
Definition: c.h:266
#define InvalidBuffer
Definition: buf.h:25
#define SizeOfHeapMultiInsert
Definition: heapam_xlog.h:158
#define REGBUF_WILL_INIT
Definition: xloginsert.h:32
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
#define XLOG_INCLUDE_ORIGIN
Definition: xlog.h:191
#define HEAP_INSERT_SKIP_WAL
Definition: heapam.h:28
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
#define RelationIsLogicallyLogged(relation)
Definition: rel.h:575
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
void RelationPutHeapTuple(Relation relation, Buffer buffer, HeapTuple tuple, bool token)
Definition: hio.c:36
void CheckForSerializableConflictIn(Relation relation, HeapTuple tuple, Buffer buffer)
Definition: predicate.c:4324
#define XLOG_HEAP_INIT_PAGE
Definition: heapam_xlog.h:46
#define XLOG_HEAP2_MULTI_INSERT
Definition: heapam_xlog.h:58
uint16 OffsetNumber
Definition: off.h:24
#define VISIBILITYMAP_VALID_BITS
Definition: visibilitymap.h:28
HeapTupleHeader t_data
Definition: htup.h:67
bool visibilitymap_clear(Relation rel, BlockNumber heapBlk, Buffer buf, uint8 flags)
void UnlockReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3332
Size PageGetHeapFreeSpace(Page page)
Definition: bufpage.c:666
#define XLH_INSERT_CONTAINS_NEW_TUPLE
Definition: heapam_xlog.h:69
ItemPointerData t_self
Definition: htup.h:65
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:417
uint32 t_len
Definition: htup.h:64
#define FirstOffsetNumber
Definition: off.h:27
#define REGBUF_STANDARD
Definition: xloginsert.h:34
Buffer RelationGetBufferForTuple(Relation relation, Size len, Buffer otherBuffer, int options, BulkInsertState bistate, Buffer *vmbuffer, Buffer *vmbuffer_other)
Definition: hio.c:297
void XLogSetRecordFlags(uint8 flags)
Definition: xloginsert.c:397
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define RelationGetTargetPageFreeSpace(relation, defaultff)
Definition: rel.h:307
#define XLH_INSERT_LAST_IN_MULTI
Definition: heapam_xlog.h:67
void XLogRegisterData(char *data, int len)
Definition: xloginsert.c:323
XLogRecPtr XLogInsert(RmgrId rmid, uint8 info)
Definition: xloginsert.c:415
#define RelationIsAccessibleInLogicalDecoding(relation)
Definition: rel.h:559
#define REGBUF_KEEP_DATA
Definition: xloginsert.h:37
#define PageClearAllVisible(page)
Definition: bufpage.h:385
#define NULL
Definition: c.h:229
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:676
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
size_t Size
Definition: c.h:356
#define MAXALIGN(LEN)
Definition: c.h:588
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
static void init(bool is_no_vacuum)
Definition: pgbench.c:2571
#define RelationNeedsWAL(relation)
Definition: rel.h:505
#define XLH_INSERT_ALL_VISIBLE_CLEARED
Definition: heapam_xlog.h:66
BlockNumber BufferGetBlockNumber(Buffer buffer)
Definition: bufmgr.c:2605
void pgstat_count_heap_insert(Relation rel, PgStat_Counter n)
Definition: pgstat.c:1907
void * palloc(Size size)
Definition: mcxt.c:849
int i
#define CHECK_FOR_INTERRUPTS()
Definition: miscadmin.h:98
#define HEAP_DEFAULT_FILLFACTOR
Definition: rel.h:286
#define SHORTALIGN(LEN)
Definition: c.h:584
void XLogBeginInsert(void)
Definition: xloginsert.c:120
#define PageSetLSN(page, lsn)
Definition: bufpage.h:364
int Buffer
Definition: buf.h:23
Pointer Page
Definition: bufpage.h:74
#define SizeOfMultiInsertTuple
Definition: heapam_xlog.h:169
Relation heap_open ( Oid  relationId,
LOCKMODE  lockmode 
)

Definition at line 1290 of file heapam.c.

References ereport, errcode(), errmsg(), ERROR, RelationData::rd_rel, relation_open(), RelationGetRelationName, RELKIND_COMPOSITE_TYPE, and RELKIND_INDEX.

Referenced by acquire_inherited_sample_rows(), AcquireRewriteLocks(), AddEnumLabel(), AddNewAttributeTuples(), AddRoleMems(), AfterTriggerSetState(), AggregateCreate(), AlterCollation(), AlterConstraintNamespaces(), AlterDatabase(), AlterDatabaseOwner(), AlterDomainAddConstraint(), AlterDomainDefault(), AlterDomainDropConstraint(), AlterDomainNotNull(), AlterDomainValidateConstraint(), AlterEventTrigger(), AlterEventTriggerOwner(), AlterEventTriggerOwner_oid(), AlterExtensionNamespace(), AlterForeignDataWrapper(), AlterForeignDataWrapperOwner(), AlterForeignDataWrapperOwner_oid(), AlterForeignServer(), AlterForeignServerOwner(), AlterForeignServerOwner_oid(), AlterFunction(), AlterObjectNamespace_oid(), AlterOperator(), AlterPolicy(), AlterPublication(), AlterPublicationOwner(), AlterPublicationOwner_oid(), AlterPublicationTables(), AlterRole(), AlterSchemaOwner(), AlterSchemaOwner_oid(), AlterSeqNamespaces(), AlterSequence(), AlterSetting(), AlterSubscription(), AlterSubscriptionOwner(), AlterSubscriptionOwner_oid(), AlterTableMoveAll(), AlterTableNamespaceInternal(), AlterTableSpaceOptions(), AlterTSConfiguration(), AlterTSDictionary(), AlterTypeNamespaceInternal(), AlterTypeOwner(), AlterTypeOwner_oid(), AlterTypeOwnerInternal(), AlterUserMapping(), AppendAttributeTuples(), ApplyExtensionUpdates(), AssignTypeArrayOid(), ATAddCheckConstraint(), ATAddForeignKeyConstraint(), ATExecAddColumn(), ATExecAddIdentity(), ATExecAddOf(), ATExecAlterColumnGenericOptions(), ATExecAlterColumnType(), ATExecAlterConstraint(), ATExecAttachPartition(), ATExecChangeOwner(), ATExecDetachPartition(), ATExecDisableRowSecurity(), ATExecDropColumn(), ATExecDropConstraint(), ATExecDropIdentity(), ATExecDropNotNull(), ATExecDropOf(), ATExecEnableRowSecurity(), ATExecForceNoForceRowSecurity(), ATExecGenericOptions(), ATExecSetIdentity(), ATExecSetNotNull(), ATExecSetOptions(), ATExecSetRelOptions(), ATExecSetStatistics(), ATExecSetStorage(), ATExecSetTableSpace(), ATExecValidateConstraint(), ATPrepChangePersistence(), ATRewriteTable(), ATRewriteTables(), AttrDefaultFetch(), boot_openrel(), brin_desummarize_range(), brin_summarize_range(), bringetbitmap(), brinvacuumcleanup(), bt_index_check_internal(), build_indices(), build_physical_tlist(), BuildRelationExtStatistics(), CatalogCacheInitializeCache(), change_owner_fix_column_acls(), change_owner_recurse_to_sequences(), changeDependencyFor(), changeDependencyOnOwner(), check_db_file_conflict(), check_selective_binary_conversion(), CheckAndCreateToastTable(), CheckConstraintFetch(), checkSharedDependencies(), ChooseConstraintName(), cluster(), CollationCreate(), ConstraintNameIsUsed(), ConversionCreate(), copy_heap_data(), copyTemplateDependencies(), CountDBSubscriptions(), create_proc_lang(), create_toast_table(), CreateAccessMethod(), CreateCast(), CreateComments(), CreateConstraintEntry(), createdb(), CreateForeignDataWrapper(), CreateForeignServer(), CreateForeignTable(), CreateInheritance(), CreateOpFamily(), CreatePolicy(), CreatePublication(), CreateRole(), CreateSharedComments(), CreateStatistics(), CreateSubscription(), CreateTableSpace(), CreateTransform(), CreateTrigger(), CreateUserMapping(), currtid_byreloid(), database_to_xmlschema_internal(), DefineIndex(), DefineOpClass(), DefineQueryRewrite(), DefineRelation(), DefineSequence(), DefineTSConfiguration(), DefineTSDictionary(), DefineTSParser(), DefineTSTemplate(), DeleteAttributeTuples(), DeleteComments(), deleteDependencyRecordsFor(), deleteDependencyRecordsForClass(), DeleteInitPrivs(), deleteOneObject(), DeleteRelationTuple(), DeleteSecurityLabel(), DeleteSequenceTuple(), DeleteSharedComments(), deleteSharedDependencyRecordsFor(), DeleteSharedSecurityLabel(), DeleteSystemAttributeTuples(), DelRoleMems(), deparseColumnRef(), deparseFromExprForRel(), deparseSelectSql(), do_autovacuum(), drop_parent_dependency(), DropCastById(), dropDatabaseDependencies(), dropdb(), DropProceduralLanguageById(), DropRole(), DropSetting(), DropSubscription(), DropTableSpace(), DropTransformById(), EnableDisableRule(), EnableDisableTrigger(), ENRMetadataGetTupDesc(), enum_endpoint(), enum_range_internal(), EnumValuesCreate(), EnumValuesDelete(), EventTriggerSQLDropAddObject(), exec_object_restorecon(), ExecAlterExtensionStmt(), ExecAlterObjectSchemaStmt(), ExecAlterOwnerStmt(), ExecGetTriggerResultRel(), ExecGrant_Database(), ExecGrant_Fdw(), ExecGrant_ForeignServer(), ExecGrant_Function(), ExecGrant_Language(), ExecGrant_Largeobject(), ExecGrant_Namespace(), ExecGrant_Relation(), ExecGrant_Tablespace(), ExecGrant_Type(), ExecInitModifyTable(), ExecOpenScanRelation(), ExecRefreshMatView(), ExecRenameStmt(), ExecSetupPartitionTupleRouting(), ExecuteTruncate(), expand_inherited_rtentry(), expand_targetlist(), extension_config_remove(), find_composite_type_dependencies(), find_inheritance_children(), find_language_template(), find_typed_table_dependencies(), finish_heap_swap(), fireRIRrules(), generate_partition_qual(), get_actual_variable_range(), get_constraint_index(), get_database_list(), get_database_oid(), get_db_info(), get_domain_constraint_oid(), get_extension_name(), get_extension_oid(), get_extension_schema(), get_file_fdw_attribute_options(), get_index_constraint(), get_partition_parent(), get_partition_qual_relid(), get_pkey_attnames(), get_primary_key_attnos(), get_rel_oids(), get_relation_constraint_oid(), get_relation_constraints(), get_relation_data_width(), get_relation_info(), get_relation_policy_oid(), get_rels_with_domain(), get_row_security_policies(), get_subscription_list(), get_tables_to_cluster(), get_tablespace_name(), get_tablespace_oid(), get_trigger_oid(), GetAllTablesPublicationRelations(), GetAllTablesPublications(), GetComment(), getConstraintTypeDescription(), GetDatabaseTuple(), GetDatabaseTupleByOid(), GetDefaultOpClass(), getExtensionOfObject(), getObjectDescription(), getObjectIdentityParts(), getOwnedSequences(), GetPublicationRelations(), getRelationsInNamespace(), GetSecurityLabel(), GetSharedSecurityLabel(), GetSubscriptionNotReadyRelations(), GetSubscriptionRelations(), GetSubscriptionRelState(), gettype(), GrantRole(), has_row_triggers(), has_superclass(), heap_create_with_catalog(), heap_drop_with_catalog(), heap_sync(), heap_truncate(), heap_truncate_find_FKs(), heap_truncate_one_rel(), index_build(), index_constraint_create(), index_create(), index_drop(), index_set_state_flags(), index_update_stats(), infer_arbiter_indexes(), InitPlan(), insert_event_trigger_tuple(), InsertExtensionTuple(), InsertRule(), intorel_startup(), isQueryUsingTempRelation_walker(), LargeObjectCreate(), LargeObjectDrop(), LargeObjectExists(), load_domaintype_info(), load_enum_cache_data(), logicalrep_rel_open(), LogicalRepSyncTableStart(), lookup_ts_config_cache(), LookupOpclassInfo(), make_new_heap(), make_ruledef(), make_viewdef(), makeArrayTypeName(), mark_index_clustered(), MergeAttributesIntoExisting(), MergeConstraintsIntoExisting(), MergeWithExistingConstraint(), movedb(), myLargeObjectExists(), NamespaceCreate(), objectsInSchemaToOids(), open_lo_relation(), OpenTableList(), OperatorCreate(), OperatorShellMake(), OperatorUpd(), performDeletion(), performMultipleDeletions(), pg_event_trigger_ddl_commands(), pg_extension_config_dump(), pg_extension_ownercheck(), pg_get_constraintdef_worker(), pg_get_replica_identity_index(), pg_get_serial_sequence(), pg_get_triggerdef_worker(), pg_identify_object(), pg_largeobject_aclmask_snapshot(), pg_largeobject_ownercheck(), pgstat_collect_oids(), postgresPlanDirectModify(), postgresPlanForeignModify(), ProcedureCreate(), process_settings(), publication_add_relation(), RangeCreate(), RangeDelete(), recordExtensionInitPrivWorker(), recordExtObjInitPriv(), recordMultipleDependencies(), recordSharedDependencyOn(), refresh_by_match_merge(), reindex_index(), reindex_relation(), ReindexMultipleTables(), relation_has_policies(), relation_mark_replica_identity(), RelationBuildRowSecurity(), RelationBuildRuleLock(), RelationBuildTriggers(), RelationBuildTupleDesc(), RelationGetExclusionInfo(), RelationGetFKeyList(), RelationGetIndexList(), RelationGetPartitionDispatchInfo(), RelationGetStatExtList(), RelationRemoveInheritance(), RelationSetNewRelfilenode(), RelidByRelfilenode(), remove_dbtablespaces(), RemoveAccessMethodById(), RemoveAmOpEntryById(), RemoveAmProcEntryById(), RemoveAttrDefault(), RemoveAttrDefaultById(), RemoveAttributeById(), RemoveCollationById(), RemoveConstraintById(), RemoveConversionById(), RemoveDefaultACLById(), RemoveEventTriggerById(), RemoveExtensionById(), RemoveForeignDataWrapperById(), RemoveForeignServerById(), RemoveFunctionById(), RemoveInheritance(), RemoveOpClassById(), RemoveOperatorById(), RemoveOpFamilyById(), RemovePartitionKeyByRelId(), RemovePolicyById(), RemovePublicationById(), RemovePublicationRelById(), RemoveRewriteRuleById(), RemoveRoleFromObjectACL(), RemoveRoleFromObjectPolicy(), RemoveSchemaById(), RemoveStatistics(), RemoveStatisticsById(), RemoveSubscriptionRel(), RemoveTriggerById(), RemoveTSConfigurationById(), RemoveTSDictionaryById(), RemoveTSParserById(), RemoveTSTemplateById(), RemoveTypeById(), RemoveUserMappingById(), rename_policy(), renameatt_internal(), RenameConstraint(), RenameConstraintById(), RenameDatabase(), RenameEnumLabel(), RenameRelationInternal(), RenameRewriteRule(), RenameRole(), RenameSchema(), RenameTableSpace(), renametrig(), RenameType(), RenameTypeInternal(), replorigin_create(), replorigin_drop(), RewriteQuery(), rewriteTargetView(), RI_FKey_cascade_del(), RI_FKey_cascade_upd(), RI_FKey_check(), RI_FKey_setdefault_del(), RI_FKey_setdefault_upd(), RI_FKey_setnull_del(), RI_FKey_setnull_upd(), ri_restrict_del(), ri_restrict_upd(), ScanPgRelation(), schema_to_xmlschema_internal(), SearchCatCache(), SearchCatCacheList(), sepgsql_attribute_post_create(), sepgsql_database_post_create(), sepgsql_index_modify(), sepgsql_proc_post_create(), sepgsql_proc_setattr(), sepgsql_relation_post_create(), sepgsql_relation_setattr(), sepgsql_schema_post_create(), sequenceIsOwned(), SetDefaultACL(), SetFunctionArgType(), SetFunctionReturnType(), SetMatViewPopulatedState(), SetRelationHasSubclass(), SetRelationNumChecks(), SetRelationRuleStatus(), SetSecurityLabel(), SetSharedSecurityLabel(), SetSubscriptionRelState(), shdepDropOwned(), shdepReassignOwned(), StoreAttrDefault(), StoreCatalogInheritance(), storeOperators(), StorePartitionBound(), StorePartitionKey(), storeProcedures(), swap_relation_files(), table_to_xml_and_xmlschema(), table_to_xmlschema(), ThereIsAtLeastOneRole(), toast_delete_datum(), toast_fetch_datum(), toast_fetch_datum_slice(), toast_get_valid_index(), toast_save_datum(), toastid_valueid_exists(), transientrel_startup(), TypeCreate(), typeInheritsFrom(), TypeShellMake(), update_attstats(), updateAclDependencies(), UpdateIndexRelation(), vac_truncate_clog(), vac_update_datfrozenxid(), vac_update_relstats(), validate_index(), and ValidatePartitionConstraints().

1291 {
1292  Relation r;
1293 
1294  r = relation_open(relationId, lockmode);
1295 
1296  if (r->rd_rel->relkind == RELKIND_INDEX)
1297  ereport(ERROR,
1298  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1299  errmsg("\"%s\" is an index",
1301  else if (r->rd_rel->relkind == RELKIND_COMPOSITE_TYPE)
1302  ereport(ERROR,
1303  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1304  errmsg("\"%s\" is a composite type",
1306 
1307  return r;
1308 }
int errcode(int sqlerrcode)
Definition: elog.c:575
Form_pg_class rd_rel
Definition: rel.h:114
#define RELKIND_COMPOSITE_TYPE
Definition: pg_class.h:166
#define ERROR
Definition: elog.h:43
#define RelationGetRelationName(relation)
Definition: rel.h:436
#define ereport(elevel, rest)
Definition: elog.h:122
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define RELKIND_INDEX
Definition: pg_class.h:161
Relation relation_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1120
Relation heap_openrv ( const RangeVar relation,
LOCKMODE  lockmode 
)

Definition at line 1318 of file heapam.c.

References ereport, errcode(), errmsg(), ERROR, RelationData::rd_rel, relation_openrv(), RelationGetRelationName, RELKIND_COMPOSITE_TYPE, and RELKIND_INDEX.

Referenced by ATAddForeignKeyConstraint(), ATExecAddInherit(), ATExecAttachPartition(), ATExecDetachPartition(), ATExecDropInherit(), boot_openrel(), BootstrapToastTable(), CreateTrigger(), currtid_byrelname(), DefineIndex(), DoCopy(), ExecuteTruncate(), get_rel_from_relname(), MergeAttributes(), OpenTableList(), transformIndexConstraint(), and transformRuleStmt().

1319 {
1320  Relation r;
1321 
1322  r = relation_openrv(relation, lockmode);
1323 
1324  if (r->rd_rel->relkind == RELKIND_INDEX)
1325  ereport(ERROR,
1326  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1327  errmsg("\"%s\" is an index",
1329  else if (r->rd_rel->relkind == RELKIND_COMPOSITE_TYPE)
1330  ereport(ERROR,
1331  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1332  errmsg("\"%s\" is a composite type",
1334 
1335  return r;
1336 }
Relation relation_openrv(const RangeVar *relation, LOCKMODE lockmode)
Definition: heapam.c:1198
int errcode(int sqlerrcode)
Definition: elog.c:575
Form_pg_class rd_rel
Definition: rel.h:114
#define RELKIND_COMPOSITE_TYPE
Definition: pg_class.h:166
#define ERROR
Definition: elog.h:43
#define RelationGetRelationName(relation)
Definition: rel.h:436
#define ereport(elevel, rest)
Definition: elog.h:122
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define RELKIND_INDEX
Definition: pg_class.h:161
Relation heap_openrv_extended ( const RangeVar relation,
LOCKMODE  lockmode,
bool  missing_ok 
)

Definition at line 1347 of file heapam.c.

References ereport, errcode(), errmsg(), ERROR, RelationData::rd_rel, relation_openrv_extended(), RelationGetRelationName, RELKIND_COMPOSITE_TYPE, and RELKIND_INDEX.

Referenced by get_object_address_relobject(), and parserOpenTable().

1349 {
1350  Relation r;
1351 
1352  r = relation_openrv_extended(relation, lockmode, missing_ok);
1353 
1354  if (r)
1355  {
1356  if (r->rd_rel->relkind == RELKIND_INDEX)
1357  ereport(ERROR,
1358  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1359  errmsg("\"%s\" is an index",
1361  else if (r->rd_rel->relkind == RELKIND_COMPOSITE_TYPE)
1362  ereport(ERROR,
1363  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
1364  errmsg("\"%s\" is a composite type",
1366  }
1367 
1368  return r;
1369 }
int errcode(int sqlerrcode)
Definition: elog.c:575
Form_pg_class rd_rel
Definition: rel.h:114
#define RELKIND_COMPOSITE_TYPE
Definition: pg_class.h:166
#define ERROR
Definition: elog.h:43
#define RelationGetRelationName(relation)
Definition: rel.h:436
#define ereport(elevel, rest)
Definition: elog.h:122
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define RELKIND_INDEX
Definition: pg_class.h:161
Relation relation_openrv_extended(const RangeVar *relation, LOCKMODE lockmode, bool missing_ok)
Definition: heapam.c:1233
int heap_page_prune ( Relation  relation,
Buffer  buffer,
TransactionId  OldestXmin,
bool  report_stats,
TransactionId latestRemovedXid 
)

Definition at line 181 of file pruneheap.c.

References BufferGetPage, END_CRIT_SECTION, FirstOffsetNumber, heap_page_prune_execute(), heap_prune_chain(), InvalidTransactionId, ItemIdIsDead, ItemIdIsUsed, PruneState::latestRemovedXid, log_heap_clean(), MarkBufferDirty(), MarkBufferDirtyHint(), PruneState::marked, PruneState::ndead, PruneState::new_prune_xid, PruneState::nowdead, PruneState::nowunused, PruneState::nredirected, PruneState::nunused, OffsetNumberNext, PageClearFull, PageGetItemId, PageGetMaxOffsetNumber, PageIsFull, PageSetLSN, pgstat_update_heap_dead_tuples(), PruneState::redirected, RelationNeedsWAL, and START_CRIT_SECTION.

Referenced by heap_page_prune_opt(), and lazy_scan_heap().

183 {
184  int ndeleted = 0;
185  Page page = BufferGetPage(buffer);
186  OffsetNumber offnum,
187  maxoff;
188  PruneState prstate;
189 
190  /*
191  * Our strategy is to scan the page and make lists of items to change,
192  * then apply the changes within a critical section. This keeps as much
193  * logic as possible out of the critical section, and also ensures that
194  * WAL replay will work the same as the normal case.
195  *
196  * First, initialize the new pd_prune_xid value to zero (indicating no
197  * prunable tuples). If we find any tuples which may soon become
198  * prunable, we will save the lowest relevant XID in new_prune_xid. Also
199  * initialize the rest of our working state.
200  */
202  prstate.latestRemovedXid = *latestRemovedXid;
203  prstate.nredirected = prstate.ndead = prstate.nunused = 0;
204  memset(prstate.marked, 0, sizeof(prstate.marked));
205 
206  /* Scan the page */
207  maxoff = PageGetMaxOffsetNumber(page);
208  for (offnum = FirstOffsetNumber;
209  offnum <= maxoff;
210  offnum = OffsetNumberNext(offnum))
211  {
212  ItemId itemid;
213 
214  /* Ignore items already processed as part of an earlier chain */
215  if (prstate.marked[offnum])
216  continue;
217 
218  /* Nothing to do if slot is empty or already dead */
219  itemid = PageGetItemId(page, offnum);
220  if (!ItemIdIsUsed(itemid) || ItemIdIsDead(itemid))
221  continue;
222 
223  /* Process this item or chain of items */
224  ndeleted += heap_prune_chain(relation, buffer, offnum,
225  OldestXmin,
226  &prstate);
227  }
228 
229  /* Any error while applying the changes is critical */
231 
232  /* Have we found any prunable items? */
233  if (prstate.nredirected > 0 || prstate.ndead > 0 || prstate.nunused > 0)
234  {
235  /*
236  * Apply the planned item changes, then repair page fragmentation, and
237  * update the page's hint bit about whether it has free line pointers.
238  */
240  prstate.redirected, prstate.nredirected,
241  prstate.nowdead, prstate.ndead,
242  prstate.nowunused, prstate.nunused);
243 
244  /*
245  * Update the page's pd_prune_xid field to either zero, or the lowest
246  * XID of any soon-prunable tuple.
247  */
248  ((PageHeader) page)->pd_prune_xid = prstate.new_prune_xid;
249 
250  /*
251  * Also clear the "page is full" flag, since there's no point in
252  * repeating the prune/defrag process until something else happens to
253  * the page.
254  */
255  PageClearFull(page);
256 
258 
259  /*
260  * Emit a WAL HEAP_CLEAN record showing what we did
261  */
262  if (RelationNeedsWAL(relation))
263  {
264  XLogRecPtr recptr;
265 
266  recptr = log_heap_clean(relation, buffer,
267  prstate.redirected, prstate.nredirected,
268  prstate.nowdead, prstate.ndead,
269  prstate.nowunused, prstate.nunused,
270  prstate.latestRemovedXid);
271 
272  PageSetLSN(BufferGetPage(buffer), recptr);
273  }
274  }
275  else
276  {
277  /*
278  * If we didn't prune anything, but have found a new value for the
279  * pd_prune_xid field, update it and mark the buffer dirty. This is
280  * treated as a non-WAL-logged hint.
281  *
282  * Also clear the "page is full" flag if it is set, since there's no
283  * point in repeating the prune/defrag process until something else
284  * happens to the page.
285  */
286  if (((PageHeader) page)->pd_prune_xid != prstate.new_prune_xid ||
287  PageIsFull(page))
288  {
289  ((PageHeader) page)->pd_prune_xid = prstate.new_prune_xid;
290  PageClearFull(page);
292  }
293  }
294 
296 
297  /*
298  * If requested, report the number of tuples reclaimed to pgstats. This is
299  * ndeleted minus ndead, because we don't want to count a now-DEAD root
300  * item as a deletion for this purpose.
301  */
302  if (report_stats && ndeleted > prstate.ndead)
303  pgstat_update_heap_dead_tuples(relation, ndeleted - prstate.ndead);
304 
305  *latestRemovedXid = prstate.latestRemovedXid;
306 
307  /*
308  * XXX Should we update the FSM information of this page ?
309  *
310  * There are two schools of thought here. We may not want to update FSM
311  * information so that the page is not used for unrelated UPDATEs/INSERTs
312  * and any free space in this page will remain available for further
313  * UPDATEs in *this* page, thus improving chances for doing HOT updates.
314  *
315  * But for a large table and where a page does not receive further UPDATEs
316  * for a long time, we might waste this space by not updating the FSM
317  * information. The relation may get extended and fragmented further.
318  *
319  * One possibility is to leave "fillfactor" worth of space in this page
320  * and update FSM with the remaining space.
321  */
322 
323  return ndeleted;
324 }
static int heap_prune_chain(Relation relation, Buffer buffer, OffsetNumber rootoffnum, TransactionId OldestXmin, PruneState *prstate)
Definition: pruneheap.c:353
int nredirected
Definition: pruneheap.c:35
void pgstat_update_heap_dead_tuples(Relation rel, int delta)
Definition: pgstat.c:2037
void MarkBufferDirtyHint(Buffer buffer, bool buffer_std)
Definition: bufmgr.c:3379
void MarkBufferDirty(Buffer buffer)
Definition: bufmgr.c:1450
#define END_CRIT_SECTION()
Definition: miscadmin.h:133
#define ItemIdIsUsed(itemId)
Definition: itemid.h:91