diff options
| -rw-r--r-- | src/backend/storage/ipc/procarray.c | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/src/backend/storage/ipc/procarray.c b/src/backend/storage/ipc/procarray.c index 9fc930e98f8..16b5803d388 100644 --- a/src/backend/storage/ipc/procarray.c +++ b/src/backend/storage/ipc/procarray.c @@ -2753,8 +2753,6 @@ GetRunningTransactionData(void) */ for (index = 0; index < arrayP->numProcs; index++) { - int pgprocno = arrayP->pgprocnos[index]; - PGPROC *proc = &allProcs[pgprocno]; TransactionId xid; /* Fetch xid just once - see GetNewTransactionId */ @@ -2776,11 +2774,18 @@ GetRunningTransactionData(void) oldestRunningXid = xid; /* - * Also, update the oldest running xid within the current database. + * Also, update the oldest running xid within the current database. As + * fetching pgprocno and PGPROC could cause cache misses, we do cheap + * TransactionId comparison first. */ - if (proc->databaseId == MyDatabaseId && - TransactionIdPrecedes(xid, oldestDatabaseRunningXid)) - oldestDatabaseRunningXid = xid; + if (TransactionIdPrecedes(xid, oldestDatabaseRunningXid)) + { + int pgprocno = arrayP->pgprocnos[index]; + PGPROC *proc = &allProcs[pgprocno]; + + if (proc->databaseId == MyDatabaseId) + oldestDatabaseRunningXid = xid; + } if (ProcGlobal->subxidStates[index].overflowed) suboverflowed = true; |