agora inbox for [email protected]help / color / mirror / Atom feed
[PATCH v6 03/10] Fix docs: "time of the" 4+ messages / 2 participants [nested] [flat]
* [PATCH v6 03/10] Fix docs: "time of the" @ 2020-04-06 03:35 Justin Pryzby <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Justin Pryzby @ 2020-04-06 03:35 UTC (permalink / raw) commit 9e257a181cc1dc5e19eb5d770ce09cc98f470f5f Author: Andrew Dunstan <[email protected]> Date: Sun Mar 24 11:27:20 2013 -0400 Add parallel pg_dump option. commit 5ab892c391c6bc54a00e7a8de5cab077cabace6a Author: Michael Paquier <[email protected]> Date: Sat Jul 27 22:21:18 2019 +0900 Add support for --jobs in reindexdb commit a17923204736d8842eade3517d6a8ee81290fca4 Author: Alvaro Herrera <[email protected]> Date: Fri Jan 23 15:02:45 2015 -0300 vacuumdb: enable parallel mode --- doc/src/sgml/ref/pg_dump.sgml | 2 +- doc/src/sgml/ref/reindexdb.sgml | 4 ++-- doc/src/sgml/ref/vacuumdb.sgml | 4 ++-- 3 files changed, 5 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 7a37fd8045..77029defc5 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -322,7 +322,7 @@ PostgreSQL documentation <listitem> <para> Run the dump in parallel by dumping <replaceable class="parameter">njobs</replaceable> - tables simultaneously. This option reduces the time of the dump but it also + tables simultaneously. This option may reduces the time needed to perform the dump but it also increases the load on the database server. You can only use this option with the directory output format because this is the only output format where multiple processes can write their data at the same time. diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 026fd018d9..4f821c2095 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -174,8 +174,8 @@ PostgreSQL documentation <para> Execute the reindex commands in parallel by running <replaceable class="parameter">njobs</replaceable> - commands simultaneously. This option reduces the time of the - processing but it also increases the load on the database server. + commands simultaneously. This option may reduce the processing time + but it also increases the load on the database server. </para> <para> <application>reindexdb</application> will open diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 95d6894cb0..7b13950552 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -155,8 +155,8 @@ PostgreSQL documentation <para> Execute the vacuum or analyze commands in parallel by running <replaceable class="parameter">njobs</replaceable> - commands simultaneously. This option reduces the time of the - processing but it also increases the load on the database server. + commands simultaneously. This option may reduce the processing time + but it also increases the load on the database server. </para> <para> <application>vacuumdb</application> will open -- 2.17.0 --C+ts3FVlLX8+P6JN Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v6-0004-doc-Allow-users-to-limit-storage-reserved-by-repl.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
* [PATCH v68 08/31] pgstat: introduce PgStat_Kind enum. @ 2022-04-01 20:43 Andres Freund <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Andres Freund @ 2022-04-01 20:43 UTC (permalink / raw) Will be used by following commits to generalize stats infrastructure. --- src/include/pgstat.h | 27 +++++++++++++++++++++++++++ src/tools/pgindent/typedefs.list | 1 + 2 files changed, 28 insertions(+) diff --git a/src/include/pgstat.h b/src/include/pgstat.h index ed37523ce17..1d03bd97de4 100644 --- a/src/include/pgstat.h +++ b/src/include/pgstat.h @@ -33,6 +33,33 @@ /* Default directory to store temporary statistics data in */ #define PG_STAT_TMP_DIR "pg_stat_tmp" +/* The types of statistics entries */ +typedef enum PgStat_Kind +{ + /* + * Don't define an INVALID value so switch() statements can warn if some + * cases aren't covered. But define the first member to 1 so that + * uninitialized values can be detected more easily. + */ + + /* stats with a variable number of entries */ + PGSTAT_KIND_DATABASE = 1, /* database-wide statistics */ + PGSTAT_KIND_RELATION, /* per-table statistics */ + PGSTAT_KIND_FUNCTION, /* per-function statistics */ + PGSTAT_KIND_REPLSLOT, /* per-slot statistics */ + PGSTAT_KIND_SUBSCRIPTION, /* per-subscription statistics */ + + /* stats with a constant number of entries */ + PGSTAT_KIND_ARCHIVER, + PGSTAT_KIND_BGWRITER, + PGSTAT_KIND_CHECKPOINTER, + PGSTAT_KIND_SLRU, + PGSTAT_KIND_WAL, +} PgStat_Kind; + +#define PGSTAT_KIND_FIRST PGSTAT_KIND_DATABASE +#define PGSTAT_KIND_LAST PGSTAT_KIND_WAL +#define PGSTAT_NUM_KINDS (PGSTAT_KIND_LAST + 1) /* Values for track_functions GUC variable --- order is significant! */ typedef enum TrackFunctionsLevel diff --git a/src/tools/pgindent/typedefs.list b/src/tools/pgindent/typedefs.list index 72fafb795bb..a5c15a1d68f 100644 --- a/src/tools/pgindent/typedefs.list +++ b/src/tools/pgindent/typedefs.list @@ -1931,6 +1931,7 @@ PgStat_FunctionCallUsage PgStat_FunctionCounts PgStat_FunctionEntry PgStat_GlobalStats +PgStat_Kind PgStat_Msg PgStat_MsgAnalyze PgStat_MsgAnlAncestors -- 2.35.1.677.gabf474a5dd --c4n45bccvxafocvc Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v68-0009-pgstat-prepare-APIs-used-by-pgstatfuncs-for-shar.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
* [PATCH v70 06/27] pgstat: introduce PgStat_Kind enum. @ 2022-04-01 20:43 Andres Freund <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Andres Freund @ 2022-04-01 20:43 UTC (permalink / raw) Will be used by following commits to generalize stats infrastructure. Kept separate to allow commits stand reasonably on their own. --- src/include/pgstat.h | 27 +++++++++++++++++++++++++++ src/tools/pgindent/typedefs.list | 1 + 2 files changed, 28 insertions(+) diff --git a/src/include/pgstat.h b/src/include/pgstat.h index 45eb217958e..dde76f237de 100644 --- a/src/include/pgstat.h +++ b/src/include/pgstat.h @@ -33,6 +33,33 @@ /* Default directory to store temporary statistics data in */ #define PG_STAT_TMP_DIR "pg_stat_tmp" +/* The types of statistics entries */ +typedef enum PgStat_Kind +{ + /* + * Don't define an INVALID value so switch() statements can warn if some + * cases aren't covered. But define the first member to 1 so that + * uninitialized values can be detected more easily. + */ + + /* stats for variable-numbered objects */ + PGSTAT_KIND_DATABASE = 1, /* database-wide statistics */ + PGSTAT_KIND_RELATION, /* per-table statistics */ + PGSTAT_KIND_FUNCTION, /* per-function statistics */ + PGSTAT_KIND_REPLSLOT, /* per-slot statistics */ + PGSTAT_KIND_SUBSCRIPTION, /* per-subscription statistics */ + + /* stats for constant-numbered objects */ + PGSTAT_KIND_ARCHIVER, + PGSTAT_KIND_BGWRITER, + PGSTAT_KIND_CHECKPOINTER, + PGSTAT_KIND_SLRU, + PGSTAT_KIND_WAL, +} PgStat_Kind; + +#define PGSTAT_KIND_FIRST PGSTAT_KIND_DATABASE +#define PGSTAT_KIND_LAST PGSTAT_KIND_WAL +#define PGSTAT_NUM_KINDS (PGSTAT_KIND_LAST + 1) /* Values for track_functions GUC variable --- order is significant! */ typedef enum TrackFunctionsLevel diff --git a/src/tools/pgindent/typedefs.list b/src/tools/pgindent/typedefs.list index 9b4f77fbf18..e1684d4caec 100644 --- a/src/tools/pgindent/typedefs.list +++ b/src/tools/pgindent/typedefs.list @@ -1942,6 +1942,7 @@ PgStat_FunctionCallUsage PgStat_FunctionCounts PgStat_FunctionEntry PgStat_GlobalStats +PgStat_Kind PgStat_Msg PgStat_MsgAnalyze PgStat_MsgAnlAncestors -- 2.35.1.677.gabf474a5dd --vl7on5vfmrsyxmos Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v70-0007-pgstat-prepare-APIs-used-by-pgstatfuncs-for-shar.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
* [PATCH v69 05/28] pgstat: introduce PgStat_Kind enum. @ 2022-04-01 20:43 Andres Freund <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Andres Freund @ 2022-04-01 20:43 UTC (permalink / raw) Will be used by following commits to generalize stats infrastructure. Kept separate to allow commits stand reasonably on their own. --- src/include/pgstat.h | 27 +++++++++++++++++++++++++++ src/tools/pgindent/typedefs.list | 1 + 2 files changed, 28 insertions(+) diff --git a/src/include/pgstat.h b/src/include/pgstat.h index ed37523ce17..0139aaea937 100644 --- a/src/include/pgstat.h +++ b/src/include/pgstat.h @@ -33,6 +33,33 @@ /* Default directory to store temporary statistics data in */ #define PG_STAT_TMP_DIR "pg_stat_tmp" +/* The types of statistics entries */ +typedef enum PgStat_Kind +{ + /* + * Don't define an INVALID value so switch() statements can warn if some + * cases aren't covered. But define the first member to 1 so that + * uninitialized values can be detected more easily. + */ + + /* stats for variable-numbered objects */ + PGSTAT_KIND_DATABASE = 1, /* database-wide statistics */ + PGSTAT_KIND_RELATION, /* per-table statistics */ + PGSTAT_KIND_FUNCTION, /* per-function statistics */ + PGSTAT_KIND_REPLSLOT, /* per-slot statistics */ + PGSTAT_KIND_SUBSCRIPTION, /* per-subscription statistics */ + + /* stats for constant-numbered objects */ + PGSTAT_KIND_ARCHIVER, + PGSTAT_KIND_BGWRITER, + PGSTAT_KIND_CHECKPOINTER, + PGSTAT_KIND_SLRU, + PGSTAT_KIND_WAL, +} PgStat_Kind; + +#define PGSTAT_KIND_FIRST PGSTAT_KIND_DATABASE +#define PGSTAT_KIND_LAST PGSTAT_KIND_WAL +#define PGSTAT_NUM_KINDS (PGSTAT_KIND_LAST + 1) /* Values for track_functions GUC variable --- order is significant! */ typedef enum TrackFunctionsLevel diff --git a/src/tools/pgindent/typedefs.list b/src/tools/pgindent/typedefs.list index 4b12c575ab5..dc55814dfa2 100644 --- a/src/tools/pgindent/typedefs.list +++ b/src/tools/pgindent/typedefs.list @@ -1939,6 +1939,7 @@ PgStat_FunctionCallUsage PgStat_FunctionCounts PgStat_FunctionEntry PgStat_GlobalStats +PgStat_Kind PgStat_Msg PgStat_MsgAnalyze PgStat_MsgAnlAncestors -- 2.35.1.677.gabf474a5dd --be3jiks7ge4r32o3 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v69-0006-pgstat-prepare-APIs-used-by-pgstatfuncs-for-shar.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-04-01 20:43 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-04-06 03:35 [PATCH v6 03/10] Fix docs: "time of the" Justin Pryzby <[email protected]> 2022-04-01 20:43 [PATCH v68 08/31] pgstat: introduce PgStat_Kind enum. Andres Freund <[email protected]> 2022-04-01 20:43 [PATCH v70 06/27] pgstat: introduce PgStat_Kind enum. Andres Freund <[email protected]> 2022-04-01 20:43 [PATCH v69 05/28] pgstat: introduce PgStat_Kind enum. Andres Freund <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox