Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita8501ba

Browse files
committed
Update pgstattuple extension for parallel query.
All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson
1 parent496899c commita8501ba

File tree

4 files changed

+25
-10
lines changed

4 files changed

+25
-10
lines changed

‎contrib/pgstattuple/Makefile‎

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,9 @@ MODULE_big= pgstattuple
44
OBJS= pgstattuple.o pgstatindex.o pgstatapprox.o$(WIN32RES)
55

66
EXTENSION = pgstattuple
7-
DATA = pgstattuple--1.3.sql pgstattuple--1.2--1.3.sql pgstattuple--1.1--1.2.sql pgstattuple--1.0--1.1.sql pgstattuple--unpackaged--1.0.sql
7+
DATA = pgstattuple--1.4.sql pgstattuple--1.3--1.4.sql\
8+
pgstattuple--1.2--1.3.sql pgstattuple--1.1--1.2.sql\
9+
pgstattuple--1.0--1.1.sql pgstattuple--unpackaged--1.0.sql
810
PGFILEDESC = "pgstattuple - tuple-level statistics"
911

1012
REGRESS = pgstattuple
Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
/* contrib/pgstattuple/pgstattuple--1.3--1.4.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION pgstattuple UPDATE TO '1.4'" to load this file. \quit
5+
6+
ALTERFUNCTION pgstattuple(text) PARALLEL SAFE;
7+
ALTERFUNCTION pgstatindex(text) PARALLEL SAFE;
8+
ALTERFUNCTION pg_relpages(text) PARALLEL SAFE;
9+
ALTERFUNCTION pgstatginindex(regclass) PARALLEL SAFE;
10+
ALTERFUNCTION pgstattuple(regclass) PARALLEL SAFE;
11+
ALTERFUNCTION pgstatindex(regclass) PARALLEL SAFE;
12+
ALTERFUNCTION pg_relpages(regclass) PARALLEL SAFE;
13+
ALTERFUNCTION pgstattuple_approx(regclass) PARALLEL SAFE;
Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@ CREATE FUNCTION pgstattuple(IN relname text,
1414
OUT free_spaceBIGINT,-- free space in bytes
1515
OUT free_percent FLOAT8)-- free space in %
1616
AS'MODULE_PATHNAME','pgstattuple'
17-
LANGUAGE C STRICT;
17+
LANGUAGE C STRICT PARALLEL SAFE;
1818

1919
CREATEFUNCTIONpgstatindex(IN relnametext,
2020
OUT versionINT,
@@ -28,12 +28,12 @@ CREATE FUNCTION pgstatindex(IN relname text,
2828
OUT avg_leaf_density FLOAT8,
2929
OUT leaf_fragmentation FLOAT8)
3030
AS'MODULE_PATHNAME','pgstatindex'
31-
LANGUAGE C STRICT;
31+
LANGUAGE C STRICT PARALLEL SAFE;
3232

3333
CREATEFUNCTIONpg_relpages(IN relnametext)
3434
RETURNSBIGINT
3535
AS'MODULE_PATHNAME','pg_relpages'
36-
LANGUAGE C STRICT;
36+
LANGUAGE C STRICT PARALLEL SAFE;
3737

3838
/* New stuff in 1.1 begins here*/
3939

@@ -42,7 +42,7 @@ CREATE FUNCTION pgstatginindex(IN relname regclass,
4242
OUT pending_pages INT4,
4343
OUT pending_tuplesBIGINT)
4444
AS'MODULE_PATHNAME','pgstatginindex'
45-
LANGUAGE C STRICT;
45+
LANGUAGE C STRICT PARALLEL SAFE;
4646

4747
/* New stuff in 1.2 begins here*/
4848

@@ -57,7 +57,7 @@ CREATE FUNCTION pgstattuple(IN reloid regclass,
5757
OUT free_spaceBIGINT,-- free space in bytes
5858
OUT free_percent FLOAT8)-- free space in %
5959
AS'MODULE_PATHNAME','pgstattuplebyid'
60-
LANGUAGE C STRICT;
60+
LANGUAGE C STRICT PARALLEL SAFE;
6161

6262
CREATEFUNCTIONpgstatindex(IN relname regclass,
6363
OUT versionINT,
@@ -71,12 +71,12 @@ CREATE FUNCTION pgstatindex(IN relname regclass,
7171
OUT avg_leaf_density FLOAT8,
7272
OUT leaf_fragmentation FLOAT8)
7373
AS'MODULE_PATHNAME','pgstatindexbyid'
74-
LANGUAGE C STRICT;
74+
LANGUAGE C STRICT PARALLEL SAFE;
7575

7676
CREATEFUNCTIONpg_relpages(IN relname regclass)
7777
RETURNSBIGINT
7878
AS'MODULE_PATHNAME','pg_relpagesbyid'
79-
LANGUAGE C STRICT;
79+
LANGUAGE C STRICT PARALLEL SAFE;
8080

8181
/* New stuff in 1.3 begins here*/
8282

@@ -92,4 +92,4 @@ CREATE FUNCTION pgstattuple_approx(IN reloid regclass,
9292
OUT approx_free_spaceBIGINT,-- estimated free space in bytes
9393
OUT approx_free_percent FLOAT8)-- free space in % (based on estimate)
9494
AS'MODULE_PATHNAME','pgstattuple_approx'
95-
LANGUAGE C STRICT;
95+
LANGUAGE C STRICT PARALLEL SAFE;
Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# pgstattuple extension
22
comment = 'show tuple-level statistics'
3-
default_version = '1.3'
3+
default_version = '1.4'
44
module_pathname = '$libdir/pgstattuple'
55
relocatable = true

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp