非互換
FUJITSU Enterprise Postgres 13では、以下のとおり、統計情報ビューpg_stat_activityにおける待機イベント名の変更、追加、削除をします。
待機イベントタイプ | 待機イベント名 | |
|---|---|---|
FUJITSU Enterprise Postgres 12以前 | FUJITSU Enterprise Postgres 13 | |
LWLock | ShmemIndexLock | ShmemIndex |
OidGenLock | OidGen | |
XidGenLock | XidGen | |
ProcArrayLock | ProcArray | |
SInvalReadLock | SInvalRead | |
SInvalWriteLock | SInvalWrite | |
WALBufMappingLock | WALBufMapping | |
WALWriteLock | WALWrite | |
ControlFileLock | ControlFile | |
CheckpointLock | Checkpoint | |
CLogControlLock | XactSLRU | |
SubtransControlLock | SubtransSLRU | |
MultiXactGenLock | MultiXactGen | |
MultiXactOffsetControlLock | MultiXactOffsetSLRU | |
MultiXactMemberControlLock | MultiXactMemberSLRU | |
RelCacheInitLock | RelCacheInit | |
CheckpointerCommLock | CheckpointerComm | |
TwoPhaseStateLock | TwoPhaseState | |
TablespaceCreateLock | TablespaceCreate | |
BtreeVacuumLock | BtreeVacuum | |
AddinShmemInitLock | AddinShmemInit | |
AutovacuumLock | Autovacuum | |
AutovacuumScheduleLock | AutovacuumSchedule | |
SyncScanLock | SyncScan | |
RelationMappingLock | RelationMapping | |
AsyncCtlLock | NotifySLRU | |
AsyncQueueLock | NotifyQueue | |
SerializableXactHashLock | SerializableXactHash | |
SerializableFinishedListLock | SerializableFinishedList | |
SerializablePredicateLockListLock | SerializablePredicateList | |
OldSerXidLock | SerialSLRU | |
SyncRepLock | SyncRep | |
BackgroundWorkerLock | BackgroundWorker | |
DynamicSharedMemoryControlLock | DynamicSharedMemoryControl | |
AutoFileLock | AutoFile | |
ReplicationSlotAllocationLock | ReplicationSlotAllocation | |
ReplicationSlotControlLock | ReplicationSlotControl | |
CommitTsControlLock | CommitTsSLRU | |
CommitTsLock | CommitTs | |
ReplicationOriginLock | ReplicationOrigin | |
MultiXactTruncationLock | MultiXactTruncation | |
OldSnapshotTimeMapLock | OldSnapshotTimeMap | |
LogicalRepWorkerLock | LogicalRepWorker | |
CLogTruncationLock | XactTruncation | |
clog | XactBuffer | |
commit_timestamp | CommitTSBuffer | |
subtrans | SubtransBuffer | |
multixact_offset | MultiXactOffsetBuffer | |
multixact_member | MultiXactMemberBuffer | |
async | NotifyBuffer | |
oldserxid | SerialBuffer | |
wal_insert | WALInsert | |
buffer_content | BufferContent | |
buffer_io | BufferIO | |
replication_origin | ReplicationOriginState | |
replication_slot_io | ReplicationSlotIO | |
proc | LockFastPath | |
buffer_mapping | BufferMapping | |
lock_manager | LockManager | |
predicate_lock_manager | PredicateLockManager | |
serializable_xact | PerXactPredicateList | |
parallel_query_dsa | ParallelQueryDSA | |
tbm | SharedTidBitmap | |
parallel_append | ParallelAppend | |
parallel_hash_join | ParallelHashJoin | |
session_dsa | PerSessionDSA | |
session_record_table | PerSessionRecordType | |
session_typmod_table | PerSessionRecordTypmod | |
shared_tuplestore | SharedTupleStore | |
Lock | speculative token | spectoken |
IPC | Hash/Batch/Allocating | HashBatchAllocate |
Hash/Batch/Electing | HashBatchElect | |
Hash/Batch/Loading | HashBatchLoad | |
Hash/Build/Allocating | HashBuildAllocate | |
Hash/Build/Electing | HashBuildElect | |
Hash/Build/HashingInner | HashBuildHashInner | |
Hash/Build/HashingOuter | HashBuildHashOuter | |
Hash/GrowBatches/Allocating | HashGrowBatchesAllocate | |
Hash/GrowBatches/Deciding | HashGrowBatchesDecide | |
Hash/GrowBatches/Electing | HashGrowBatchesElect | |
Hash/GrowBatches/Finishing | HashGrowBatchesFinish | |
Hash/GrowBatches/Repartitioning | HashGrowBatchesRepartition | |
Hash/GrowBuckets/Allocating | HashGrowBucketsAllocate | |
Hash/GrowBuckets/Electing | HashGrowBucketsElect | |
Hash/GrowBuckets/Reinserting | HashGrowBucketsReinsert | |
待機イベントタイプ | 待機イベント名 |
|---|---|
LWLock | WrapLimitsVacuum |
NotifyQueueTail | |
IPC | BackupWaitWalArchive |
ProcSignalBarrier | |
RecoveryConflictSnapshot | |
RecoveryConflictTablespace | |
RecoveryPause | |
XactGroupUpdate | |
Timeout | RecoveryRetrieveRetryInterval |
VacuumDelay |
待機イベントタイプ | 待機イベント名 |
|---|---|
Activity | RecoveryWalAll |
IPC | ClogGroupUpdate |
対処方法
ありません。
