diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-05-07 20:41:24 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-05-07 20:41:24 +0000 |
| commit | 067deaf83d60744e42a3f07ce15aac3197607fb6 (patch) | |
| tree | 60c81e4cab73be01a429d425336a0ef63c401a9f | |
| parent | e292090b59589e70bd9b9c5b09f595987b73c318 (diff) | |
| download | postgresql-067deaf83d60744e42a3f07ce15aac3197607fb6.tar.gz postgresql-067deaf83d60744e42a3f07ce15aac3197607fb6.zip | |
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.
| -rw-r--r-- | src/backend/postmaster/autovacuum.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/postmaster/autovacuum.c b/src/backend/postmaster/autovacuum.c index 3234bc47231..4d73c6c3f59 100644 --- a/src/backend/postmaster/autovacuum.c +++ b/src/backend/postmaster/autovacuum.c @@ -10,7 +10,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/postmaster/autovacuum.c,v 1.45 2007/05/04 02:06:13 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/postmaster/autovacuum.c,v 1.46 2007/05/07 20:41:24 alvherre Exp $ * *------------------------------------------------------------------------- */ @@ -1036,8 +1036,8 @@ do_start_worker(void) * Skip this database if its next_worker value falls between * the current time and the current time plus naptime. */ - if (TimestampDifferenceExceeds(current_time, - dbp->adl_next_worker, 0) && + if (!TimestampDifferenceExceeds(dbp->adl_next_worker, + current_time, 0) && !TimestampDifferenceExceeds(current_time, dbp->adl_next_worker, autovacuum_naptime * 1000)) |