169#define REL_TRUNCATE_MINIMUM 1000
170#define REL_TRUNCATE_FRACTION 16
179#define VACUUM_TRUNCATE_LOCK_CHECK_INTERVAL 20
180#define VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL 50
181#define VACUUM_TRUNCATE_LOCK_TIMEOUT 5000
187#define BYPASS_THRESHOLD_PAGES 0.02
193#define FAILSAFE_EVERY_PAGES \
194 ((BlockNumber) (((uint64) 4 * 1024 * 1024 * 1024) / BLCKSZ))
202#define VACUUM_FSM_EVERY_PAGES \
203 ((BlockNumber) (((uint64) 8 * 1024 * 1024 * 1024) / BLCKSZ))
209#define SKIP_PAGES_THRESHOLD ((BlockNumber) 32)
215#define PREFETCH_SIZE ((BlockNumber) 32)
221#define ParallelVacuumIsActive(vacrel) ((vacrel)->pvs != NULL)
241#define MAX_EAGER_FREEZE_SUCCESS_RATE 0.2
250#define EAGER_SCAN_REGION_SIZE 4096
256#define VAC_BLK_WAS_EAGER_SCANNED (1 << 0)
257#define VAC_BLK_ALL_VISIBLE_ACCORDING_TO_VM (1 << 1)
428 void *callback_private_data,
429 void *per_buffer_data);
433 bool sharelock,
Buffer vmbuffer);
436 Buffer vmbuffer,
bool all_visible_according_to_vm,
437 bool *has_lpdead_items,
bool *vm_page_frozen);
440 bool *has_lpdead_items);
446 int num_offsets,
Buffer vmbuffer);
456 bool estimated_count,
461 bool *lock_waiter_detected);
493 float first_region_ratio;
494 bool oldest_unfrozen_before_cutoff =
false;
546 oldest_unfrozen_before_cutoff =
true;
548 if (!oldest_unfrozen_before_cutoff &&
552 oldest_unfrozen_before_cutoff =
true;
554 if (!oldest_unfrozen_before_cutoff)
567 (allvisible - allfrozen));
634 char **indnames = NULL;
675 errcallback.
arg = vacrel;
684 if (instrument && vacrel->
nindexes > 0)
813 (
errmsg(
"aggressively vacuuming \"%s.%s.%s\"",
818 (
errmsg(
"vacuuming \"%s.%s.%s\"",
902 if (new_rel_allvisible > new_rel_pages)
903 new_rel_allvisible = new_rel_pages;
913 new_rel_allvisible, vacrel->
nindexes > 0,
915 &frozenxid_updated, &minmulti_updated,
false);
950 double read_rate = 0,
952 int64 total_blks_hit;
953 int64 total_blks_read;
954 int64 total_blks_dirtied;
957 memset(&walusage, 0,
sizeof(
WalUsage));
977 msgfmt =
_(
"finished vacuuming \"%s.%s.%s\": index scans: %d\n");
988 msgfmt =
_(
"automatic aggressive vacuum to prevent wraparound of table \"%s.%s.%s\": index scans: %d\n");
990 msgfmt =
_(
"automatic vacuum to prevent wraparound of table \"%s.%s.%s\": index scans: %d\n");
995 msgfmt =
_(
"automatic aggressive vacuum of table \"%s.%s.%s\": index scans: %d\n");
997 msgfmt =
_(
"automatic vacuum of table \"%s.%s.%s\": index scans: %d\n");
1004 appendStringInfo(&
buf,
_(
"pages: %u removed, %u remain, %u scanned (%.2f%% of total), %u eagerly scanned\n"),
1008 orig_rel_pages == 0 ? 100.0 :
1013 _(
"tuples: %lld removed, %lld remain, %lld are dead but not yet removable\n"),
1019 _(
"tuples missed: %lld dead from %u pages not removed due to cleanup lock contention\n"),
1025 _(
"removable cutoff: %u, which was %d XIDs old when operation ended\n"),
1027 if (frozenxid_updated)
1032 _(
"new relfrozenxid: %u, which is %d XIDs ahead of previous value\n"),
1035 if (minmulti_updated)
1040 _(
"new relminmxid: %u, which is %d MXIDs ahead of previous value\n"),
1043 appendStringInfo(&
buf,
_(
"frozen: %u pages from table (%.2f%% of total) had %lld tuples frozen\n"),
1045 orig_rel_pages == 0 ? 100.0 :
1051 _(
"visibility map: %u pages set all-visible, %u pages set all-frozen (%u were all-visible)\n"),
1063 msgfmt =
_(
"%u pages from table (%.2f%% of total) had %lld dead item identifiers removed\n");
1072 msgfmt =
_(
"%u pages from table (%.2f%% of total) have %lld dead item identifiers\n");
1076 orig_rel_pages == 0 ? 100.0 :
1087 _(
"index \"%s\": pages: %u in total, %u newly deleted, %u currently deleted, %u reusable\n"),
1113 if (secs_dur > 0 || usecs_dur > 0)
1115 read_rate = (double) BLCKSZ * total_blks_read /
1116 (1024 * 1024) / (secs_dur + usecs_dur / 1000000.0);
1117 write_rate = (double) BLCKSZ * total_blks_dirtied /
1118 (1024 * 1024) / (secs_dur + usecs_dur / 1000000.0);
1121 read_rate, write_rate);
1123 _(
"buffer usage: %lld hits, %lld reads, %lld dirtied\n"),
1124 (
long long) total_blks_hit,
1125 (
long long) total_blks_read,
1126 (
long long) total_blks_dirtied);
1128 _(
"WAL usage: %lld records, %lld full page images, %llu bytes\n"),
1131 (
unsigned long long) walusage.
wal_bytes);
1193 next_fsm_block_to_vacuum = 0;
1194 void *per_buffer_data = NULL;
1198 const int initprog_index[] = {
1203 int64 initprog_val[3];
1207 initprog_val[1] = rel_pages;
1232 bool has_lpdead_items;
1233 bool vm_page_frozen =
false;
1234 bool got_cleanup_lock =
false;
1282 next_fsm_block_to_vacuum = blkno;
1295 blk_info = *((
uint8 *) per_buffer_data);
1324 if (!got_cleanup_lock)
1343 if (!got_cleanup_lock &&
1353 got_cleanup_lock =
true;
1369 if (got_cleanup_lock)
1373 &has_lpdead_items, &vm_page_frozen);
1389 if (got_cleanup_lock &&
1412 (
errmsg(
"disabling eager scanning after freezing %u eagerly scanned blocks of \"%s.%s.%s\"",
1413 orig_eager_scan_success_limit,
1446 || !has_lpdead_items)
1459 if (got_cleanup_lock && vacrel->
nindexes == 0 && has_lpdead_items &&
1464 next_fsm_block_to_vacuum = blkno;
1510 if (rel_pages > next_fsm_block_to_vacuum)
1547 void *callback_private_data,
1548 void *per_buffer_data)
1607 if (next_block < vacrel->next_unskippable_block)
1616 *((
uint8 *) per_buffer_data) = blk_info;
1632 *((
uint8 *) per_buffer_data) = blk_info;
1656 bool next_unskippable_eager_scanned =
false;
1657 bool next_unskippable_allvis;
1659 *skipsallvis =
false;
1661 for (;; next_unskippable_block++)
1664 next_unskippable_block,
1665 &next_unskippable_vmbuffer);
1686 if (!next_unskippable_allvis)
1702 if (next_unskippable_block == rel_pages - 1)
1730 next_unskippable_eager_scanned =
true;
1738 *skipsallvis =
true;
1931 bool all_visible_according_to_vm,
1932 bool *has_lpdead_items,
1933 bool *vm_page_frozen)
1937 int prune_options = 0;
1986#ifdef USE_ASSERT_CHECKING
1991 bool debug_all_frozen;
1996 &debug_cutoff, &debug_all_frozen))
2046 if (!all_visible_according_to_vm && presult.
all_visible)
2087 *vm_page_frozen =
true;
2094 *vm_page_frozen =
true;
2107 elog(
WARNING,
"page is not marked all-visible but visibility map bit is set in relation \"%s\" page %u",
2129 elog(
WARNING,
"page containing LP_DEAD items is marked as all-visible in relation \"%s\" page %u",
2142 else if (all_visible_according_to_vm && presult.
all_visible &&
2183 *vm_page_frozen =
true;
2193 *vm_page_frozen =
true;
2223 bool *has_lpdead_items)
2229 recently_dead_tuples,
2243 recently_dead_tuples = 0;
2244 missed_dead_tuples = 0;
2272 deadoffsets[lpdead_items++] = offnum;
2279 &NoFreezePageRelfrozenXid,
2280 &NoFreezePageRelminMxid))
2333 missed_dead_tuples++;
2340 recently_dead_tuples++;
2349 elog(
ERROR,
"unexpected HeapTupleSatisfiesVacuum result");
2368 if (lpdead_items > 0)
2379 missed_dead_tuples += lpdead_items;
2382 else if (lpdead_items > 0)
2402 if (missed_dead_tuples > 0)
2410 *has_lpdead_items = (lpdead_items > 0);
2557 bool allindexes =
true;
2558 double old_live_tuples = vacrel->
rel->
rd_rel->reltuples;
2559 const int progress_start_index[] = {
2563 const int progress_end_index[] = {
2568 int64 progress_start_val[2];
2569 int64 progress_end_val[3];
2587 progress_start_val[1] = vacrel->
nindexes;
2646 progress_end_val[0] = 0;
2647 progress_end_val[1] = 0;
2661 void *callback_private_data,
2662 void *per_buffer_data)
2668 if (iter_result == NULL)
2675 memcpy(per_buffer_data, iter_result,
sizeof(*iter_result));
2677 return iter_result->
blkno;
2764 num_offsets, vmbuffer);
2791 (
errmsg(
"table \"%s\": removed %lld dead item identifiers in %u pages",
2830 for (
int i = 0;
i < num_offsets;
i++)
2839 unused[nunused++] = toff;
2895 vmbuffer, visibility_cutoff_xid,
2939 const int progress_index[] = {
2943 int64 progress_val[2] = {0, 0};
2963 (
errmsg(
"bypassing nonessential maintenance of table \"%s.%s.%s\" as a failsafe after %d index scans",
2966 errdetail(
"The table's relfrozenxid or relminmxid is too far in the past."),
2967 errhint(
"Consider increasing configuration parameter \"maintenance_work_mem\" or \"autovacuum_work_mem\".\n"
2968 "You might also need to consider other ways for VACUUM to keep up with the allocation of transaction IDs.")));
2988 const int progress_start_index[] = {
2992 const int progress_end_index[] = {
2996 int64 progress_start_val[2];
2997 int64 progress_end_val[2] = {0, 0};
3007 progress_start_val[1] = vacrel->
nindexes;
3019 estimated_count, vacrel);
3058 ivinfo.
index = indrel;
3102 double reltuples,
bool estimated_count,
3108 ivinfo.
index = indrel;
3169 if (possibly_freeable > 0 &&
3185 bool lock_waiter_detected;
3208 lock_waiter_detected =
false;
3229 (
errmsg(
"\"%s\": stopping truncate due to conflicting lock request",
3237 WAIT_EVENT_VACUUM_TRUNCATE);
3247 if (new_rel_pages != orig_rel_pages)
3267 vacrel->
blkno = new_rel_pages;
3269 if (new_rel_pages >= orig_rel_pages)
3299 (
errmsg(
"table \"%s\": truncated %u to %u pages",
3301 orig_rel_pages, new_rel_pages)));
3302 orig_rel_pages = new_rel_pages;
3303 }
while (new_rel_pages > vacrel->
nonempty_pages && lock_waiter_detected);
3329 "prefetch size must be power of 2");
3347 if ((blkno % 32) == 0)
3353 elapsed = currenttime;
3361 (
errmsg(
"table \"%s\": suspending truncate due to conflicting lock request",
3364 *lock_waiter_detected =
true;
3367 starttime = currenttime;
3381 if (prefetchedUntil > blkno)
3387 for (pblkno = prefetchStart; pblkno <= blkno; pblkno++)
3392 prefetchedUntil = prefetchStart;
3480 (
errmsg(
"disabling parallel option of vacuum on \"%s\" --- cannot vacuum temporary tables in parallel",
3522 const int prog_index[2] = {
3594 bool all_visible =
true;
3601 offnum <= maxoff && all_visible;
3626 all_visible =
false;
3627 *all_frozen =
false;
3647 all_visible =
false;
3648 *all_frozen =
false;
3660 all_visible =
false;
3661 *all_frozen =
false;
3668 *visibility_cutoff_xid = xmin;
3671 if (all_visible && *all_frozen &&
3673 *all_frozen =
false;
3682 all_visible =
false;
3683 *all_frozen =
false;
3687 elog(
ERROR,
"unexpected HeapTupleSatisfiesVacuum result");
3710 for (
int idx = 0;
idx < nindexes;
idx++)
3741 switch (errinfo->
phase)
3747 errcontext(
"while scanning block %u offset %u of relation \"%s.%s\"",
3750 errcontext(
"while scanning block %u of relation \"%s.%s\"",
3754 errcontext(
"while scanning relation \"%s.%s\"",
3762 errcontext(
"while vacuuming block %u offset %u of relation \"%s.%s\"",
3765 errcontext(
"while vacuuming block %u of relation \"%s.%s\"",
3769 errcontext(
"while vacuuming relation \"%s.%s\"",
3774 errcontext(
"while vacuuming index \"%s\" of relation \"%s.%s\"",
3779 errcontext(
"while cleaning up index \"%s\" of relation \"%s.%s\"",
3785 errcontext(
"while truncating relation \"%s.%s\" to %u blocks",
3811 vacrel->
blkno = blkno;
3813 vacrel->
phase = phase;
Datum idx(PG_FUNCTION_ARGS)
void TimestampDifference(TimestampTz start_time, TimestampTz stop_time, long *secs, int *microsecs)
bool TimestampDifferenceExceeds(TimestampTz start_time, TimestampTz stop_time, int msec)
TimestampTz GetCurrentTimestamp(void)
void pgstat_progress_start_command(ProgressCommandType cmdtype, Oid relid)
void pgstat_progress_update_param(int index, int64 val)
void pgstat_progress_update_multi_param(int nparam, const int *index, const int64 *val)
void pgstat_progress_end_command(void)
@ PROGRESS_COMMAND_VACUUM
PgBackendStatus * MyBEEntry
#define InvalidBlockNumber
static bool BlockNumberIsValid(BlockNumber blockNumber)
void CheckBufferIsPinnedOnce(Buffer buffer)
BlockNumber BufferGetBlockNumber(Buffer buffer)
PrefetchBufferResult PrefetchBuffer(Relation reln, ForkNumber forkNum, BlockNumber blockNum)
void ReleaseBuffer(Buffer buffer)
void UnlockReleaseBuffer(Buffer buffer)
void MarkBufferDirty(Buffer buffer)
void LockBufferForCleanup(Buffer buffer)
void LockBuffer(Buffer buffer, int mode)
Buffer ReadBufferExtended(Relation reln, ForkNumber forkNum, BlockNumber blockNum, ReadBufferMode mode, BufferAccessStrategy strategy)
bool ConditionalLockBufferForCleanup(Buffer buffer)
#define BUFFER_LOCK_UNLOCK
#define BUFFER_LOCK_SHARE
#define RelationGetNumberOfBlocks(reln)
static Page BufferGetPage(Buffer buffer)
#define BUFFER_LOCK_EXCLUSIVE
static bool BufferIsValid(Buffer bufnum)
Size PageGetHeapFreeSpace(const PageData *page)
void PageTruncateLinePointerArray(Page page)
static bool PageIsEmpty(const PageData *page)
static bool PageIsAllVisible(const PageData *page)
static void PageClearAllVisible(Page page)
static Item PageGetItem(const PageData *page, const ItemIdData *itemId)
static bool PageIsNew(const PageData *page)
#define SizeOfPageHeaderData
static void PageSetAllVisible(Page page)
static ItemId PageGetItemId(Page page, OffsetNumber offsetNumber)
static XLogRecPtr PageGetLSN(const PageData *page)
static OffsetNumber PageGetMaxOffsetNumber(const PageData *page)
#define Assert(condition)
TransactionId MultiXactId
#define StaticAssertStmt(condition, errmessage)
char * get_database_name(Oid dbid)
int errmsg_internal(const char *fmt,...)
int errdetail(const char *fmt,...)
ErrorContextCallback * error_context_stack
int errhint(const char *fmt,...)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
void FreeSpaceMapVacuumRange(Relation rel, BlockNumber start, BlockNumber end)
Size GetRecordedFreeSpace(Relation rel, BlockNumber heapBlk)
void RecordPageWithFreeSpace(Relation rel, BlockNumber heapBlk, Size spaceAvail)
bool heap_tuple_needs_eventual_freeze(HeapTupleHeader tuple)
bool heap_tuple_should_freeze(HeapTupleHeader tuple, const struct VacuumCutoffs *cutoffs, TransactionId *NoFreezePageRelfrozenXid, MultiXactId *NoFreezePageRelminMxid)
#define HEAP_PAGE_PRUNE_FREEZE
@ HEAPTUPLE_RECENTLY_DEAD
@ HEAPTUPLE_INSERT_IN_PROGRESS
@ HEAPTUPLE_DELETE_IN_PROGRESS
#define HEAP_PAGE_PRUNE_MARK_UNUSED_NOW
HTSV_Result HeapTupleSatisfiesVacuum(HeapTuple htup, TransactionId OldestXmin, Buffer buffer)
HeapTupleHeaderData * HeapTupleHeader
static TransactionId HeapTupleHeaderGetXmin(const HeapTupleHeaderData *tup)
#define MaxHeapTuplesPerPage
static bool HeapTupleHeaderXminCommitted(const HeapTupleHeaderData *tup)
#define INSTR_TIME_SET_CURRENT(t)
#define INSTR_TIME_SUBTRACT(x, y)
#define INSTR_TIME_GET_MICROSEC(t)
void WalUsageAccumDiff(WalUsage *dst, const WalUsage *add, const WalUsage *sub)
BufferUsage pgBufferUsage
void BufferUsageAccumDiff(BufferUsage *dst, const BufferUsage *add, const BufferUsage *sub)
static int pg_cmp_u16(uint16 a, uint16 b)
#define ItemIdGetLength(itemId)
#define ItemIdIsNormal(itemId)
#define ItemIdIsDead(itemId)
#define ItemIdIsUsed(itemId)
#define ItemIdSetUnused(itemId)
#define ItemIdIsRedirected(itemId)
#define ItemIdHasStorage(itemId)
static void ItemPointerSet(ItemPointerData *pointer, BlockNumber blockNumber, OffsetNumber offNum)
void ResetLatch(Latch *latch)
int WaitLatch(Latch *latch, int wakeEvents, long timeout, uint32 wait_event_info)
#define WL_EXIT_ON_PM_DEATH
void UnlockRelation(Relation relation, LOCKMODE lockmode)
bool ConditionalLockRelation(Relation relation, LOCKMODE lockmode)
bool LockHasWaitersRelation(Relation relation, LOCKMODE lockmode)
#define AccessExclusiveLock
char * get_namespace_name(Oid nspid)
char * pstrdup(const char *in)
void pfree(void *pointer)
void * palloc0(Size size)
#define AmAutoVacuumWorkerProcess()
#define START_CRIT_SECTION()
#define CHECK_FOR_INTERRUPTS()
#define END_CRIT_SECTION()
bool MultiXactIdPrecedes(MultiXactId multi1, MultiXactId multi2)
bool MultiXactIdPrecedesOrEquals(MultiXactId multi1, MultiXactId multi2)
#define MultiXactIdIsValid(multi)
#define InvalidMultiXactId
#define InvalidOffsetNumber
#define OffsetNumberIsValid(offsetNumber)
#define OffsetNumberNext(offsetNumber)
#define FirstOffsetNumber
uint32 pg_prng_uint32(pg_prng_state *state)
pg_prng_state pg_global_prng_state
const char * pg_rusage_show(const PGRUsage *ru0)
void pg_rusage_init(PGRUsage *ru0)
PgStat_Counter pgStatBlockReadTime
PgStat_Counter pgStatBlockWriteTime
void pgstat_report_vacuum(Oid tableoid, bool shared, PgStat_Counter livetuples, PgStat_Counter deadtuples, TimestampTz starttime)
#define qsort(a, b, c, d)
GlobalVisState * GlobalVisTestFor(Relation rel)
#define PROGRESS_VACUUM_PHASE_FINAL_CLEANUP
#define PROGRESS_VACUUM_DEAD_TUPLE_BYTES
#define PROGRESS_VACUUM_PHASE_SCAN_HEAP
#define PROGRESS_VACUUM_TOTAL_HEAP_BLKS
#define PROGRESS_VACUUM_PHASE
#define PROGRESS_VACUUM_DELAY_TIME
#define PROGRESS_VACUUM_NUM_INDEX_VACUUMS
#define PROGRESS_VACUUM_PHASE_VACUUM_HEAP
#define PROGRESS_VACUUM_NUM_DEAD_ITEM_IDS
#define PROGRESS_VACUUM_MAX_DEAD_TUPLE_BYTES
#define PROGRESS_VACUUM_HEAP_BLKS_SCANNED
#define PROGRESS_VACUUM_PHASE_INDEX_CLEANUP
#define PROGRESS_VACUUM_PHASE_VACUUM_INDEX
#define PROGRESS_VACUUM_INDEXES_PROCESSED
#define PROGRESS_VACUUM_INDEXES_TOTAL
#define PROGRESS_VACUUM_HEAP_BLKS_VACUUMED
#define PROGRESS_VACUUM_PHASE_TRUNCATE
void heap_page_prune_and_freeze(Relation relation, Buffer buffer, GlobalVisState *vistest, int options, struct VacuumCutoffs *cutoffs, PruneFreezeResult *presult, PruneReason reason, OffsetNumber *off_loc, TransactionId *new_relfrozen_xid, MultiXactId *new_relmin_mxid)
void log_heap_prune_and_freeze(Relation relation, Buffer buffer, TransactionId conflict_xid, bool cleanup_lock, PruneReason reason, HeapTupleFreeze *frozen, int nfrozen, OffsetNumber *redirected, int nredirected, OffsetNumber *dead, int ndead, OffsetNumber *unused, int nunused)
Buffer read_stream_next_buffer(ReadStream *stream, void **per_buffer_data)
ReadStream * read_stream_begin_relation(int flags, BufferAccessStrategy strategy, Relation rel, ForkNumber forknum, ReadStreamBlockNumberCB callback, void *callback_private_data, size_t per_buffer_data_size)
void read_stream_end(ReadStream *stream)
#define READ_STREAM_MAINTENANCE
#define RelationGetRelid(relation)
#define RelationGetRelationName(relation)
#define RelationNeedsWAL(relation)
#define RelationUsesLocalBuffers(relation)
#define RelationGetNamespace(relation)
void RelationTruncate(Relation rel, BlockNumber nblocks)
void appendStringInfo(StringInfo str, const char *fmt,...)
void appendStringInfoString(StringInfo str, const char *s)
void initStringInfo(StringInfo str)
int64 shared_blks_dirtied
struct ErrorContextCallback * previous
void(* callback)(void *arg)
BlockNumber pages_deleted
BlockNumber pages_newly_deleted
BufferAccessStrategy strategy
BlockNumber next_eager_scan_region_start
ParallelVacuumState * pvs
bool next_unskippable_eager_scanned
VacDeadItemsInfo * dead_items_info
BlockNumber vm_new_frozen_pages
Buffer next_unskippable_vmbuffer
BlockNumber nonempty_pages
BlockNumber eager_scan_remaining_fails
BlockNumber scanned_pages
BlockNumber new_frozen_tuple_pages
BlockNumber removed_pages
IndexBulkDeleteResult ** indstats
TransactionId NewRelfrozenXid
bool consider_bypass_optimization
BlockNumber next_unskippable_block
int64 recently_dead_tuples
BlockNumber missed_dead_pages
BlockNumber current_block
BufferAccessStrategy bstrategy
BlockNumber eager_scan_remaining_successes
BlockNumber lpdead_item_pages
BlockNumber eager_scanned_pages
MultiXactId NewRelminMxid
struct VacuumCutoffs cutoffs
bool next_unskippable_allvis
BlockNumber vm_new_visible_pages
BlockNumber eager_scan_max_fails_per_region
BlockNumber vm_new_visible_frozen_pages
int64 st_progress_param[PGSTAT_NUM_PROGRESS_PARAM]
TransactionId vm_conflict_horizon
OffsetNumber deadoffsets[MaxHeapTuplesPerPage]
TransactionId FreezeLimit
TransactionId relfrozenxid
MultiXactId MultiXactCutoff
VacOptValue index_cleanup
double max_eager_freeze_failure_rate
TidStoreIter * TidStoreBeginIterate(TidStore *ts)
void TidStoreEndIterate(TidStoreIter *iter)
TidStoreIterResult * TidStoreIterateNext(TidStoreIter *iter)
TidStore * TidStoreCreateLocal(size_t max_bytes, bool insert_only)
void TidStoreDestroy(TidStore *ts)
int TidStoreGetBlockOffsets(TidStoreIterResult *result, OffsetNumber *offsets, int max_offsets)
void TidStoreSetBlockOffsets(TidStore *ts, BlockNumber blkno, OffsetNumber *offsets, int num_offsets)
size_t TidStoreMemoryUsage(TidStore *ts)
bool TransactionIdPrecedes(TransactionId id1, TransactionId id2)
bool TransactionIdPrecedesOrEquals(TransactionId id1, TransactionId id2)
bool TransactionIdFollows(TransactionId id1, TransactionId id2)
static TransactionId ReadNextTransactionId(void)
#define InvalidTransactionId
#define TransactionIdIsValid(xid)
#define TransactionIdIsNormal(xid)
bool track_cost_delay_timing
void vac_open_indexes(Relation relation, LOCKMODE lockmode, int *nindexes, Relation **Irel)
void vac_update_relstats(Relation relation, BlockNumber num_pages, double num_tuples, BlockNumber num_all_visible_pages, bool hasindex, TransactionId frozenxid, MultiXactId minmulti, bool *frozenxid_updated, bool *minmulti_updated, bool in_outer_xact)
IndexBulkDeleteResult * vac_cleanup_one_index(IndexVacuumInfo *ivinfo, IndexBulkDeleteResult *istat)
void vac_close_indexes(int nindexes, Relation *Irel, LOCKMODE lockmode)
void vacuum_delay_point(bool is_analyze)
bool vacuum_get_cutoffs(Relation rel, const VacuumParams *params, struct VacuumCutoffs *cutoffs)
bool vacuum_xid_failsafe_check(const struct VacuumCutoffs *cutoffs)
bool VacuumFailsafeActive
double vac_estimate_reltuples(Relation relation, BlockNumber total_pages, BlockNumber scanned_pages, double scanned_tuples)
IndexBulkDeleteResult * vac_bulkdel_one_index(IndexVacuumInfo *ivinfo, IndexBulkDeleteResult *istat, TidStore *dead_items, VacDeadItemsInfo *dead_items_info)
@ VACOPTVALUE_UNSPECIFIED
#define VACOPT_DISABLE_PAGE_SKIPPING
static void dead_items_cleanup(LVRelState *vacrel)
static bool heap_page_is_all_visible(LVRelState *vacrel, Buffer buf, TransactionId *visibility_cutoff_xid, bool *all_frozen)
#define VAC_BLK_WAS_EAGER_SCANNED
static void update_relstats_all_indexes(LVRelState *vacrel)
static void dead_items_add(LVRelState *vacrel, BlockNumber blkno, OffsetNumber *offsets, int num_offsets)
static void lazy_scan_prune(LVRelState *vacrel, Buffer buf, BlockNumber blkno, Page page, Buffer vmbuffer, bool all_visible_according_to_vm, bool *has_lpdead_items, bool *vm_page_frozen)
static BlockNumber heap_vac_scan_next_block(ReadStream *stream, void *callback_private_data, void *per_buffer_data)
#define VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL
static void vacuum_error_callback(void *arg)
#define EAGER_SCAN_REGION_SIZE
static void lazy_truncate_heap(LVRelState *vacrel)
static void lazy_vacuum(LVRelState *vacrel)
static void lazy_cleanup_all_indexes(LVRelState *vacrel)
#define MAX_EAGER_FREEZE_SUCCESS_RATE
static bool lazy_scan_noprune(LVRelState *vacrel, Buffer buf, BlockNumber blkno, Page page, bool *has_lpdead_items)
static BlockNumber vacuum_reap_lp_read_stream_next(ReadStream *stream, void *callback_private_data, void *per_buffer_data)
#define REL_TRUNCATE_MINIMUM
static bool should_attempt_truncation(LVRelState *vacrel)
static bool lazy_scan_new_or_empty(LVRelState *vacrel, Buffer buf, BlockNumber blkno, Page page, bool sharelock, Buffer vmbuffer)
@ VACUUM_ERRCB_PHASE_SCAN_HEAP
@ VACUUM_ERRCB_PHASE_VACUUM_INDEX
@ VACUUM_ERRCB_PHASE_TRUNCATE
@ VACUUM_ERRCB_PHASE_INDEX_CLEANUP
@ VACUUM_ERRCB_PHASE_VACUUM_HEAP
@ VACUUM_ERRCB_PHASE_UNKNOWN
static void lazy_scan_heap(LVRelState *vacrel)
#define ParallelVacuumIsActive(vacrel)
static void restore_vacuum_error_info(LVRelState *vacrel, const LVSavedErrInfo *saved_vacrel)
void heap_vacuum_rel(Relation rel, VacuumParams *params, BufferAccessStrategy bstrategy)
static IndexBulkDeleteResult * lazy_vacuum_one_index(Relation indrel, IndexBulkDeleteResult *istat, double reltuples, LVRelState *vacrel)
static void find_next_unskippable_block(LVRelState *vacrel, bool *skipsallvis)
static void dead_items_reset(LVRelState *vacrel)
#define REL_TRUNCATE_FRACTION
static bool lazy_check_wraparound_failsafe(LVRelState *vacrel)
struct LVSavedErrInfo LVSavedErrInfo
static IndexBulkDeleteResult * lazy_cleanup_one_index(Relation indrel, IndexBulkDeleteResult *istat, double reltuples, bool estimated_count, LVRelState *vacrel)
static void lazy_vacuum_heap_page(LVRelState *vacrel, BlockNumber blkno, Buffer buffer, OffsetNumber *deadoffsets, int num_offsets, Buffer vmbuffer)
struct LVRelState LVRelState
static void heap_vacuum_eager_scan_setup(LVRelState *vacrel, VacuumParams *params)
#define BYPASS_THRESHOLD_PAGES
static void dead_items_alloc(LVRelState *vacrel, int nworkers)
#define VACUUM_TRUNCATE_LOCK_TIMEOUT
static bool lazy_vacuum_all_indexes(LVRelState *vacrel)
static void update_vacuum_error_info(LVRelState *vacrel, LVSavedErrInfo *saved_vacrel, int phase, BlockNumber blkno, OffsetNumber offnum)
static BlockNumber count_nondeletable_pages(LVRelState *vacrel, bool *lock_waiter_detected)
#define VAC_BLK_ALL_VISIBLE_ACCORDING_TO_VM
#define SKIP_PAGES_THRESHOLD
#define FAILSAFE_EVERY_PAGES
#define VACUUM_TRUNCATE_LOCK_CHECK_INTERVAL
static int cmpOffsetNumbers(const void *a, const void *b)
static void lazy_vacuum_heap_rel(LVRelState *vacrel)
#define VACUUM_FSM_EVERY_PAGES
TidStore * parallel_vacuum_get_dead_items(ParallelVacuumState *pvs, VacDeadItemsInfo **dead_items_info_p)
ParallelVacuumState * parallel_vacuum_init(Relation rel, Relation *indrels, int nindexes, int nrequested_workers, int vac_work_mem, int elevel, BufferAccessStrategy bstrategy)
void parallel_vacuum_bulkdel_all_indexes(ParallelVacuumState *pvs, long num_table_tuples, int num_index_scans)
void parallel_vacuum_reset_dead_items(ParallelVacuumState *pvs)
void parallel_vacuum_cleanup_all_indexes(ParallelVacuumState *pvs, long num_table_tuples, int num_index_scans, bool estimated_count)
void parallel_vacuum_end(ParallelVacuumState *pvs, IndexBulkDeleteResult **istats)
bool visibilitymap_clear(Relation rel, BlockNumber heapBlk, Buffer vmbuf, uint8 flags)
void visibilitymap_pin(Relation rel, BlockNumber heapBlk, Buffer *vmbuf)
uint8 visibilitymap_get_status(Relation rel, BlockNumber heapBlk, Buffer *vmbuf)
void visibilitymap_count(Relation rel, BlockNumber *all_visible, BlockNumber *all_frozen)
uint8 visibilitymap_set(Relation rel, BlockNumber heapBlk, Buffer heapBuf, XLogRecPtr recptr, Buffer vmBuf, TransactionId cutoff_xid, uint8 flags)
#define VM_ALL_FROZEN(r, b, v)
#define VISIBILITYMAP_VALID_BITS
#define VISIBILITYMAP_ALL_FROZEN
#define VISIBILITYMAP_ALL_VISIBLE
bool IsInParallelMode(void)
#define InvalidXLogRecPtr
XLogRecPtr log_newpage_buffer(Buffer buffer, bool page_std)