pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Fix textsearch documentation examples to not recommend
5+ messages / 2 participants
[nested] [flat]
* pgsql: Fix textsearch documentation examples to not recommend
@ 2009-04-19 20:36 Tom Lane <tgl@postgresql.org>
0 siblings, 0 replies; 5+ messages in thread
From: tgl@postgresql.org @ 2009-04-19 20:36 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Fix textsearch documentation examples to not recommend concatenating separate
fields without putting a space between. Per gripe from Rick Schumeyer.
Modified Files:
--------------
pgsql/doc/src/sgml:
textsearch.sgml (r1.49 -> r1.50)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.49&r2=1.50)
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Fix textsearch documentation examples to not recommend
@ 2009-04-19 20:36 Tom Lane <tgl@postgresql.org>
0 siblings, 0 replies; 5+ messages in thread
From: tgl@postgresql.org @ 2009-04-19 20:36 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Fix textsearch documentation examples to not recommend concatenating separate
fields without putting a space between. Per gripe from Rick Schumeyer.
Tags:
----
REL8_3_STABLE
Modified Files:
--------------
pgsql/doc/src/sgml:
textsearch.sgml (r1.40.2.1 -> r1.40.2.2)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.40.2.1&r2=1.40....)
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object
@ 2024-02-01 08:14 Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Paquier @ 2024-02-01 08:14 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix stats_fetch_consistency with stats for fixed-numbered objects
This impacts the statistics retrieved in transactions for the following
views when updating the value of stats_fetch_consistency, leading to
behaviors contrary to what is documented since 605994651b6a as an update
of this parameter should discard all statistics snapshot data:
- pg_stat_archiver
- pg_stat_bgwriter
- pg_stat_checkpointer
- pg_stat_io
- pg_stat_slru
- pg_stat_wal
For example, updating stats_fetch_consistency from "snapshot" to "cache"
in a transaction did not re-fetch any fresh data, using data cached from
the time when "snapshot" was in use.
Author: Shinya Kato
Discussion: https://postgr.es/m/d77fc5190d4dbe1738d77231488e768b@oss.nttdata.com
Backpatch-through: 15
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/235c09efbb306d6263e904e484abdf44866beb5e
Modified Files
--------------
src/backend/utils/activity/pgstat.c | 3 +++
1 file changed, 3 insertions(+)
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object
@ 2024-02-01 08:14 Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Paquier @ 2024-02-01 08:14 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix stats_fetch_consistency with stats for fixed-numbered objects
This impacts the statistics retrieved in transactions for the following
views when updating the value of stats_fetch_consistency, leading to
behaviors contrary to what is documented since 605994651b6a as an update
of this parameter should discard all statistics snapshot data:
- pg_stat_archiver
- pg_stat_bgwriter
- pg_stat_checkpointer
- pg_stat_io
- pg_stat_slru
- pg_stat_wal
For example, updating stats_fetch_consistency from "snapshot" to "cache"
in a transaction did not re-fetch any fresh data, using data cached from
the time when "snapshot" was in use.
Author: Shinya Kato
Discussion: https://postgr.es/m/d77fc5190d4dbe1738d77231488e768b@oss.nttdata.com
Backpatch-through: 15
Branch
------
REL_16_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/781bc121de897c235ae731ad9f58dfd4075a1008
Modified Files
--------------
src/backend/utils/activity/pgstat.c | 3 +++
1 file changed, 3 insertions(+)
^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object
@ 2024-02-01 08:14 Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Paquier @ 2024-02-01 08:14 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Fix stats_fetch_consistency with stats for fixed-numbered objects
This impacts the statistics retrieved in transactions for the following
views when updating the value of stats_fetch_consistency, leading to
behaviors contrary to what is documented since 605994651b6a as an update
of this parameter should discard all statistics snapshot data:
- pg_stat_archiver
- pg_stat_bgwriter
- pg_stat_checkpointer
- pg_stat_io
- pg_stat_slru
- pg_stat_wal
For example, updating stats_fetch_consistency from "snapshot" to "cache"
in a transaction did not re-fetch any fresh data, using data cached from
the time when "snapshot" was in use.
Author: Shinya Kato
Discussion: https://postgr.es/m/d77fc5190d4dbe1738d77231488e768b@oss.nttdata.com
Backpatch-through: 15
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/171d21f50c3ee3f17911daa3d91eb75363669a11
Modified Files
--------------
src/backend/utils/activity/pgstat.c | 3 +++
1 file changed, 3 insertions(+)
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-02-01 08:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-19 20:36 pgsql: Fix textsearch documentation examples to not recommend Tom Lane <tgl@postgresql.org>
2009-04-19 20:36 pgsql: Fix textsearch documentation examples to not recommend Tom Lane <tgl@postgresql.org>
2024-02-01 08:14 pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object Michael Paquier <michael@paquier.xyz>
2024-02-01 08:14 pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object Michael Paquier <michael@paquier.xyz>
2024-02-01 08:14 pgsql: Fix stats_fetch_consistency with stats for fixed-numbered object Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox