diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-06 20:51:15 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-06 20:51:15 +0000 |
| commit | 85e2cedf985bfecaf43a18ca17433070f439fb0e (patch) | |
| tree | 9348349050eaa2a8a863297c88502263c3a2e338 /src/backend/storage/buffer/freelist.c | |
| parent | cdc197cf3100359cd436757adc0002dad07e3117 (diff) | |
| download | postgresql-85e2cedf985bfecaf43a18ca17433070f439fb0e.tar.gz postgresql-85e2cedf985bfecaf43a18ca17433070f439fb0e.zip | |
Improve bulk-insert performance by keeping the current target buffer pinned
(but not locked, as that would risk deadlocks). Also, make it work in a small
ring of buffers to avoid having bulk inserts trash the whole buffer arena.
Robert Haas, after an idea of Simon Riggs'.
Diffstat (limited to 'src/backend/storage/buffer/freelist.c')
| -rw-r--r-- | src/backend/storage/buffer/freelist.c | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/backend/storage/buffer/freelist.c b/src/backend/storage/buffer/freelist.c index 4e55db9adc2..5f4c05cef6d 100644 --- a/src/backend/storage/buffer/freelist.c +++ b/src/backend/storage/buffer/freelist.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/storage/buffer/freelist.c,v 1.64 2008/01/01 19:45:51 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/storage/buffer/freelist.c,v 1.65 2008/11/06 20:51:15 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -384,6 +384,9 @@ GetAccessStrategy(BufferAccessStrategyType btype) case BAS_BULKREAD: ring_size = 256 * 1024 / BLCKSZ; break; + case BAS_BULKWRITE: + ring_size = 256 * 1024 / BLCKSZ; + break; case BAS_VACUUM: ring_size = 256 * 1024 / BLCKSZ; break; |