Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1820650

Browse files
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 autovacprocess at any time by sleeping until the previous worker has finished.
1 parenteecbb33 commit1820650

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)
[8]ページ先頭
©2009-2025 Movatter.jp