diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-06-08 18:23:53 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-06-08 18:23:53 +0000 |
| commit | a04a423599b347325f9a73dfb2d533b24e1cbab3 (patch) | |
| tree | 5aeb620900a705222eb202c7b4b1d33266d1c190 /src/backend/storage | |
| parent | 6d6d14b6d52f7a709fba8fd23244a7de014f2048 (diff) | |
| download | postgresql-a04a423599b347325f9a73dfb2d533b24e1cbab3.tar.gz | |
Arrange for large sequential scans to synchronize with each other, so that
when multiple backends are scanning the same relation concurrently, each page
is (ideally) read only once.
Jeff Davis, with review by Heikki and Tom.
Diffstat (limited to 'src/backend/storage')
| -rw-r--r-- | src/backend/storage/buffer/freelist.c | 5 | ||||
| -rw-r--r-- | src/backend/storage/ipc/ipci.c | 5 |
2 files changed, 8 insertions, 2 deletions
diff --git a/src/backend/storage/buffer/freelist.c b/src/backend/storage/buffer/freelist.c index d8eec0f823..a3e2c7c442 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.59 2007/05/30 20:11:59 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/storage/buffer/freelist.c,v 1.60 2007/06/08 18:23:52 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -340,6 +340,9 @@ GetAccessStrategy(BufferAccessStrategyType btype) * Select ring size to use. See buffer/README for rationales. * (Currently all cases are the same size, but keep this code * structure for flexibility.) + * + * Note: if you change the ring size for BAS_BULKREAD, see also + * SYNC_SCAN_REPORT_INTERVAL in access/heap/syncscan.c. */ switch (btype) { diff --git a/src/backend/storage/ipc/ipci.c b/src/backend/storage/ipc/ipci.c index 0296cbbcfc..86c54448e4 100644 --- a/src/backend/storage/ipc/ipci.c +++ b/src/backend/storage/ipc/ipci.c @@ -8,13 +8,14 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/storage/ipc/ipci.c,v 1.91 2007/02/15 23:23:23 alvherre Exp $ + * $PostgreSQL: pgsql/src/backend/storage/ipc/ipci.c,v 1.92 2007/06/08 18:23:52 tgl Exp $ * *------------------------------------------------------------------------- */ #include "postgres.h" #include "access/clog.h" +#include "access/heapam.h" #include "access/multixact.h" #include "access/nbtree.h" #include "access/subtrans.h" @@ -112,6 +113,7 @@ CreateSharedMemoryAndSemaphores(bool makePrivate, int port) size = add_size(size, BgWriterShmemSize()); size = add_size(size, AutoVacuumShmemSize()); size = add_size(size, BTreeShmemSize()); + size = add_size(size, SyncScanShmemSize()); #ifdef EXEC_BACKEND size = add_size(size, ShmemBackendArraySize()); #endif @@ -216,6 +218,7 @@ CreateSharedMemoryAndSemaphores(bool makePrivate, int port) * Set up other modules that need some shared memory space */ BTreeShmemInit(); + SyncScanShmemInit(); #ifdef EXEC_BACKEND |