🌐 AI搜索 & 代理 主页
Skip to content

Commit 1820650

Browse files
alvherrealvherre
committed
Restructure autovacuum in two processes: a dummy process, which runs
continuously, and requests vacuum runs of "autovacuum workers" to postmaster. The workers do the actual vacuum work. This allows for future improvements, like allowing multiple autovacuum jobs running in parallel. For now, the code keeps the original behavior of having a single autovac process at any time by sleeping until the previous worker has finished.
1 parent eecbb33 commit 1820650

File tree

16 files changed

+799
-242
lines changed

16 files changed

+799
-242
lines changed

‎src/backend/access/transam/varsup.c‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
* Copyright (c) 2000-2007, PostgreSQL Global Development Group
77
*
88
* IDENTIFICATION
9-
* $PostgreSQL: pgsql/src/backend/access/transam/varsup.c,v 1.77 2007/01/05 22:19:23 momjian Exp $
9+
* $PostgreSQL: pgsql/src/backend/access/transam/varsup.c,v 1.78 2007/02/15 23:23:22 alvherre Exp $
1010
*
1111
*-------------------------------------------------------------------------
1212
*/
@@ -72,7 +72,7 @@ GetNewTransactionId(bool isSubXact)
7272
* still gives plenty of chances before we get into real trouble.
7373
*/
7474
if (IsUnderPostmaster && (xid % 65536) == 0)
75-
SendPostmasterSignal(PMSIGNAL_START_AUTOVAC);
75+
SendPostmasterSignal(PMSIGNAL_START_AUTOVAC_LAUNCHER);
7676

7777
if (IsUnderPostmaster &&
7878
TransactionIdFollowsOrEquals(xid, ShmemVariableCache->xidStopLimit))
@@ -286,7 +286,7 @@ SetTransactionIdLimit(TransactionId oldest_datfrozenxid,
286286
*/
287287
if (TransactionIdFollowsOrEquals(curXid, xidVacLimit) &&
288288
IsUnderPostmaster)
289-
SendPostmasterSignal(PMSIGNAL_START_AUTOVAC);
289+
SendPostmasterSignal(PMSIGNAL_START_AUTOVAC_LAUNCHER);
290290

291291
/* Give an immediate warning if past the wrap warn point */
292292
if (TransactionIdFollowsOrEquals(curXid, xidWarnLimit))

‎src/backend/bootstrap/bootstrap.c‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
1010
* IDENTIFICATION
11-
* $PostgreSQL: pgsql/src/backend/bootstrap/bootstrap.c,v 1.230 2007/02/10 14:58:54 petere Exp $
11+
* $PostgreSQL: pgsql/src/backend/bootstrap/bootstrap.c,v 1.231 2007/02/15 23:23:22 alvherre Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -449,7 +449,7 @@ BootstrapMain(int argc, char *argv[])
449449
* Do backend-like initialization for bootstrap mode
450450
*/
451451
InitProcess();
452-
(void) InitPostgres(dbname, NULL);
452+
(void) InitPostgres(dbname, InvalidOid, NULL, NULL);
453453

454454
/*
455455
* In NOP mode, all we really want to do is create shared memory and

‎src/backend/commands/vacuum.c‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -13,7 +13,7 @@
1313
*
1414
*
1515
* IDENTIFICATION
16-
* $PostgreSQL: pgsql/src/backend/commands/vacuum.c,v 1.345 2007/02/05 04:22:18 tgl Exp $
16+
* $PostgreSQL: pgsql/src/backend/commands/vacuum.c,v 1.346 2007/02/15 23:23:22 alvherre Exp $
1717
*
1818
*-------------------------------------------------------------------------
1919
*/
@@ -303,7 +303,7 @@ vacuum(VacuumStmt *vacstmt, List *relids)
303303
* Send info about dead objects to the statistics collector, unless we are
304304
* in autovacuum --- autovacuum.c does this for itself.
305305
*/
306-
if (vacstmt->vacuum && !IsAutoVacuumProcess())
306+
if (vacstmt->vacuum && !IsAutoVacuumWorkerProcess())
307307
pgstat_vacuum_tabstat();
308308

309309
/*
@@ -472,7 +472,7 @@ vacuum(VacuumStmt *vacstmt, List *relids)
472472
ActiveSnapshot = CopySnapshot(GetTransactionSnapshot());
473473
}
474474

475-
if (vacstmt->vacuum && !IsAutoVacuumProcess())
475+
if (vacstmt->vacuum && !IsAutoVacuumWorkerProcess())
476476
{
477477
/*
478478
* Update pg_database.datfrozenxid, and truncate pg_clog if possible.

0 commit comments

Comments
 (0)