Content-Length: 237912 | pFad | http://github.com/postgrespro/postgres/commit/7d4c9a5793b49633be0fae7653552f3fb4a812c0

C5 Add the "recheck" logic to autovacuum worker code. The worker first … · postgrespro/postgres@7d4c9a5 · GitHub

Commit 7d4c9a5

committed

Add the "recheck" logic to autovacuum worker code. The worker first builds

its table list and then rechecks pgstat before vacuuming each table to verify that no one has vacuumed the table in the meantime. In the current autovacuum world this only means that a worker will not vacuum a table that a user has vacuumed manually after the worker started. When support for multiple autovacuum workers is introduced, this will reduce the probability of simultaneous workers on the same database doing redundant work.

1 parent 685badd commit 7d4c9a5Copy full SHA for 7d4c9a5

2 files changed

+302

-110

lines changed

src/backend/postmaster
- autovacuum.c
- pgstat.c

2 files changed

+302

-110

lines changed

Comments

(0)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit 7d4c9a5

2 files changed

2 files changed

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!

File tree

2 files changed

2 files changed

0 commit comments

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!