|
8 | 8 | * |
9 | 9 | * |
10 | 10 | * IDENTIFICATION |
11 | | - * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.41 2009/02/27 09:30:21 petere Exp $ |
| 11 | + * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.42 2009/07/13 22:56:30 momjian Exp $ |
12 | 12 | * |
13 | 13 | *------------------------------------------------------------------------- |
14 | 14 | */ |
@@ -155,11 +155,11 @@ vacuumlo(char *database, struct _param * param) |
155 | 155 | PQclear(res); |
156 | 156 |
|
157 | 157 | /* |
158 | | - *Vacuum the temp table so that planner will generate decent plans for |
| 158 | + *Analyze the temp table so that planner will generate decent plans for |
159 | 159 | * the DELETEs below. |
160 | 160 | */ |
161 | 161 | buf[0]='\0'; |
162 | | -strcat(buf,"VACUUMANALYZE vacuum_l"); |
| 162 | +strcat(buf,"ANALYZE vacuum_l"); |
163 | 163 | res=PQexec(conn,buf); |
164 | 164 | if (PQresultStatus(res)!=PGRES_COMMAND_OK) |
165 | 165 | { |
@@ -216,11 +216,6 @@ vacuumlo(char *database, struct _param * param) |
216 | 216 | if (param->verbose) |
217 | 217 | fprintf(stdout,"Checking %s in %s.%s\n",field,schema,table); |
218 | 218 |
|
219 | | -/* |
220 | | - * The "IN" construct used here was horribly inefficient before |
221 | | - * Postgres 7.4, but should be now competitive if not better than the |
222 | | - * bogus join we used before. |
223 | | - */ |
224 | 219 | snprintf(buf,BUFSIZE, |
225 | 220 | "DELETE FROM vacuum_l " |
226 | 221 | "WHERE lo IN (SELECT \"%s\" FROM \"%s\".\"%s\")", |
|