diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-02-11 16:59:09 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-02-11 16:59:09 +0000 |
| commit | bf324946b32736da1b128b1e742515879b42a4e8 (patch) | |
| tree | d1a9560e621c4423a40dfef2fc5dcfda183dfbeb /src/backend/access/hash/hash.c | |
| parent | 85d8ee846b6b645cdf07d948aabc807aa755deac (diff) | |
| download | postgresql-bf324946b32736da1b128b1e742515879b42a4e8.tar.gz postgresql-bf324946b32736da1b128b1e742515879b42a4e8.zip | |
Allow VACUUM to complete faster by avoiding scanning the indexes when no
rows were removed from the heap by the VACUUM.
Simon Riggs
Diffstat (limited to 'src/backend/access/hash/hash.c')
| -rw-r--r-- | src/backend/access/hash/hash.c | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/src/backend/access/hash/hash.c b/src/backend/access/hash/hash.c index 3a01109125f..548901a9be4 100644 --- a/src/backend/access/hash/hash.c +++ b/src/backend/access/hash/hash.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/hash/hash.c,v 1.83 2006/01/25 23:26:11 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/access/hash/hash.c,v 1.84 2006/02/11 16:59:09 momjian Exp $ * * NOTES * This file contains only the public interface routines. @@ -496,6 +496,17 @@ hashbulkdelete(PG_FUNCTION_ARGS) tuples_removed = 0; num_index_tuples = 0; + /* return statistics */ + num_pages = RelationGetNumberOfBlocks(rel); + + result = (IndexBulkDeleteResult *) palloc0(sizeof(IndexBulkDeleteResult)); + result->num_pages = num_pages; + + if (!callback_state) + { + PG_RETURN_POINTER(result); + } + /* * Read the metapage to fetch original bucket and tuple counts. Also, we * keep a copy of the last-seen metapage so that we can use its @@ -644,11 +655,6 @@ loop_top: _hash_wrtbuf(rel, metabuf); - /* return statistics */ - num_pages = RelationGetNumberOfBlocks(rel); - - result = (IndexBulkDeleteResult *) palloc0(sizeof(IndexBulkDeleteResult)); - result->num_pages = num_pages; result->num_index_tuples = num_index_tuples; result->tuples_removed = tuples_removed; |