diff options
| author | Alvaro Herrera | 2015-09-08 15:51:42 +0000 |
|---|---|---|
| committer | Alvaro Herrera | 2015-09-08 15:51:42 +0000 |
| commit | 1aba62ec635f5852bc45ce65482366e541e61ff5 (patch) | |
| tree | 1161cc00324cb8d229b831a944432646ae1552d5 /src/include | |
| parent | 665a00c9e2598e3be366cb9f99c0a04a51dd8c7a (diff) | |
Allow per-tablespace effective_io_concurrency
Per discussion, nowadays it is possible to have tablespaces that have
wildly different I/O characteristics from others. Setting different
effective_io_concurrency parameters for those has been measured to
improve performance.
Author: Julien Rouhaud
Reviewed by: Andres Freund
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/commands/tablespace.h | 1 | ||||
| -rw-r--r-- | src/include/nodes/execnodes.h | 4 | ||||
| -rw-r--r-- | src/include/storage/bufmgr.h | 7 | ||||
| -rw-r--r-- | src/include/utils/spccache.h | 1 |
4 files changed, 12 insertions, 1 deletions
diff --git a/src/include/commands/tablespace.h b/src/include/commands/tablespace.h index 6b928a58a01..be9582a2035 100644 --- a/src/include/commands/tablespace.h +++ b/src/include/commands/tablespace.h @@ -39,6 +39,7 @@ typedef struct TableSpaceOpts int32 vl_len_; /* varlena header (do not touch directly!) */ float8 random_page_cost; float8 seq_page_cost; + int effective_io_concurrency; } TableSpaceOpts; extern Oid CreateTableSpace(CreateTableSpaceStmt *stmt); diff --git a/src/include/nodes/execnodes.h b/src/include/nodes/execnodes.h index 5796de861c4..4ae2f3e067b 100644 --- a/src/include/nodes/execnodes.h +++ b/src/include/nodes/execnodes.h @@ -1424,7 +1424,8 @@ typedef struct BitmapIndexScanState * lossy_pages total number of lossy pages retrieved * prefetch_iterator iterator for prefetching ahead of current page * prefetch_pages # pages prefetch iterator is ahead of current - * prefetch_target target prefetch distance + * prefetch_target current target prefetch distance + * prefetch_maximum maximum value for prefetch_target * ---------------- */ typedef struct BitmapHeapScanState @@ -1439,6 +1440,7 @@ typedef struct BitmapHeapScanState TBMIterator *prefetch_iterator; int prefetch_pages; int prefetch_target; + int prefetch_maximum; } BitmapHeapScanState; /* ---------------- diff --git a/src/include/storage/bufmgr.h b/src/include/storage/bufmgr.h index ec0a254566e..0f59201bf5b 100644 --- a/src/include/storage/bufmgr.h +++ b/src/include/storage/bufmgr.h @@ -58,11 +58,17 @@ extern int target_prefetch_pages; /* in buf_init.c */ extern PGDLLIMPORT char *BufferBlocks; +/* in guc.c */ +extern int effective_io_concurrency; + /* in localbuf.c */ extern PGDLLIMPORT int NLocBuffer; extern PGDLLIMPORT Block *LocalBufferBlockPointers; extern PGDLLIMPORT int32 *LocalRefCount; +/* upper limit for effective_io_concurrency */ +#define MAX_IO_CONCURRENCY 1000 + /* special block number for ReadBuffer() */ #define P_NEW InvalidBlockNumber /* grow the file to get a new page */ @@ -144,6 +150,7 @@ extern PGDLLIMPORT int32 *LocalRefCount; /* * prototypes for functions in bufmgr.c */ +extern bool ComputeIoConcurrency(int io_concurrency, double *target); extern void PrefetchBuffer(Relation reln, ForkNumber forkNum, BlockNumber blockNum); extern Buffer ReadBuffer(Relation reln, BlockNumber blockNum); diff --git a/src/include/utils/spccache.h b/src/include/utils/spccache.h index bdd1c0fc063..e466f36d18f 100644 --- a/src/include/utils/spccache.h +++ b/src/include/utils/spccache.h @@ -15,5 +15,6 @@ void get_tablespace_page_costs(Oid spcid, float8 *spc_random_page_cost, float8 *spc_seq_page_cost); +int get_tablespace_io_concurrency(Oid spcid); #endif /* SPCCACHE_H */ |