diff options
| author | Heikki Linnakangas | 2011-11-09 08:54:41 +0000 |
|---|---|---|
| committer | Heikki Linnakangas | 2011-11-09 08:54:41 +0000 |
| commit | d326d9e8ea1d690cf6d968000efaa5121206d231 (patch) | |
| tree | 861237f4028e9c8f1d1aba2045a97195867cb5b8 /src/include/pgstat.h | |
| parent | 2c30f96103c320d4e3c8cab2807d88476f584278 (diff) | |
In COPY, insert tuples to the heap in batches.
This greatly reduces the WAL volume, especially when the table is narrow.
The overhead of locking the heap page is also reduced. Reduced WAL traffic
also makes it scale a lot better, if you run multiple COPY processes at
the same time.
Diffstat (limited to 'src/include/pgstat.h')
| -rw-r--r-- | src/include/pgstat.h | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/include/pgstat.h b/src/include/pgstat.h index 7b2bd4edc0..651b7d9ddf 100644 --- a/src/include/pgstat.h +++ b/src/include/pgstat.h @@ -766,7 +766,7 @@ extern void pgstat_initstats(Relation rel); (rel)->pgstat_info->t_counts.t_blocks_hit++; \ } while (0) -extern void pgstat_count_heap_insert(Relation rel); +extern void pgstat_count_heap_insert(Relation rel, int n); extern void pgstat_count_heap_update(Relation rel, bool hot); extern void pgstat_count_heap_delete(Relation rel); extern void pgstat_update_heap_dead_tuples(Relation rel, int delta); |