Commit067deaf

committed

Make sure we don't skip databases that are supposed to be vacuumed "exactly

now". This can happen if the time granularity is not very high.Per ITAGAKI Takahiro.

1 parente292090 commit067deafCopy full SHA for 067deaf

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`*`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $PostgreSQL: pgsql/src/backend/postmaster/autovacuum.c,v 1.45 2007/05/04 02:06:13 tgl Exp $`
	`13`	`+ * $PostgreSQL: pgsql/src/backend/postmaster/autovacuum.c,v 1.46 2007/05/07 20:41:24 alvherre Exp $`
`14`	`14`	`*`
`15`	`15`	`*-------------------------------------------------------------------------`
`16`	`16`	`*/`
`@@ -1036,8 +1036,8 @@ do_start_worker(void)`
`1036`	`1036`	`* Skip this database if its next_worker value falls between`
`1037`	`1037`	`* the current time and the current time plus naptime.`
`1038`	`1038`	`*/`
`1039`		`-if (TimestampDifferenceExceeds(current_time,`
`1040`		`-dbp->adl_next_worker,0)&&`
	`1039`	`+if (!TimestampDifferenceExceeds(dbp->adl_next_worker,`
	`1040`	`+current_time,0)&&`
`1041`	`1041`	`!TimestampDifferenceExceeds(current_time,`
`1042`	`1042`	`dbp->adl_next_worker,`
`1043`	`1043`	`autovacuum_naptime*1000))`

Comments

(0)