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)
 
void heap_parallelscan_reinitialize (ParallelHeapScanDesc parallel_scan)
 
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)
 
bool HeapTupleUpdateXmaxMatchesXmin (TransactionId xmax, HeapTupleHeader htup)
 
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_default_allows_bound(), 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_partitioned_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_all_vacuum_rels(), 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_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(), SearchCatCacheList(), SearchCatCacheMiss(), 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(), update_default_partition_oid(), 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 2393 of file heapam.c.

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

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

2394 {
2395  if (bistate->current_buf != InvalidBuffer)
2396  ReleaseBuffer(bistate->current_buf);
2397  FreeAccessStrategy(bistate->strategy);
2398  pfree(bistate);
2399 }
#define InvalidBuffer
Definition: buf.h:25
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
void pfree(void *pointer)
Definition: mcxt.c:949
void FreeAccessStrategy(BufferAccessStrategy strategy)
Definition: freelist.c:597
BulkInsertState GetBulkInsertState ( void  )

Definition at line 2379 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().

2380 {
2381  BulkInsertState bistate;
2382 
2383  bistate = (BulkInsertState) palloc(sizeof(BulkInsertStateData));
2385  bistate->current_buf = InvalidBuffer;
2386  return bistate;
2387 }
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:848
Buffer current_buf
Definition: hio.h:34
void heap_abort_speculative ( Relation  relation,
HeapTuple  tuple 
)

Definition at line 6149 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().

6150 {
6152  ItemPointer tid = &(tuple->t_self);
6153  ItemId lp;
6154  HeapTupleData tp;
6155  Page page;
6156  BlockNumber block;
6157  Buffer buffer;
6158 
6159  Assert(ItemPointerIsValid(tid));
6160 
6161  block = ItemPointerGetBlockNumber(tid);
6162  buffer = ReadBuffer(relation, block);
6163  page = BufferGetPage(buffer);
6164 
6166 
6167  /*
6168  * Page can't be all visible, we just inserted into it, and are still
6169  * running.
6170  */
6171  Assert(!PageIsAllVisible(page));
6172 
6173  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
6174  Assert(ItemIdIsNormal(lp));
6175 
6176  tp.t_tableOid = RelationGetRelid(relation);
6177  tp.t_data = (HeapTupleHeader) PageGetItem(page, lp);
6178  tp.t_len = ItemIdGetLength(lp);
6179  tp.t_self = *tid;
6180 
6181  /*
6182  * Sanity check that the tuple really is a speculatively inserted tuple,
6183  * inserted by us.
6184  */
6185  if (tp.t_data->t_choice.t_heap.t_xmin != xid)
6186  elog(ERROR, "attempted to kill a tuple inserted by another transaction");
6187  if (!(IsToastRelation(relation) || HeapTupleHeaderIsSpeculative(tp.t_data)))
6188  elog(ERROR, "attempted to kill a non-speculative tuple");
6190 
6191  /*
6192  * No need to check for serializable conflicts here. There is never a
6193  * need for a combocid, either. No need to extract replica identity, or
6194  * do anything special with infomask bits.
6195  */
6196 
6198 
6199  /*
6200  * The tuple will become DEAD immediately. Flag that this page
6201  * immediately is a candidate for pruning by setting xmin to
6202  * RecentGlobalXmin. That's not pretty, but it doesn't seem worth
6203  * inventing a nicer API for this.
6204  */
6207 
6208  /* store transaction information of xact deleting the tuple */
6211 
6212  /*
6213  * Set the tuple header xmin to InvalidTransactionId. This makes the
6214  * tuple immediately invisible everyone. (In particular, to any
6215  * transactions waiting on the speculative token, woken up later.)
6216  */
6218 
6219  /* Clear the speculative insertion token too */
6220  tp.t_data->t_ctid = tp.t_self;
6221 
6222  MarkBufferDirty(buffer);
6223 
6224  /*
6225  * XLOG stuff
6226  *
6227  * The WAL records generated here match heap_delete(). The same recovery
6228  * routines are used.
6229  */
6230  if (RelationNeedsWAL(relation))
6231  {
6232  xl_heap_delete xlrec;
6233  XLogRecPtr recptr;
6234 
6235  xlrec.flags = XLH_DELETE_IS_SUPER;
6237  tp.t_data->t_infomask2);
6239  xlrec.xmax = xid;
6240 
6241  XLogBeginInsert();
6242  XLogRegisterData((char *) &xlrec, SizeOfHeapDelete);
6243  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6244 
6245  /* No replica identity & replication origin logged */
6246 
6247  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_DELETE);
6248 
6249  PageSetLSN(page, recptr);
6250  }
6251 
6252  END_CRIT_SECTION();
6253 
6254  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
6255 
6256  if (HeapTupleHasExternal(&tp))
6257  {
6258  Assert(!IsToastRelation(relation));
6259  toast_delete(relation, &tp, true);
6260  }
6261 
6262  /*
6263  * Never need to mark tuple for invalidation, since catalogs don't support
6264  * speculative insertion
6265  */
6266 
6267  /* Now we can release the buffer */
6268  ReleaseBuffer(buffer);
6269 
6270  /* count deletion, as we counted the insertion too */
6271  pgstat_count_heap_delete(relation);
6272 }
#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:3014
HeapTupleFields t_heap
Definition: htup_details.h:146
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:391
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:418
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:681
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(), check_default_allows_bound(), 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
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
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_all_vacuum_rels(), get_database_list(), 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 RelationGetRelid(relation)
Definition: rel.h:416
HeapScanDesc heap_beginscan_parallel ( Relation  ,
ParallelHeapScanDesc   
)

Definition at line 1650 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().

1651 {
1652  Snapshot snapshot;
1653 
1654  Assert(RelationGetRelid(relation) == parallel_scan->phs_relid);
1655  snapshot = RestoreSnapshot(parallel_scan->phs_snapshot_data);
1656  RegisterSnapshot(snapshot);
1657 
1658  return heap_beginscan_internal(relation, snapshot, 0, NULL, parallel_scan,
1659  true, true, true, false, false, true);
1660 }
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 Assert(condition)
Definition: c.h:681
#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
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
HTSU_Result heap_delete ( Relation  relation,
ItemPointer  tid,
CommandId  cid,
Snapshot  crosscheck,
bool  wait,
HeapUpdateFailureData hufd 
)

Definition at line 3073 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, 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, 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().

3076 {
3077  HTSU_Result result;
3079  ItemId lp;
3080  HeapTupleData tp;
3081  Page page;
3082  BlockNumber block;
3083  Buffer buffer;
3084  Buffer vmbuffer = InvalidBuffer;
3085  TransactionId new_xmax;
3086  uint16 new_infomask,
3087  new_infomask2;
3088  bool have_tuple_lock = false;
3089  bool iscombo;
3090  bool all_visible_cleared = false;
3091  HeapTuple old_key_tuple = NULL; /* replica identity of the tuple */
3092  bool old_key_copied = false;
3093 
3094  Assert(ItemPointerIsValid(tid));
3095 
3096  /*
3097  * Forbid this during a parallel operation, lest it allocate a combocid.
3098  * Other workers might need that combocid for visibility checks, and we
3099  * have no provision for broadcasting it to them.
3100  */
3101  if (IsInParallelMode())
3102  ereport(ERROR,
3103  (errcode(ERRCODE_INVALID_TRANSACTION_STATE),
3104  errmsg("cannot delete tuples during a parallel operation")));
3105 
3106  block = ItemPointerGetBlockNumber(tid);
3107  buffer = ReadBuffer(relation, block);
3108  page = BufferGetPage(buffer);
3109 
3110  /*
3111  * Before locking the buffer, pin the visibility map page if it appears to
3112  * be necessary. Since we haven't got the lock yet, someone else might be
3113  * in the middle of changing this, so we'll need to recheck after we have
3114  * the lock.
3115  */
3116  if (PageIsAllVisible(page))
3117  visibilitymap_pin(relation, block, &vmbuffer);
3118 
3120 
3121  /*
3122  * If we didn't pin the visibility map page and the page has become all
3123  * visible while we were busy locking the buffer, we'll have to unlock and
3124  * re-lock, to avoid holding the buffer lock across an I/O. That's a bit
3125  * unfortunate, but hopefully shouldn't happen often.
3126  */
3127  if (vmbuffer == InvalidBuffer && PageIsAllVisible(page))
3128  {
3129  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3130  visibilitymap_pin(relation, block, &vmbuffer);
3132  }
3133 
3134  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
3135  Assert(ItemIdIsNormal(lp));
3136 
3137  tp.t_tableOid = RelationGetRelid(relation);
3138  tp.t_data = (HeapTupleHeader) PageGetItem(page, lp);
3139  tp.t_len = ItemIdGetLength(lp);
3140  tp.t_self = *tid;
3141 
3142 l1:
3143  result = HeapTupleSatisfiesUpdate(&tp, cid, buffer);
3144 
3145  if (result == HeapTupleInvisible)
3146  {
3147  UnlockReleaseBuffer(buffer);
3148  ereport(ERROR,
3149  (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
3150  errmsg("attempted to delete invisible tuple")));
3151  }
3152  else if (result == HeapTupleBeingUpdated && wait)
3153  {
3154  TransactionId xwait;
3155  uint16 infomask;
3156 
3157  /* must copy state data before unlocking buffer */
3158  xwait = HeapTupleHeaderGetRawXmax(tp.t_data);
3159  infomask = tp.t_data->t_infomask;
3160 
3161  /*
3162  * Sleep until concurrent transaction ends -- except when there's a
3163  * single locker and it's our own transaction. Note we don't care
3164  * which lock mode the locker has, because we need the strongest one.
3165  *
3166  * Before sleeping, we need to acquire tuple lock to establish our
3167  * priority for the tuple (see heap_lock_tuple). LockTuple will
3168  * release us when we are next-in-line for the tuple.
3169  *
3170  * If we are forced to "start over" below, we keep the tuple lock;
3171  * this arranges that we stay at the head of the line while rechecking
3172  * tuple state.
3173  */
3174  if (infomask & HEAP_XMAX_IS_MULTI)
3175  {
3176  /* wait for multixact */
3177  if (DoesMultiXactIdConflict((MultiXactId) xwait, infomask,
3179  {
3180  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3181 
3182  /* acquire tuple lock, if necessary */
3184  LockWaitBlock, &have_tuple_lock);
3185 
3186  /* wait for multixact */
3188  relation, &(tp.t_self), XLTW_Delete,
3189  NULL);
3191 
3192  /*
3193  * If xwait had just locked the tuple then some other xact
3194  * could update this tuple before we get to this point. Check
3195  * for xmax change, and start over if so.
3196  */
3197  if (xmax_infomask_changed(tp.t_data->t_infomask, infomask) ||
3199  xwait))
3200  goto l1;
3201  }
3202 
3203  /*
3204  * You might think the multixact is necessarily done here, but not
3205  * so: it could have surviving members, namely our own xact or
3206  * other subxacts of this backend. It is legal for us to delete
3207  * the tuple in either case, however (the latter case is
3208  * essentially a situation of upgrading our former shared lock to
3209  * exclusive). We don't bother changing the on-disk hint bits
3210  * since we are about to overwrite the xmax altogether.
3211  */
3212  }
3213  else if (!TransactionIdIsCurrentTransactionId(xwait))
3214  {
3215  /*
3216  * Wait for regular transaction to end; but first, acquire tuple
3217  * lock.
3218  */
3219  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3221  LockWaitBlock, &have_tuple_lock);
3222  XactLockTableWait(xwait, relation, &(tp.t_self), XLTW_Delete);
3224 
3225  /*
3226  * xwait is done, but if xwait had just locked the tuple then some
3227  * other xact could update this tuple before we get to this point.
3228  * Check for xmax change, and start over if so.
3229  */
3230  if (xmax_infomask_changed(tp.t_data->t_infomask, infomask) ||
3232  xwait))
3233  goto l1;
3234 
3235  /* Otherwise check if it committed or aborted */
3236  UpdateXmaxHintBits(tp.t_data, buffer, xwait);
3237  }
3238 
3239  /*
3240  * We may overwrite if previous xmax aborted, or if it committed but
3241  * only locked the tuple without updating it.
3242  */
3243  if ((tp.t_data->t_infomask & HEAP_XMAX_INVALID) ||
3246  result = HeapTupleMayBeUpdated;
3247  else
3248  result = HeapTupleUpdated;
3249  }
3250 
3251  if (crosscheck != InvalidSnapshot && result == HeapTupleMayBeUpdated)
3252  {
3253  /* Perform additional check for transaction-snapshot mode RI updates */
3254  if (!HeapTupleSatisfiesVisibility(&tp, crosscheck, buffer))
3255  result = HeapTupleUpdated;
3256  }
3257 
3258  if (result != HeapTupleMayBeUpdated)
3259  {
3260  Assert(result == HeapTupleSelfUpdated ||
3261  result == HeapTupleUpdated ||
3262  result == HeapTupleBeingUpdated);
3264  hufd->ctid = tp.t_data->t_ctid;
3266  if (result == HeapTupleSelfUpdated)
3267  hufd->cmax = HeapTupleHeaderGetCmax(tp.t_data);
3268  else
3269  hufd->cmax = InvalidCommandId;
3270  UnlockReleaseBuffer(buffer);
3271  if (have_tuple_lock)
3272  UnlockTupleTuplock(relation, &(tp.t_self), LockTupleExclusive);
3273  if (vmbuffer != InvalidBuffer)
3274  ReleaseBuffer(vmbuffer);
3275  return result;
3276  }
3277 
3278  /*
3279  * We're about to do the actual delete -- check for conflict first, to
3280  * avoid possibly having to roll back work we've just done.
3281  *
3282  * This is safe without a recheck as long as there is no possibility of
3283  * another process scanning the page between this check and the delete
3284  * being visible to the scan (i.e., an exclusive buffer content lock is
3285  * continuously held from this point until the tuple delete is visible).
3286  */
3287  CheckForSerializableConflictIn(relation, &tp, buffer);
3288 
3289  /* replace cid with a combo cid if necessary */
3290  HeapTupleHeaderAdjustCmax(tp.t_data, &cid, &iscombo);
3291 
3292  /*
3293  * Compute replica identity tuple before entering the critical section so
3294  * we don't PANIC upon a memory allocation failure.
3295  */
3296  old_key_tuple = ExtractReplicaIdentity(relation, &tp, true, &old_key_copied);
3297 
3298  /*
3299  * If this is the first possibly-multixact-able operation in the current
3300  * transaction, set my per-backend OldestMemberMXactId setting. We can be
3301  * certain that the transaction will never become a member of any older
3302  * MultiXactIds than that. (We have to do this even if we end up just
3303  * using our own TransactionId below, since some other backend could
3304  * incorporate our XID into a MultiXact immediately afterwards.)
3305  */
3307 
3310  xid, LockTupleExclusive, true,
3311  &new_xmax, &new_infomask, &new_infomask2);
3312 
3314 
3315  /*
3316  * If this transaction commits, the tuple will become DEAD sooner or
3317  * later. Set flag that this page is a candidate for pruning once our xid
3318  * falls below the OldestXmin horizon. If the transaction finally aborts,
3319  * the subsequent page pruning will be a no-op and the hint will be
3320  * cleared.
3321  */
3322  PageSetPrunable(page, xid);
3323 
3324  if (PageIsAllVisible(page))
3325  {
3326  all_visible_cleared = true;
3327  PageClearAllVisible(page);
3328  visibilitymap_clear(relation, BufferGetBlockNumber(buffer),
3329  vmbuffer, VISIBILITYMAP_VALID_BITS);
3330  }
3331 
3332  /* store transaction information of xact deleting the tuple */
3335  tp.t_data->t_infomask |= new_infomask;
3336  tp.t_data->t_infomask2 |= new_infomask2;
3338  HeapTupleHeaderSetXmax(tp.t_data, new_xmax);
3339  HeapTupleHeaderSetCmax(tp.t_data, cid, iscombo);
3340  /* Make sure there is no forward chain link in t_ctid */
3341  tp.t_data->t_ctid = tp.t_self;
3342 
3343  MarkBufferDirty(buffer);
3344 
3345  /*
3346  * XLOG stuff
3347  *
3348  * NB: heap_abort_speculative() uses the same xlog record and replay
3349  * routines.
3350  */
3351  if (RelationNeedsWAL(relation))
3352  {
3353  xl_heap_delete xlrec;
3354  XLogRecPtr recptr;
3355 
3356  /* For logical decode we need combocids to properly decode the catalog */
3358  log_heap_new_cid(relation, &tp);
3359 
3360  xlrec.flags = all_visible_cleared ? XLH_DELETE_ALL_VISIBLE_CLEARED : 0;
3362  tp.t_data->t_infomask2);
3364  xlrec.xmax = new_xmax;
3365 
3366  if (old_key_tuple != NULL)
3367  {
3368  if (relation->rd_rel->relreplident == REPLICA_IDENTITY_FULL)
3370  else
3372  }
3373 
3374  XLogBeginInsert();
3375  XLogRegisterData((char *) &xlrec, SizeOfHeapDelete);
3376 
3377  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
3378 
3379  /*
3380  * Log replica identity of the deleted tuple if there is one
3381  */
3382  if (old_key_tuple != NULL)
3383  {
3384  xl_heap_header xlhdr;
3385 
3386  xlhdr.t_infomask2 = old_key_tuple->t_data->t_infomask2;
3387  xlhdr.t_infomask = old_key_tuple->t_data->t_infomask;
3388  xlhdr.t_hoff = old_key_tuple->t_data->t_hoff;
3389 
3390  XLogRegisterData((char *) &xlhdr, SizeOfHeapHeader);
3391  XLogRegisterData((char *) old_key_tuple->t_data
3393  old_key_tuple->t_len
3395  }
3396 
3397  /* filtering by origin on a row level is much more efficient */
3399 
3400  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_DELETE);
3401 
3402  PageSetLSN(page, recptr);
3403  }
3404 
3405  END_CRIT_SECTION();
3406 
3407  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
3408 
3409  if (vmbuffer != InvalidBuffer)
3410  ReleaseBuffer(vmbuffer);
3411 
3412  /*
3413  * If the tuple has toasted out-of-line attributes, we need to delete
3414  * those items too. We have to do this before releasing the buffer
3415  * because we need to look at the contents of the tuple, but it's OK to
3416  * release the content lock on the buffer first.
3417  */
3418  if (relation->rd_rel->relkind != RELKIND_RELATION &&
3419  relation->rd_rel->relkind != RELKIND_MATVIEW)
3420  {
3421  /* toast table entries should never be recursively toasted */
3423  }
3424  else if (HeapTupleHasExternal(&tp))
3425  toast_delete(relation, &tp, false);
3426 
3427  /*
3428  * Mark tuple for invalidation from system caches at next command
3429  * boundary. We have to do this before releasing the buffer because we
3430  * need to look at the contents of the tuple.
3431  */
3432  CacheInvalidateHeapTuple(relation, &tp, NULL);
3433 
3434  /* Now we can release the buffer */
3435  ReleaseBuffer(buffer);
3436 
3437  /*
3438  * Release the lmgr tuple lock, if we had it.
3439  */
3440  if (have_tuple_lock)
3441  UnlockTupleTuplock(relation, &(tp.t_self), LockTupleExclusive);
3442 
3443  pgstat_count_heap_delete(relation);
3444 
3445  if (old_key_tuple != NULL && old_key_copied)
3446  heap_freetuple(old_key_tuple);
3447 
3448  return HeapTupleMayBeUpdated;
3449 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
bool HeapTupleHeaderIsOnlyLocked(HeapTupleHeader tuple)
Definition: tqual.c:1605
#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:7812
#define HEAP_XMAX_BITS
Definition: htup_details.h:256
static uint8 compute_infobits(uint16 infomask, uint16 infomask2)
Definition: heapam.c:3014
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:391
HTSU_Result HeapTupleSatisfiesUpdate(HeapTuple htup, CommandId curcid, Buffer buffer)
Definition: tqual.c:460
bool TransactionIdIsCurrentTransactionId(TransactionId xid)
Definition: xact.c:766
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:3036
#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:192
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:4326
#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:257
#define ItemIdGetLength(itemId)
Definition: itemid.h:58
bool IsInParallelMode(void)
Definition: xact.c:906
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:7228
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:418
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:121
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:5318
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:408
#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:2357
#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:5269
TransactionId MultiXactId
Definition: c.h:401
#define PageClearAllVisible(page)
Definition: bufpage.h:385
void XactLockTableWait(TransactionId xid, Relation rel, ItemPointer ctid, XLTW_Oper oper)
Definition: lmgr.c:554
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:681
uint8 infobits_set
Definition: heapam_xlog.h:106
static HeapTuple ExtractReplicaIdentity(Relation rel, HeapTuple tup, bool key_modified, bool *copy)
Definition: heapam.c:7888
CommandId HeapTupleHeaderGetCmax(HeapTupleHeader tup)
Definition: combocid.c:119
static bool DoesMultiXactIdConflict(MultiXactId multi, uint16 infomask, LockTupleMode lockmode)
Definition: heapam.c:7061
#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 1565 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(), check_default_allows_bound(), copy_heap_data(), CopyTo(), createdb(), DefineQueryRewrite(), do_autovacuum(), DropSetting(), DropTableSpace(), ExecEndBitmapHeapScan(), ExecEndSampleScan(), ExecEndSeqScan(), find_typed_table_dependencies(), get_all_vacuum_rels(), get_database_list(), 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().

1566 {
1567  /* Note: no locking manipulations needed */
1568 
1569  /*
1570  * unpin scan buffers
1571  */
1572  if (BufferIsValid(scan->rs_cbuf))
1573  ReleaseBuffer(scan->rs_cbuf);
1574 
1575  /*
1576  * decrement relation reference count and free scan descriptor storage
1577  */
1579 
1580  if (scan->rs_key)
1581  pfree(scan->rs_key);
1582 
1583  if (scan->rs_strategy != NULL)
1585 
1586  if (scan->rs_temp_snap)
1588 
1589  pfree(scan);
1590 }
void ReleaseBuffer(Buffer buffer)
Definition: bufmgr.c:3309
void pfree(void *pointer)
Definition: mcxt.c:949
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 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 1876 of file heapam.c.

References buffer, BUFFER_LOCK_SHARE, BUFFER_LOCK_UNLOCK, BufferGetPage, CheckForSerializableConflictOut(), HeapTupleSatisfiesVisibility, InvalidBuffer, ItemIdGetLength, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), 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().

1882 {
1883  ItemPointer tid = &(tuple->t_self);
1884  ItemId lp;
1885  Buffer buffer;
1886  Page page;
1887  OffsetNumber offnum;
1888  bool valid;
1889 
1890  /*
1891  * Fetch and pin the appropriate page of the relation.
1892  */
1893  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(tid));
1894 
1895  /*
1896  * Need share lock on buffer to examine tuple commit status.
1897  */
1898  LockBuffer(buffer, BUFFER_LOCK_SHARE);
1899  page = BufferGetPage(buffer);
1900  TestForOldSnapshot(snapshot, relation, page);
1901 
1902  /*
1903  * We'd better check for out-of-range offnum in case of VACUUM since the
1904  * TID was obtained.
1905  */
1906  offnum = ItemPointerGetOffsetNumber(tid);
1907  if (offnum < FirstOffsetNumber || offnum > PageGetMaxOffsetNumber(page))
1908  {
1909  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1910  if (keep_buf)
1911  *userbuf = buffer;
1912  else
1913  {
1914  ReleaseBuffer(buffer);
1915  *userbuf = InvalidBuffer;
1916  }
1917  tuple->t_data = NULL;
1918  return false;
1919  }
1920 
1921  /*
1922  * get the item line pointer corresponding to the requested tid
1923  */
1924  lp = PageGetItemId(page, offnum);
1925 
1926  /*
1927  * Must check for deleted tuple.
1928  */
1929  if (!ItemIdIsNormal(lp))
1930  {
1931  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1932  if (keep_buf)
1933  *userbuf = buffer;
1934  else
1935  {
1936  ReleaseBuffer(buffer);
1937  *userbuf = InvalidBuffer;
1938  }
1939  tuple->t_data = NULL;
1940  return false;
1941  }
1942 
1943  /*
1944  * fill in *tuple fields
1945  */
1946  tuple->t_data = (HeapTupleHeader) PageGetItem(page, lp);
1947  tuple->t_len = ItemIdGetLength(lp);
1948  tuple->t_tableOid = RelationGetRelid(relation);
1949 
1950  /*
1951  * check time qualification of tuple, then release lock
1952  */
1953  valid = HeapTupleSatisfiesVisibility(tuple, snapshot, buffer);
1954 
1955  if (valid)
1956  PredicateLockTuple(relation, tuple, snapshot);
1957 
1958  CheckForSerializableConflictOut(valid, relation, tuple, buffer, snapshot);
1959 
1960  LockBuffer(buffer, BUFFER_LOCK_UNLOCK);
1961 
1962  if (valid)
1963  {
1964  /*
1965  * All checks passed, so return the tuple as valid. Caller is now
1966  * responsible for releasing the buffer.
1967  */
1968  *userbuf = buffer;
1969 
1970  /* Count the successful fetch against appropriate rel, if any */
1971  if (stats_relation != NULL)
1972  pgstat_count_heap_fetch(stats_relation);
1973 
1974  return true;
1975  }
1976 
1977  /* Tuple failed time qual, but maybe caller wants to see it anyway. */
1978  if (keep_buf)
1979  *userbuf = buffer;
1980  else
1981  {
1982  ReleaseBuffer(buffer);
1983  *userbuf = InvalidBuffer;
1984  }
1985 
1986  return false;
1987 }
#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:3945
#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:1270
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 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:2543
#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 6058 of file heapam.c.

References Assert, buffer, BUFFER_LOCK_EXCLUSIVE, BufferGetPage, elog, END_CRIT_SECTION, ERROR, HeapTupleHeaderIsSpeculative, ItemIdIsNormal, ItemPointerGetBlockNumber, ItemPointerGetOffsetNumber, LockBuffer(), MarkBufferDirty(), MaxOffsetNumber, 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().

6059 {
6060  Buffer buffer;
6061  Page page;
6062  OffsetNumber offnum;
6063  ItemId lp = NULL;
6064  HeapTupleHeader htup;
6065 
6066  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(&(tuple->t_self)));
6068  page = (Page) BufferGetPage(buffer);
6069 
6070  offnum = ItemPointerGetOffsetNumber(&(tuple->t_self));
6071  if (PageGetMaxOffsetNumber(page) >= offnum)
6072  lp = PageGetItemId(page, offnum);
6073 
6074  if (PageGetMaxOffsetNumber(page) < offnum || !ItemIdIsNormal(lp))
6075  elog(ERROR, "invalid lp");
6076 
6077  htup = (HeapTupleHeader) PageGetItem(page, lp);
6078 
6079  /* SpecTokenOffsetNumber should be distinguishable from any real offset */
6081  "invalid speculative token constant");
6082 
6083  /* NO EREPORT(ERROR) from here till changes are logged */
6085 
6087 
6088  MarkBufferDirty(buffer);
6089 
6090  /*
6091  * Replace the speculative insertion token with a real t_ctid, pointing to
6092  * itself like it does on regular tuples.
6093  */
6094  htup->t_ctid = tuple->t_self;
6095 
6096  /* XLOG stuff */
6097  if (RelationNeedsWAL(relation))
6098  {
6099  xl_heap_confirm xlrec;
6100  XLogRecPtr recptr;
6101 
6102  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
6103 
6104  XLogBeginInsert();
6105 
6106  /* We want the same filtering on this as on a plain insert */
6108 
6109  XLogRegisterData((char *) &xlrec, SizeOfHeapConfirm);
6110  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6111 
6112  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_CONFIRM);
6113 
6114  PageSetLSN(page, recptr);
6115  }
6116 
6117  END_CRIT_SECTION();
6118 
6119  UnlockReleaseBuffer(buffer);
6120 }
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:192
#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:763
#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
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:681
#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 6887 of file heapam.c.

References heap_execute_freeze_tuple(), and heap_prepare_freeze_tuple().

Referenced by rewrite_heap_tuple().

6889 {
6891  bool do_freeze;
6892  bool tuple_totally_frozen;
6893 
6894  do_freeze = heap_prepare_freeze_tuple(tuple, cutoff_xid, cutoff_multi,
6895  &frz, &tuple_totally_frozen);
6896 
6897  /*
6898  * Note that because this is not a WAL-logged operation, we don't need to
6899  * fill in the offset in the freeze record.
6900  */
6901 
6902  if (do_freeze)
6903  heap_execute_freeze_tuple(tuple, &frz);
6904  return do_freeze;
6905 }
void heap_execute_freeze_tuple(HeapTupleHeader tuple, xl_heap_freeze_tuple *frz)
Definition: heapam.c:6866
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:6673
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, HeapTupleHeaderIsOnlyLocked(), HeapTupleSatisfiesVisibility, HeapTupleUpdateXmaxMatchesXmin(), 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(), 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) &&
2263  !HeapTupleUpdateXmaxMatchesXmin(priorXmax, tp.t_data))
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:1605
#define ItemPointerIsValid(pointer)
Definition: itemptr.h:60
static void TestForOldSnapshot(Snapshot snapshot, Relation relation, Page page)
Definition: bufmgr.h:265
uint32 TransactionId
Definition: c.h:391
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:3945
#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
bool HeapTupleUpdateXmaxMatchesXmin(TransactionId xmax, HeapTupleHeader htup)
Definition: heapam.c:2304
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
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, HeapTupleHeaderIsHeapOnly, HeapTupleHeaderIsHotUpdated, HeapTupleUpdateXmaxMatchesXmin(), InvalidTransactionId, ItemIdGetRedirect, ItemIdIsDead, ItemIdIsNormal, ItemIdIsRedirected, ItemIdIsUsed, ItemPointerGetOffsetNumber, MaxHeapTuplesPerPage, MemSet, OffsetNumberNext, PageGetItem, PageGetItemId, PageGetMaxOffsetNumber, HeapTupleHeaderData::t_ctid, 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  !HeapTupleUpdateXmaxMatchesXmin(priorXmax, 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
uint32 TransactionId
Definition: c.h:391
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:863
#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
bool HeapTupleUpdateXmaxMatchesXmin(TransactionId xmax, HeapTupleHeader htup)
Definition: heapam.c:2304
#define Assert(condition)
Definition: c.h:681
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
#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 1808 of file heapam.c.

References HEAPDEBUG_1, HEAPDEBUG_2, HEAPDEBUG_3, heapgettup(), heapgettup_pagemode(), 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(), check_default_allows_bound(), copy_heap_data(), CopyTo(), createdb(), DefineQueryRewrite(), do_autovacuum(), DropSetting(), DropTableSpace(), find_typed_table_dependencies(), get_all_vacuum_rels(), get_database_list(), 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().

1809 {
1810  /* Note: no locking manipulations needed */
1811 
1812  HEAPDEBUG_1; /* heap_getnext( info ) */
1813 
1814  if (scan->rs_pageatatime)
1815  heapgettup_pagemode(scan, direction,
1816  scan->rs_nkeys, scan->rs_key);
1817  else
1818  heapgettup(scan, direction, scan->rs_nkeys, scan->rs_key);
1819 
1820  if (scan->rs_ctup.t_data == NULL)
1821  {
1822  HEAPDEBUG_2; /* heap_getnext returning EOS */
1823  return NULL;
1824  }
1825 
1826  /*
1827  * if we get here it means we have a new current scan tuple, so point to
1828  * the proper return buffer and return the tuple.
1829  */
1830  HEAPDEBUG_3; /* heap_getnext returning tuple */
1831 
1833 
1834  return &(scan->rs_ctup);
1835 }
#define HEAPDEBUG_2
Definition: heapam.c:1802
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:1801
static void heapgettup(HeapScanDesc scan, ScanDirection dir, int nkeys, ScanKey key)
Definition: heapam.c:481
Relation rs_rd
Definition: relscan.h:48
#define HEAPDEBUG_3
Definition: heapam.c:1803
#define pgstat_count_heap_getnext(rel)
Definition: pgstat.h:1265
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(), and ReleaseBuffer().

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
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:2011
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 2011 of file heapam.c.

References Assert, BufferGetBlockNumber(), BufferGetPage, CheckForSerializableConflictOut(), HeapTupleHeaderGetUpdateXid, HeapTupleIsHeapOnly, HeapTupleIsHotUpdated, HeapTupleIsSurelyDead(), HeapTupleSatisfiesVisibility, HeapTupleUpdateXmaxMatchesXmin(), 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, and TransactionIdIsValid.

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

2014 {
2015  Page dp = (Page) BufferGetPage(buffer);
2016  TransactionId prev_xmax = InvalidTransactionId;
2017  OffsetNumber offnum;
2018  bool at_chain_start;
2019  bool valid;
2020  bool skip;
2021 
2022  /* If this is not the first call, previous call returned a (live!) tuple */
2023  if (all_dead)
2024  *all_dead = first_call;
2025 
2027 
2029  offnum = ItemPointerGetOffsetNumber(tid);
2030  at_chain_start = first_call;
2031  skip = !first_call;
2032 
2033  heapTuple->t_self = *tid;
2034 
2035  /* Scan through possible multiple members of HOT-chain */
2036  for (;;)
2037  {
2038  ItemId lp;
2039 
2040  /* check for bogus TID */
2041  if (offnum < FirstOffsetNumber || offnum > PageGetMaxOffsetNumber(dp))
2042  break;
2043 
2044  lp = PageGetItemId(dp, offnum);
2045 
2046  /* check for unused, dead, or redirected items */
2047  if (!ItemIdIsNormal(lp))
2048  {
2049  /* We should only see a redirect at start of chain */
2050  if (ItemIdIsRedirected(lp) && at_chain_start)
2051  {
2052  /* Follow the redirect */
2053  offnum = ItemIdGetRedirect(lp);
2054  at_chain_start = false;
2055  continue;
2056  }
2057  /* else must be end of chain */
2058  break;
2059  }
2060 
2061  heapTuple->t_data = (HeapTupleHeader) PageGetItem(dp, lp);
2062  heapTuple->t_len = ItemIdGetLength(lp);
2063  heapTuple->t_tableOid = RelationGetRelid(relation);
2064  ItemPointerSetOffsetNumber(&heapTuple->t_self, offnum);
2065 
2066  /*
2067  * Shouldn't see a HEAP_ONLY tuple at chain start.
2068  */
2069  if (at_chain_start && HeapTupleIsHeapOnly(heapTuple))
2070  break;
2071 
2072  /*
2073  * The xmin should match the previous xmax value, else chain is
2074  * broken.
2075  */
2076  if (TransactionIdIsValid(prev_xmax) &&
2077  !HeapTupleUpdateXmaxMatchesXmin(prev_xmax, heapTuple->t_data))
2078  break;
2079 
2080  /*
2081  * When first_call is true (and thus, skip is initially false) we'll
2082  * return the first tuple we find. But on later passes, heapTuple
2083  * will initially be pointing to the tuple we returned last time.
2084  * Returning it again would be incorrect (and would loop forever), so
2085  * we skip it and return the next match we find.
2086  */
2087  if (!skip)
2088  {
2089  /*
2090  * For the benefit of logical decoding, have t_self point at the
2091  * element of the HOT chain we're currently investigating instead
2092  * of the root tuple of the HOT chain. This is important because
2093  * the *Satisfies routine for historical mvcc snapshots needs the
2094  * correct tid to decide about the visibility in some cases.
2095  */
2096  ItemPointerSet(&(heapTuple->t_self), BufferGetBlockNumber(buffer), offnum);
2097 
2098  /* If it's visible per the snapshot, we must return it */
2099  valid = HeapTupleSatisfiesVisibility(heapTuple, snapshot, buffer);
2100  CheckForSerializableConflictOut(valid, relation, heapTuple,
2101  buffer, snapshot);
2102  /* reset to original, non-redirected, tid */
2103  heapTuple->t_self = *tid;
2104 
2105  if (valid)
2106  {
2107  ItemPointerSetOffsetNumber(tid, offnum);
2108  PredicateLockTuple(relation, heapTuple, snapshot);
2109  if (all_dead)
2110  *all_dead = false;
2111  return true;
2112  }
2113  }
2114  skip = false;
2115 
2116  /*
2117  * If we can't see it, maybe no one else can either. At caller
2118  * request, check whether all chain members are dead to all
2119  * transactions.
2120  *
2121  * Note: if you change the criterion here for what is "dead", fix the
2122  * planner's get_actual_variable_range() function to match.
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
uint32 TransactionId
Definition: c.h:391
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:3945
bool HeapTupleIsSurelyDead(HeapTuple htup, TransactionId OldestXmin)
Definition: tqual.c:1429
#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
bool HeapTupleUpdateXmaxMatchesXmin(TransactionId xmax, HeapTupleHeader htup)
Definition: heapam.c:2304
#define HeapTupleIsHeapOnly(tuple)
Definition: htup_details.h:686
#define Assert(condition)
Definition: c.h:681
#define ItemIdIsNormal(itemId)
Definition: itemid.h:98
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
void PredicateLockTuple(Relation relation, HeapTuple tuple, Snapshot snapshot)
Definition: predicate.c:2543
#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 6290 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(), 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().

6291 {
6292  Buffer buffer;
6293  Page page;
6294  OffsetNumber offnum;
6295  ItemId lp = NULL;
6296  HeapTupleHeader htup;
6297  uint32 oldlen;
6298  uint32 newlen;
6299 
6300  /*
6301  * For now, parallel operations are required to be strictly read-only.
6302  * Unlike a regular update, this should never create a combo CID, so it
6303  * might be possible to relax this restriction, but not without more
6304  * thought and testing. It's not clear that it would be useful, anyway.
6305  */
6306  if (IsInParallelMode())
6307  ereport(ERROR,
6308  (errcode(ERRCODE_INVALID_TRANSACTION_STATE),
6309  errmsg("cannot update tuples during a parallel operation")));
6310 
6311  buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(&(tuple->t_self)));
6313  page = (Page) BufferGetPage(buffer);
6314 
6315  offnum = ItemPointerGetOffsetNumber(&(tuple->t_self));
6316  if (PageGetMaxOffsetNumber(page) >= offnum)
6317  lp = PageGetItemId(page, offnum);
6318 
6319  if (PageGetMaxOffsetNumber(page) < offnum || !ItemIdIsNormal(lp))
6320  elog(ERROR, "invalid lp");
6321 
6322  htup = (HeapTupleHeader) PageGetItem(page, lp);
6323 
6324  oldlen = ItemIdGetLength(lp) - htup->t_hoff;
6325  newlen = tuple->t_len - tuple->t_data->t_hoff;
6326  if (oldlen != newlen || htup->t_hoff != tuple->t_data->t_hoff)
6327  elog(ERROR, "wrong tuple length");
6328 
6329  /* NO EREPORT(ERROR) from here till changes are logged */
6331 
6332  memcpy((char *) htup + htup->t_hoff,
6333  (char *) tuple->t_data + tuple->t_data->t_hoff,
6334  newlen);
6335 
6336  MarkBufferDirty(buffer);
6337 
6338  /* XLOG stuff */
6339  if (RelationNeedsWAL(relation))
6340  {
6341  xl_heap_inplace xlrec;
6342  XLogRecPtr recptr;
6343 
6344  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
6345 
6346  XLogBeginInsert();
6347  XLogRegisterData((char *) &xlrec, SizeOfHeapInplace);
6348 
6349  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD);
6350  XLogRegisterBufData(0, (char *) htup + htup->t_hoff, newlen);
6351 
6352  /* inplace updates aren't decoded atm, don't log the origin */
6353 
6354  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_INPLACE);
6355 
6356  PageSetLSN(page, recptr);
6357  }
6358 
6359  END_CRIT_SECTION();
6360 
6361  UnlockReleaseBuffer(buffer);
6362 
6363  /*
6364  * Send out shared cache inval if necessary. Note that because we only
6365  * pass the new version of the tuple, this mustn't be used for any
6366  * operations that could change catcache lookup keys. But we aren't
6367  * bothering with index updates either, so that's true a fortiori.
6368  */
6370  CacheInvalidateHeapTuple(relation, tuple, NULL);
6371 }
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:906
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:258
#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
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:367
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 2456 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().

2458 {
2460  HeapTuple heaptup;
2461  Buffer buffer;
2462  Buffer vmbuffer = InvalidBuffer;
2463  bool all_visible_cleared = false;
2464 
2465  /*
2466  * Fill in tuple header fields, assign an OID, and toast the tuple if
2467  * necessary.
2468  *
2469  * Note: below this point, heaptup is the data we actually intend to store
2470  * into the relation; tup is the caller's original untoasted data.
2471  */
2472  heaptup = heap_prepare_insert(relation, tup, xid, cid, options);
2473 
2474  /*
2475  * Find buffer to insert this tuple into. If the page is all visible,
2476  * this will also pin the requisite visibility map page.
2477  */
2478  buffer = RelationGetBufferForTuple(relation, heaptup->t_len,
2479  InvalidBuffer, options, bistate,
2480  &vmbuffer, NULL);
2481 
2482  /*
2483  * We're about to do the actual insert -- but check for conflict first, to
2484  * avoid possibly having to roll back work we've just done.
2485  *
2486  * This is safe without a recheck as long as there is no possibility of
2487  * another process scanning the page between this check and the insert
2488  * being visible to the scan (i.e., an exclusive buffer content lock is
2489  * continuously held from this point until the tuple insert is visible).
2490  *
2491  * For a heap insert, we only need to check for table-level SSI locks. Our
2492  * new tuple can't possibly conflict with existing tuple locks, and heap
2493  * page locks are only consolidated versions of tuple locks; they do not
2494  * lock "gaps" as index page locks do. So we don't need to specify a
2495  * buffer when making the call, which makes for a faster check.
2496  */
2498 
2499  /* NO EREPORT(ERROR) from here till changes are logged */
2501 
2502  RelationPutHeapTuple(relation, buffer, heaptup,
2503  (options & HEAP_INSERT_SPECULATIVE) != 0);
2504 
2505  if (PageIsAllVisible(BufferGetPage(buffer)))
2506  {
2507  all_visible_cleared = true;
2509  visibilitymap_clear(relation,
2510  ItemPointerGetBlockNumber(&(heaptup->t_self)),
2511  vmbuffer, VISIBILITYMAP_VALID_BITS);
2512  }
2513 
2514  /*
2515  * XXX Should we set PageSetPrunable on this page ?
2516  *
2517  * The inserting transaction may eventually abort thus making this tuple
2518  * DEAD and hence available for pruning. Though we don't want to optimize
2519  * for aborts, if no other tuple in this page is UPDATEd/DELETEd, the
2520  * aborted tuple will never be pruned until next vacuum is triggered.
2521  *
2522  * If you do add PageSetPrunable here, add it in heap_xlog_insert too.
2523  */
2524 
2525  MarkBufferDirty(buffer);
2526 
2527  /* XLOG stuff */
2528  if (!(options & HEAP_INSERT_SKIP_WAL) && RelationNeedsWAL(relation))
2529  {
2530  xl_heap_insert xlrec;
2531  xl_heap_header xlhdr;
2532  XLogRecPtr recptr;
2533  Page page = BufferGetPage(buffer);
2534  uint8 info = XLOG_HEAP_INSERT;
2535  int bufflags = 0;
2536 
2537  /*
2538  * If this is a catalog, we need to transmit combocids to properly
2539  * decode, so log that as well.
2540  */
2542  log_heap_new_cid(relation, heaptup);
2543 
2544  /*
2545  * If this is the single and first tuple on page, we can reinit the
2546  * page instead of restoring the whole thing. Set flag, and hide
2547  * buffer references from XLogInsert.
2548  */
2549  if (ItemPointerGetOffsetNumber(&(heaptup->t_self)) == FirstOffsetNumber &&
2551  {
2552  info |= XLOG_HEAP_INIT_PAGE;
2553  bufflags |= REGBUF_WILL_INIT;
2554  }
2555 
2556  xlrec.offnum = ItemPointerGetOffsetNumber(&heaptup->t_self);
2557  xlrec.flags = 0;
2558  if (all_visible_cleared)
2563 
2564  /*
2565  * For logical decoding, we need the tuple even if we're doing a full
2566  * page write, so make sure it's included even if we take a full-page
2567  * image. (XXX We could alternatively store a pointer into the FPW).
2568  */
2569  if (RelationIsLogicallyLogged(relation))
2570  {
2572  bufflags |= REGBUF_KEEP_DATA;
2573  }
2574 
2575  XLogBeginInsert();
2576  XLogRegisterData((char *) &xlrec, SizeOfHeapInsert);
2577 
2578  xlhdr.t_infomask2 = heaptup->t_data->t_infomask2;
2579  xlhdr.t_infomask = heaptup->t_data->t_infomask;
2580  xlhdr.t_hoff = heaptup->t_data->t_hoff;
2581 
2582  /*
2583  * note we mark xlhdr as belonging to buffer; if XLogInsert decides to
2584  * write the whole page to the xlog, we don't need to store
2585  * xl_heap_header in the xlog.
2586  */
2587  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD | bufflags);
2588  XLogRegisterBufData(0, (char *) &xlhdr, SizeOfHeapHeader);
2589  /* PG73FORMAT: write bitmap [+ padding] [+ oid] + data */
2591  (char *) heaptup->t_data + SizeofHeapTupleHeader,
2592  heaptup->t_len - SizeofHeapTupleHeader);
2593 
2594  /* filtering by origin on a row level is much more efficient */
2596 
2597  recptr = XLogInsert(RM_HEAP_ID, info);
2598 
2599  PageSetLSN(page, recptr);
2600  }
2601 
2602  END_CRIT_SECTION();
2603 
2604  UnlockReleaseBuffer(buffer);
2605  if (vmbuffer != InvalidBuffer)
2606  ReleaseBuffer(vmbuffer);
2607 
2608  /*
2609  * If tuple is cachable, mark it for invalidation from the caches in case
2610  * we abort. Note it is OK to do this after releasing the buffer, because
2611  * the heaptup data structure is all in local memory, not in the shared
2612  * buffer.
2613  */
2614  CacheInvalidateHeapTuple(relation, heaptup, NULL);
2615 
2616  /* Note: speculative insertions are counted too, even if aborted later */
2617  pgstat_count_heap_insert(relation, 1);
2618 
2619  /*
2620  * If heaptup is a private copy, release it. Don't forget to copy t_self
2621  * back to the caller's image, too.
2622  */
2623  if (heaptup != tup)
2624  {
2625  tup->t_self = heaptup->t_self;
2626  heap_freetuple(heaptup);
2627  }
2628 
2629  return HeapTupleGetOid(tup);
2630 }
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:7812
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:2640
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:391
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:256
#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:192
#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:4326
#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:418
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
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:681
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 4603 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(), 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().

4607 {
4608  HTSU_Result result;
4609  ItemPointer tid = &(tuple->t_self);
4610  ItemId lp;
4611  Page page;
4612  Buffer vmbuffer = InvalidBuffer;
4613  BlockNumber block;
4614  TransactionId xid,
4615  xmax;
4616  uint16 old_infomask,
4617  new_infomask,
4618  new_infomask2;
4619  bool first_time = true;
4620  bool have_tuple_lock = false;
4621  bool cleared_all_frozen = false;
4622 
4623  *buffer = ReadBuffer(relation, ItemPointerGetBlockNumber(tid));
4624  block = ItemPointerGetBlockNumber(tid);
4625 
4626  /*
4627  * Before locking the buffer, pin the visibility map page if it appears to
4628  * be necessary. Since we haven't got the lock yet, someone else might be
4629  * in the middle of changing this, so we'll need to recheck after we have
4630  * the lock.
4631  */
4633  visibilitymap_pin(relation, block, &vmbuffer);
4634 
4636 
4637  page = BufferGetPage(*buffer);
4638  lp = PageGetItemId(page, ItemPointerGetOffsetNumber(tid));
4639  Assert(ItemIdIsNormal(lp));
4640 
4641  tuple->t_data = (HeapTupleHeader) PageGetItem(page, lp);
4642  tuple->t_len = ItemIdGetLength(lp);
4643  tuple->t_tableOid = RelationGetRelid(relation);
4644 
4645 l3:
4646  result = HeapTupleSatisfiesUpdate(tuple, cid, *buffer);
4647 
4648  if (result == HeapTupleInvisible)
4649  {
4650  /*
4651  * This is possible, but only when locking a tuple for ON CONFLICT
4652  * UPDATE. We return this value here rather than throwing an error in
4653  * order to give that case the opportunity to throw a more specific
4654  * error.
4655  */
4656  result = HeapTupleInvisible;
4657  goto out_locked;
4658  }
4659  else if (result == HeapTupleBeingUpdated || result == HeapTupleUpdated)
4660  {
4661  TransactionId xwait;
4662  uint16 infomask;
4663  uint16 infomask2;
4664  bool require_sleep;
4665  ItemPointerData t_ctid;
4666 
4667  /* must copy state data before unlocking buffer */
4668  xwait = HeapTupleHeaderGetRawXmax(tuple->t_data);
4669  infomask = tuple->t_data->t_infomask;
4670  infomask2 = tuple->t_data->t_infomask2;
4671  ItemPointerCopy(&tuple->t_data->t_ctid, &t_ctid);
4672 
4674 
4675  /*
4676  * If any subtransaction of the current top transaction already holds
4677  * a lock as strong as or stronger than what we're requesting, we
4678  * effectively hold the desired lock already. We *must* succeed
4679  * without trying to take the tuple lock, else we will deadlock
4680  * against anyone wanting to acquire a stronger lock.
4681  *
4682  * Note we only do this the first time we loop on the HTSU result;
4683  * there is no point in testing in subsequent passes, because
4684  * evidently our own transaction cannot have acquired a new lock after
4685  * the first time we checked.
4686  */
4687  if (first_time)
4688  {
4689  first_time = false;
4690 
4691  if (infomask & HEAP_XMAX_IS_MULTI)
4692  {
4693  int i;
4694  int nmembers;
4695  MultiXactMember *members;
4696 
4697  /*
4698  * We don't need to allow old multixacts here; if that had
4699  * been the case, HeapTupleSatisfiesUpdate would have returned
4700  * MayBeUpdated and we wouldn't be here.
4701  */
4702  nmembers =
4703  GetMultiXactIdMembers(xwait, &members, false,
4704  HEAP_XMAX_IS_LOCKED_ONLY(infomask));
4705 
4706  for (i = 0; i < nmembers; i++)
4707  {
4708  /* only consider members of our own transaction */
4709  if (!TransactionIdIsCurrentTransactionId(members[i].xid))
4710  continue;
4711 
4712  if (TUPLOCK_from_mxstatus(members[i].status) >= mode)
4713  {
4714  pfree(members);
4715  result = HeapTupleMayBeUpdated;
4716  goto out_unlocked;
4717  }
4718  }
4719 
4720  if (members)
4721  pfree(members);
4722  }
4723  else if (TransactionIdIsCurrentTransactionId(xwait))
4724  {
4725  switch (mode)
4726  {
4727  case LockTupleKeyShare:
4728  Assert(HEAP_XMAX_IS_KEYSHR_LOCKED(infomask) ||
4729  HEAP_XMAX_IS_SHR_LOCKED(infomask) ||
4730  HEAP_XMAX_IS_EXCL_LOCKED(infomask));
4731  result = HeapTupleMayBeUpdated;
4732  goto out_unlocked;
4733  case LockTupleShare:
4734  if (HEAP_XMAX_IS_SHR_LOCKED(infomask) ||
4735  HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4736  {
4737  result = HeapTupleMayBeUpdated;
4738  goto out_unlocked;
4739  }
4740  break;
4742  if (HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4743  {
4744  result = HeapTupleMayBeUpdated;
4745  goto out_unlocked;
4746  }
4747  break;
4748  case LockTupleExclusive:
4749  if (HEAP_XMAX_IS_EXCL_LOCKED(infomask) &&
4750  infomask2 & HEAP_KEYS_UPDATED)
4751  {
4752  result = HeapTupleMayBeUpdated;
4753  goto out_unlocked;
4754  }
4755  break;
4756  }
4757  }
4758  }
4759 
4760  /*
4761  * Initially assume that we will have to wait for the locking
4762  * transaction(s) to finish. We check various cases below in which
4763  * this can be turned off.
4764  */
4765  require_sleep = true;
4766  if (mode == LockTupleKeyShare)
4767  {
4768  /*
4769  * If we're requesting KeyShare, and there's no update present, we
4770  * don't need to wait. Even if there is an update, we can still
4771  * continue if the key hasn't been modified.
4772  *
4773  * However, if there are updates, we need to walk the update chain
4774  * to mark future versions of the row as locked, too. That way,
4775  * if somebody deletes that future version, we're protected
4776  * against the key going away. This locking of future versions
4777  * could block momentarily, if a concurrent transaction is
4778  * deleting a key; or it could return a value to the effect that
4779  * the transaction deleting the key has already committed. So we
4780  * do this before re-locking the buffer; otherwise this would be
4781  * prone to deadlocks.
4782  *
4783  * Note that the TID we're locking was grabbed before we unlocked
4784  * the buffer. For it to change while we're not looking, the
4785  * other properties we're testing for below after re-locking the
4786  * buffer would also change, in which case we would restart this
4787  * loop above.
4788  */
4789  if (!(infomask2 & HEAP_KEYS_UPDATED))
4790  {
4791  bool updated;
4792 
4793  updated = !HEAP_XMAX_IS_LOCKED_ONLY(infomask);
4794 
4795  /*
4796  * If there are updates, follow the update chain; bail out if
4797  * that cannot be done.
4798  */
4799  if (follow_updates && updated)
4800  {
4801  HTSU_Result res;
4802 
4803  res = heap_lock_updated_tuple(relation, tuple, &t_ctid,
4805  mode);
4806  if (res != HeapTupleMayBeUpdated)
4807  {
4808  result = res;
4809  /* recovery code expects to have buffer lock held */
4811  goto failed;
4812  }
4813  }
4814 
4816 
4817  /*
4818  * Make sure it's still an appropriate lock, else start over.
4819  * Also, if it wasn't updated before we released the lock, but
4820  * is updated now, we start over too; the reason is that we
4821  * now need to follow the update chain to lock the new
4822  * versions.
4823  */
4824  if (!HeapTupleHeaderIsOnlyLocked(tuple->t_data) &&
4825  ((tuple->t_data->t_infomask2 & HEAP_KEYS_UPDATED) ||
4826  !updated))
4827  goto l3;
4828 
4829  /* Things look okay, so we can skip sleeping */
4830  require_sleep = false;
4831 
4832  /*
4833  * Note we allow Xmax to change here; other updaters/lockers
4834  * could have modified it before we grabbed the buffer lock.
4835  * However, this is not a problem, because with the recheck we
4836  * just did we ensure that they still don't conflict with the
4837  * lock we want.
4838  */
4839  }
4840  }
4841  else if (mode == LockTupleShare)
4842  {
4843  /*
4844  * If we're requesting Share, we can similarly avoid sleeping if
4845  * there's no update and no exclusive lock present.
4846  */
4847  if (HEAP_XMAX_IS_LOCKED_ONLY(infomask) &&
4848  !HEAP_XMAX_IS_EXCL_LOCKED(infomask))
4849  {
4851 
4852  /*
4853  * Make sure it's still an appropriate lock, else start over.
4854  * See above about allowing xmax to change.
4855  */
4856  if (!HEAP_XMAX_IS_LOCKED_ONLY(tuple->t_data->t_infomask) ||
4858  goto l3;
4859  require_sleep = false;
4860  }
4861  }
4862  else if (mode == LockTupleNoKeyExclusive)
4863  {
4864  /*
4865  * If we're requesting NoKeyExclusive, we might also be able to
4866  * avoid sleeping; just ensure that there no conflicting lock
4867  * already acquired.
4868  */
4869  if (infomask & HEAP_XMAX_IS_MULTI)
4870  {
4871  if (!DoesMultiXactIdConflict((MultiXactId) xwait, infomask,
4872  mode))
4873  {
4874  /*
4875  * No conflict, but if the xmax changed under us in the
4876  * meantime, start over.
4877  */
4879  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4881  xwait))
4882  goto l3;
4883 
4884  /* otherwise, we're good */
4885  require_sleep = false;
4886  }
4887  }
4888  else if (HEAP_XMAX_IS_KEYSHR_LOCKED(infomask))
4889  {
4891 
4892  /* if the xmax changed in the meantime, start over */
4893  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4896  xwait))
4897  goto l3;
4898  /* otherwise, we're good */
4899  require_sleep = false;
4900  }
4901  }
4902 
4903  /*
4904  * As a check independent from those above, we can also avoid sleeping
4905  * if the current transaction is the sole locker of the tuple. Note
4906  * that the strength of the lock already held is irrelevant; this is
4907  * not about recording the lock in Xmax (which will be done regardless
4908  * of this optimization, below). Also, note that the cases where we
4909  * hold a lock stronger than we are requesting are already handled
4910  * above by not doing anything.
4911  *
4912  * Note we only deal with the non-multixact case here; MultiXactIdWait
4913  * is well equipped to deal with this situation on its own.
4914  */
4915  if (require_sleep && !(infomask & HEAP_XMAX_IS_MULTI) &&
4917  {
4918  /* ... but if the xmax changed in the meantime, start over */
4920  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
4922  xwait))
4923  goto l3;
4925  require_sleep = false;
4926  }
4927 
4928  /*
4929  * Time to sleep on the other transaction/multixact, if necessary.
4930  *
4931  * If the other transaction is an update that's already committed,
4932  * then sleeping cannot possibly do any good: if we're required to
4933  * sleep, get out to raise an error instead.
4934  *
4935  * By here, we either have already acquired the buffer exclusive lock,
4936  * or we must wait for the locking transaction or multixact; so below
4937  * we ensure that we grab buffer lock after the sleep.
4938  */
4939  if (require_sleep && result == HeapTupleUpdated)
4940  {
4942  goto failed;
4943  }
4944  else if (require_sleep)
4945  {
4946  /*
4947  * Acquire tuple lock to establish our priority for the tuple, or
4948  * die trying. LockTuple will release us when we are next-in-line
4949  * for the tuple. We must do this even if we are share-locking.
4950  *
4951  * If we are forced to "start over" below, we keep the tuple lock;
4952  * this arranges that we stay at the head of the line while
4953  * rechecking tuple state.
4954  */
4955  if (!heap_acquire_tuplock(relation, tid, mode, wait_policy,
4956  &have_tuple_lock))
4957  {
4958  /*
4959  * This can only happen if wait_policy is Skip and the lock
4960  * couldn't be obtained.
4961  */
4962  result = HeapTupleWouldBlock;
4963  /* recovery code expects to have buffer lock held */
4965  goto failed;
4966  }
4967 
4968  if (infomask & HEAP_XMAX_IS_MULTI)
4969  {
4971 
4972  /* We only ever lock tuples, never update them */
4973  if (status >= MultiXactStatusNoKeyUpdate)
4974  elog(ERROR, "invalid lock mode in heap_lock_tuple");
4975 
4976  /* wait for multixact to end, or die trying */
4977  switch (wait_policy)
4978  {
4979  case LockWaitBlock:
4980  MultiXactIdWait((MultiXactId) xwait, status, infomask,
4981  relation, &tuple->t_self, XLTW_Lock, NULL);
4982  break;
4983  case LockWaitSkip:
4985  status, infomask, relation,
4986  NULL))
4987  {
4988  result = HeapTupleWouldBlock;
4989  /* recovery code expects to have buffer lock held */
4991  goto failed;
4992  }
4993  break;
4994  case LockWaitError:
4996  status, infomask, relation,
4997  NULL))
4998  ereport(ERROR,
4999  (errcode(ERRCODE_LOCK_NOT_AVAILABLE),
5000  errmsg("could not obtain lock on row in relation \"%s\"",
5001  RelationGetRelationName(relation))));
5002 
5003  break;
5004  }
5005 
5006  /*
5007  * Of course, the multixact might not be done here: if we're
5008  * requesting a light lock mode, other transactions with light
5009  * locks could still be alive, as well as locks owned by our
5010  * own xact or other subxacts of this backend. We need to
5011  * preserve the surviving MultiXact members. Note that it
5012  * isn't absolutely necessary in the latter case, but doing so
5013  * is simpler.
5014  */
5015  }
5016  else
5017  {
5018  /* wait for regular transaction to end, or die trying */
5019  switch (wait_policy)
5020  {
5021  case LockWaitBlock:
5022  XactLockTableWait(xwait, relation, &tuple->t_self,
5023  XLTW_Lock);
5024  break;
5025  case LockWaitSkip:
5026  if (!ConditionalXactLockTableWait(xwait))
5027  {
5028  result = HeapTupleWouldBlock;
5029  /* recovery code expects to have buffer lock held */
5031  goto failed;
5032  }
5033  break;
5034  case LockWaitError:
5035  if (!ConditionalXactLockTableWait(xwait))
5036  ereport(ERROR,
5037  (errcode(ERRCODE_LOCK_NOT_AVAILABLE),
5038  errmsg("could not obtain lock on row in relation \"%s\"",
5039  RelationGetRelationName(relation))));
5040  break;
5041  }
5042  }
5043 
5044  /* if there are updates, follow the update chain */
5045  if (follow_updates && !HEAP_XMAX_IS_LOCKED_ONLY(infomask))
5046  {
5047  HTSU_Result res;
5048 
5049  res = heap_lock_updated_tuple(relation, tuple, &t_ctid,
5051  mode);
5052  if (res != HeapTupleMayBeUpdated)
5053  {
5054  result = res;
5055  /* recovery code expects to have buffer lock held */
5057  goto failed;
5058  }
5059  }
5060 
5062 
5063  /*
5064  * xwait is done, but if xwait had just locked the tuple then some
5065  * other xact could update this tuple before we get to this point.
5066  * Check for xmax change, and start over if so.
5067  */
5068  if (xmax_infomask_changed(tuple->t_data->t_infomask, infomask) ||
5070  xwait))
5071  goto l3;
5072 
5073  if (!(infomask & HEAP_XMAX_IS_MULTI))
5074  {
5075  /*
5076  * Otherwise check if it committed or aborted. Note we cannot
5077  * be here if the tuple was only locked by somebody who didn't
5078  * conflict with us; that would have been handled above. So
5079  * that transaction must necessarily be gone by now. But
5080  * don't check for this in the multixact case, because some
5081  * locker transactions might still be running.
5082  */
5083  UpdateXmaxHintBits(tuple->t_data, *buffer, xwait);
5084  }
5085  }
5086 
5087  /* By here, we're certain that we hold buffer exclusive lock again */
5088 
5089  /*
5090  * We may lock if previous xmax aborted, or if it committed but only
5091  * locked the tuple without updating it; or if we didn't have to wait
5092  * at all for whatever reason.
5093  */
5094  if (!require_sleep ||
5095  (tuple->t_data->t_infomask & HEAP_XMAX_INVALID) ||
5098  result = HeapTupleMayBeUpdated;
5099  else
5100  result = HeapTupleUpdated;
5101  }
5102 
5103 failed:
5104  if (result != HeapTupleMayBeUpdated)
5105  {
5106  Assert(result == HeapTupleSelfUpdated || result == HeapTupleUpdated ||
5107  result == HeapTupleWouldBlock);
5108  Assert(!(tuple->t_data->t_infomask & HEAP_XMAX_INVALID));
5109  hufd->ctid = tuple->t_data->t_ctid;
5110  hufd->xmax = HeapTupleHeaderGetUpdateXid(tuple->t_data);
5111  if (result == HeapTupleSelfUpdated)
5112  hufd->cmax = HeapTupleHeaderGetCmax(tuple->t_data);
5113  else
5114  hufd->cmax = InvalidCommandId;
5115  goto out_locked;
5116  }
5117 
5118  /*
5119  * If we didn't pin the visibility map page and the page has become all
5120  * visible while we were busy locking the buffer, or during some
5121  * subsequent window during which we had it unlocked, we'll have to unlock
5122  * and re-lock, to avoid holding the buffer lock across I/O. That's a bit
5123  * unfortunate, especially since we'll now have to recheck whether the
5124  * tuple has been locked or updated under us, but hopefully it won't
5125  * happen very often.
5126  */
5127  if (vmbuffer == InvalidBuffer && PageIsAllVisible(page))
5128  {
5130  visibilitymap_pin(relation, block, &vmbuffer);
5132  goto l3;
5133  }
5134 
5135  xmax = HeapTupleHeaderGetRawXmax(tuple->t_data);
5136  old_infomask = tuple->t_data->t_infomask;
5137 
5138  /*
5139  * If this is the first possibly-multixact-able operation in the current
5140  * transaction, set my per-backend OldestMemberMXactId setting. We can be
5141  * certain that the transaction will never become a member of any older
5142  * MultiXactIds than that. (We have to do this even if we end up just
5143  * using our own TransactionId below, since some other backend could
5144  * incorporate our XID into a MultiXact immediately afterwards.)
5145  */
5147 
5148  /*
5149  * Compute the new xmax and infomask to store into the tuple. Note we do
5150  * not modify the tuple just yet, because that would leave it in the wrong
5151  * state if multixact.c elogs.
5152  */
5153  compute_new_xmax_infomask(xmax, old_infomask, tuple->t_data->t_infomask2,
5154  GetCurrentTransactionId(), mode, false,
5155  &xid, &new_infomask, &new_infomask2);
5156 
5158 
5159  /*
5160  * Store transaction information of xact locking the tuple.
5161  *
5162  * Note: Cmax is meaningless in this context, so don't set it; this avoids
5163  * possibly generating a useless combo CID. Moreover, if we're locking a
5164  * previously updated tuple, it's important to preserve the Cmax.
5165  *
5166  * Also reset the HOT UPDATE bit, but only if there's no update; otherwise
5167  * we would break the HOT chain.
5168  */
5169  tuple->t_data->t_infomask &= ~HEAP_XMAX_BITS;
5170  tuple->t_data->t_infomask2 &= ~HEAP_KEYS_UPDATED;
5171  tuple->t_data->t_infomask |= new_infomask;
5172  tuple->t_data->t_infomask2 |= new_infomask2;
5173  if (HEAP_XMAX_IS_LOCKED_ONLY(new_infomask))
5175  HeapTupleHeaderSetXmax(tuple->t_data, xid);
5176 
5177  /*
5178  * Make sure there is no forward chain link in t_ctid. Note that in the
5179  * cases where the tuple has been updated, we must not overwrite t_ctid,
5180  * because it was set by the updater. Moreover, if the tuple has been
5181  * updated, we need to follow the update chain to lock the new versions of
5182  * the tuple as well.
5183  */
5184  if (HEAP_XMAX_IS_LOCKED_ONLY(new_infomask))
5185  tuple->t_data->t_ctid = *tid;
5186 
5187  /* Clear only the all-frozen bit on visibility map if needed */
5188  if (PageIsAllVisible(page) &&
5189  visibilitymap_clear(relation, block, vmbuffer,
5191  cleared_all_frozen = true;
5192 
5193 
5195 
5196  /*
5197  * XLOG stuff. You might think that we don't need an XLOG record because
5198  * there is no state change worth restoring after a crash. You would be
5199  * wrong however: we have just written either a TransactionId or a
5200  * MultiXactId that may never have been seen on disk before, and we need
5201  * to make sure that there are XLOG entries covering those ID numbers.
5202  * Else the same IDs might be re-used after a crash, which would be
5203  * disastrous if this page made it to disk before the crash. Essentially
5204  * we have to enforce the WAL log-before-data rule even in this case.
5205  * (Also, in a PITR log-shipping or 2PC environment, we have to have XLOG
5206  * entries for everything anyway.)
5207  */
5208  if (RelationNeedsWAL(relation))
5209  {
5210  xl_heap_lock xlrec;
5211  XLogRecPtr recptr;
5212 
5213  XLogBeginInsert();
5215 
5216  xlrec.offnum = ItemPointerGetOffsetNumber(&tuple->t_self);
5217  xlrec.locking_xid = xid;
5218  xlrec.infobits_set = compute_infobits(new_infomask,
5219  tuple->t_data->t_infomask2);
5220  xlrec.flags = cleared_all_frozen ? XLH_LOCK_ALL_FROZEN_CLEARED : 0;
5221  XLogRegisterData((char *) &xlrec, SizeOfHeapLock);
5222 
5223  /* we don't decode row locks atm, so no need to log the origin */
5224 
5225  recptr = XLogInsert(RM_HEAP_ID, XLOG_HEAP_LOCK);
5226 
5227  PageSetLSN(page, recptr);
5228  }
5229 
5230  END_CRIT_SECTION();
5231 
5232  result = HeapTupleMayBeUpdated;
5233 
5234 out_locked:
5236 
5237 out_unlocked:
5238  if (BufferIsValid(vmbuffer))
5239  ReleaseBuffer(vmbuffer);
5240 
5241  /*
5242  * Don't update the visibility map here. Locking a tuple doesn't change
5243  * visibility info.
5244  */
5245 
5246  /*
5247  * Now that we have successfully marked the tuple as locked, we can
5248  * release the lmgr tuple lock, if we had it.
5249  */
5250  if (have_tuple_lock)
5251  UnlockTupleTuplock(relation, tid, mode);
5252 
5253  return result;
5254 }
#define HeapTupleHeaderGetUpdateXid(tup)
Definition: htup_details.h:359
bool HeapTupleHeaderIsOnlyLocked(HeapTupleHeader tuple)
Definition: tqual.c:1605
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:3014
#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:391
HTSU_Result HeapTupleSatisfiesUpdate(HeapTuple htup, CommandId curcid, Buffer buffer)
Definition: tqual.c:460
bool TransactionIdIsCurrentTransactionId(TransactionId xid)
Definition: xact.c:766
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:3036
#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
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:257
void pfree(void *pointer)
Definition: mcxt.c:949
#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:7228
TransactionId GetCurrentTransactionId(void)
Definition: xact.c:418
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:121
#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:5318
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:408
#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:2357
static bool heap_acquire_tuplock(Relation relation, ItemPointer tid, LockTupleMode mode, LockWaitPolicy wait_policy, bool *have_tuple_lock)
Definition: heapam.c:5269
TransactionId MultiXactId
Definition: c.h:401
void XactLockTableWait(TransactionId xid, Relation rel, ItemPointer ctid, XLTW_Oper oper)
Definition: lmgr.c:554
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:681
Definition: lmgr.h:29
CommandId HeapTupleHeaderGetCmax(HeapTupleHeader tup)
Definition: combocid.c:119
static bool DoesMultiXactIdConflict(MultiXactId multi, uint16 infomask, LockTupleMode lockmode)
Definition: heapam.c:7061
#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:6018
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:4550
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:225
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:7250
#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 2720 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, 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().

2722 {
2724  HeapTuple *heaptuples;
2725  int i;
2726  int ndone;
2727  char *scratch = NULL;
2728  Page page;
2729  bool needwal;
2730  Size saveFreeSpace;
2731  bool need_tuple_data = RelationIsLogicallyLogged(relation);
2732  bool need_cids = RelationIsAccessibleInLogicalDecoding(relation);
2733 
2734  needwal = !(options & HEAP_INSERT_SKIP_WAL) && RelationNeedsWAL(relation);
2735  saveFreeSpace = RelationGetTargetPageFreeSpace(relation,
2737 
2738  /* Toast and set header data in all the tuples */
2739  heaptuples = palloc(ntuples * sizeof(HeapTuple));
2740  for (i = 0; i < ntuples; i++)
2741  heaptuples[i] = heap_prepare_insert(relation, tuples[i],
2742  xid, cid, options);
2743 
2744  /*
2745  * Allocate some memory to use for constructing the WAL record. Using
2746  * palloc() within a critical section is not safe, so we allocate this
2747  * beforehand.
2748  */
2749  if (needwal)
2750  scratch = palloc(BLCKSZ);
2751 
2752  /*
2753  * We're about to do the actual inserts -- but check for conflict first,
2754  * to minimize the possibility of having to roll back work we've just
2755  * done.
2756  *
2757  * A check here does not definitively prevent a serialization anomaly;
2758  * that check MUST be done at least past the point of acquiring an
2759  * exclusive buffer content lock on every buffer that will be affected,
2760  * and MAY be done after all inserts are reflected in the buffers and
2761  * those locks are released; otherwise there race condition. Since
2762  * multiple buffers can be locked and unlocked in the loop below, and it
2763  * would not be feasible to identify and lock all of those buffers before
2764  * the loop, we must do a final check at the end.
2765  *
2766  * The check here could be omitted with no loss of correctness; it is
2767  * present strictly as an optimization.
2768  *
2769  * For heap inserts, we only need to check for table-level SSI locks. Our
2770  * new tuples can't possibly conflict with existing tuple locks, and heap
2771  * page locks are only consolidated versions of tuple locks; they do not
2772  * lock "gaps" as index page locks do. So we don't need to specify a
2773  * buffer when making the call, which makes for a faster check.
2774  */
2776 
2777  ndone = 0;
2778  while (ndone < ntuples)
2779  {
2780  Buffer buffer;
2781  Buffer vmbuffer = InvalidBuffer;
2782  bool all_visible_cleared = false;
2783  int nthispage;
2784 
2786 
2787  /*
2788  * Find buffer where at least the next tuple will fit. If the page is
2789  * all-visible, this will also pin the requisite visibility map page.
2790  */
2791  buffer = RelationGetBufferForTuple(relation, heaptuples[ndone]->t_len,
2792  InvalidBuffer, options, bistate,
2793  &vmbuffer, NULL);
2794  page = BufferGetPage(buffer);
2795 
2796  /* NO EREPORT(ERROR) from here till changes are logged */
2798 
2799  /*
2800  * RelationGetBufferForTuple has ensured that the first tuple fits.
2801  * Put that on the page, and then as many other tuples as fit.
2802  */
2803  RelationPutHeapTuple(relation, buffer, heaptuples[ndone], false);
2804  for (nthispage = 1; ndone + nthispage < ntuples; nthispage++)
2805  {
2806  HeapTuple heaptup = heaptuples[ndone + nthispage];
2807 
2808  if (PageGetHeapFreeSpace(page) < MAXALIGN(heaptup->t_len) + saveFreeSpace)
2809  break;
2810 
2811  RelationPutHeapTuple(relation, buffer, heaptup, false);
2812 
2813  /*
2814  * We don't use heap_multi_insert for catalog tuples yet, but
2815  * better be prepared...
2816  */
2817  if (needwal && need_cids)
2818  log_heap_new_cid(relation, heaptup);
2819  }
2820 
2821  if (PageIsAllVisible(page))
2822  {
2823  all_visible_cleared = true;
2824  PageClearAllVisible(page);
2825  visibilitymap_clear(relation,
2826  BufferGetBlockNumber(buffer),
2827  vmbuffer, VISIBILITYMAP_VALID_BITS);
2828  }
2829 
2830  /*
2831  * XXX Should we set PageSetPrunable on this page ? See heap_insert()
2832  */
2833 
2834  MarkBufferDirty(buffer);
2835 
2836  /* XLOG stuff */
2837  if (needwal)
2838  {
2839  XLogRecPtr recptr;
2840  xl_heap_multi_insert *xlrec;
2842  char *tupledata;
2843  int totaldatalen;
2844  char *scratchptr = scratch;
2845  bool init;
2846  int bufflags = 0;
2847 
2848  /*
2849  * If the page was previously empty, we can reinit the page
2850  * instead of restoring the whole thing.
2851  */
2852  init = (ItemPointerGetOffsetNumber(&(heaptuples[ndone]->t_self)) == FirstOffsetNumber &&
2853  PageGetMaxOffsetNumber(page) == FirstOffsetNumber + nthispage - 1);
2854 
2855  /* allocate xl_heap_multi_insert struct from the scratch area */
2856  xlrec = (xl_heap_multi_insert *) scratchptr;
2857  scratchptr += SizeOfHeapMultiInsert;
2858 
2859  /*
2860  * Allocate offsets array. Unless we're reinitializing the page,
2861  * in that case the tuples are stored in order starting at
2862  * FirstOffsetNumber and we don't need to store the offsets
2863  * explicitly.
2864  */
2865  if (!init)
2866  scratchptr += nthispage * sizeof(OffsetNumber);
2867 
2868  /* the rest of the scratch space is used for tuple data */
2869  tupledata = scratchptr;
2870 
2871  xlrec->flags = all_visible_cleared ? XLH_INSERT_ALL_VISIBLE_CLEARED : 0;
2872  xlrec->ntuples = nthispage;
2873 
2874  /*
2875  * Write out an xl_multi_insert_tuple and the tuple data itself
2876  * for each tuple.
2877  */
2878  for (i = 0; i < nthispage; i++)
2879  {
2880  HeapTuple heaptup = heaptuples[ndone + i];
2881  xl_multi_insert_tuple *tuphdr;
2882  int datalen;
2883 
2884  if (!init)
2885  xlrec->offsets[i] = ItemPointerGetOffsetNumber(&heaptup->t_self);
2886  /* xl_multi_insert_tuple needs two-byte alignment. */
2887  tuphdr = (xl_multi_insert_tuple *) SHORTALIGN(scratchptr);
2888  scratchptr = ((char *) tuphdr) + SizeOfMultiInsertTuple;
2889 
2890  tuphdr->t_infomask2 = heaptup->t_data->t_infomask2;
2891  tuphdr->t_infomask = heaptup->t_data->t_infomask;
2892  tuphdr->t_hoff = heaptup->t_data->t_hoff;
2893 
2894  /* write bitmap [+ padding] [+ oid] + data */
2895  datalen = heaptup->t_len - SizeofHeapTupleHeader;
2896  memcpy(scratchptr,
2897  (char *) heaptup->t_data + SizeofHeapTupleHeader,
2898  datalen);
2899  tuphdr->datalen = datalen;
2900  scratchptr += datalen;
2901  }
2902  totaldatalen = scratchptr - tupledata;
2903  Assert((scratchptr - scratch) < BLCKSZ);
2904 
2905  if (need_tuple_data)
2907 
2908  /*
2909  * Signal that this is the last xl_heap_multi_insert record
2910  * emitted by this call to heap_multi_insert(). Needed for logical
2911  * decoding so it knows when to cleanup temporary data.
2912  */
2913  if (ndone + nthispage == ntuples)
2914  xlrec->flags |= XLH_INSERT_LAST_IN_MULTI;
2915 
2916  if (init)
2917  {
2918  info |= XLOG_HEAP_INIT_PAGE;
2919  bufflags |= REGBUF_WILL_INIT;
2920  }
2921 
2922  /*
2923  * If we're doing logical decoding, include the new tuple data
2924  * even if we take a full-page image of the page.
2925  */
2926  if (need_tuple_data)
2927  bufflags |= REGBUF_KEEP_DATA;
2928 
2929  XLogBeginInsert();
2930  XLogRegisterData((char *) xlrec, tupledata - scratch);
2931  XLogRegisterBuffer(0, buffer, REGBUF_STANDARD | bufflags);
2932 
2933  XLogRegisterBufData(0, tupledata, totaldatalen);
2934 
2935  /* filtering by origin on a row level is much more efficient */
2937 
2938  recptr = XLogInsert(RM_HEAP2_ID, info);
2939 
2940  PageSetLSN(page, recptr);
2941  }
2942 
2943  END_CRIT_SECTION();
2944 
2945  UnlockReleaseBuffer(buffer);
2946  if (vmbuffer != InvalidBuffer)
2947  ReleaseBuffer(vmbuffer);
2948 
2949  ndone += nthispage;
2950  }
2951 
2952  /*
2953  * We're done with the actual inserts. Check for conflicts again, to
2954  * ensure that all rw-conflicts in to these inserts are detected. Without
2955  * this final check, a sequential scan of the heap may have locked the
2956  * table after the "before" check, missing one opportunity to detect the
2957  * conflict, and then scanned the table before the new tuples were there,
2958  * missing the other chance to detect the conflict.
2959  *
2960  * For heap inserts, we only need to check for table-level SSI locks. Our
2961  * new tuples can't possibly conflict with existing tuple locks, and heap
2962  * page locks are only consolidated versions of tuple locks; they do not
2963  * lock "gaps" as index page locks do. So we don't need to specify a
2964  * buffer when making the call.
2965  */
2967 
2968  /*
2969  * If tuples are cachable, mark them for invalidation from the caches in
2970  * case we abort. Note it is OK to do this after releasing the buffer,
2971  * because the heaptuples data structure is all in local memory, not in
2972  * the shared buffer.
2973  */
2974  if (IsCatalogRelation(relation))
2975  {
2976  for (i = 0; i < ntuples; i++)
2977  CacheInvalidateHeapTuple(relation, heaptuples[i], NULL);
2978  }
2979 
2980  /*
2981  * Copy t_self fields back to the caller's original tuples. This does
2982  * nothing for untoasted tuples (tuples[i] == heaptuples[i)], but it's
2983  * probably faster to always copy than check.
2984  */
2985  for (i = 0; i < ntuples; i++)
2986  tuples[i]->t_self = heaptuples[i]->t_self;
2987 
2988  pgstat_count_heap_insert(relation, ntuples);
2989 }
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:7812
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:2640
#define PageIsAllVisible(page)
Definition: bufpage.h:381
uint32 TransactionId
Definition: c.h:391
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:256
#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:192
#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:4326
#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:418
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
uint64 XLogRecPtr
Definition: xlogdefs.h:21
#define Assert(condition)
Definition: c.h:681
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214
size_t Size
Definition: c.h:350
#define MAXALIGN(LEN)
Definition: c.h:576
#define ItemPointerGetOffsetNumber(pointer)
Definition: itemptr.h:95
static void init(bool is_no_vacuum)
Definition: pgbench.c:2606
#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:848
int i
#define CHECK_FOR_INTERRUPTS()
Definition: miscadmin.h:98
#define HEAP_DEFAULT_FILLFACTOR
Definition: rel.h:286
#define SHORTALIGN(LEN)
Definition: c.h:572
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_default_allows_bound(), 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_partitioned_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_all_vacuum_rels(), 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_dispatch_recurse(), get_partition_parent(), get_partition_qual_relid(), get_pkey_attnames(), get_primary_key_attnos(), 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(), 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(), SearchCatCacheList(), SearchCatCacheMiss(), 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(), update_default_partition_oid(), 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
#define START_CRIT_SECTION()
Definition: miscadmin.h:131
OffsetNumber nowdead[MaxHeapTuplesPerPage]
Definition: pruneheap.c:40
#define ItemIdIsDead(itemId)
Definition: itemid.h:112
bool marked[MaxHeapTuplesPerPage+1]
Definition: pruneheap.c:43
#define PageGetMaxOffsetNumber(page)
Definition: bufpage.h:353
TransactionId new_prune_xid
Definition: pruneheap.c:33
#define PageIsFull(page)
Definition: bufpage.h:374
int nunused
Definition: pruneheap.c:37
uint16 OffsetNumber
Definition: off.h:24
TransactionId latestRemovedXid
Definition: pruneheap.c:34
#define FirstOffsetNumber
Definition: off.h:27
#define InvalidTransactionId
Definition: transam.h:31
static TransactionId OldestXmin
Definition: vacuumlazy.c:138
#define BufferGetPage(buffer)
Definition: bufmgr.h:160
#define PageClearFull(page)
Definition: bufpage.h:378
#define PageGetItemId(page, offsetNumber)
Definition: bufpage.h:231
void heap_page_prune_execute(Buffer buffer, OffsetNumber *redirected, int nredirected, OffsetNumber *nowdead, int ndead, OffsetNumber *nowunused, int nunused)
Definition: pruneheap.c:679
PageHeaderData * PageHeader
Definition: bufpage.h:162
uint64 XLogRecPtr
Definition: xlogdefs.h:21
WalTimeSample buffer[LAG_TRACKER_BUFFER_SIZE]
Definition: walsender.c:214