pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Wording improvement for recent sesssion identifier SQL query.
3+ messages / 2 participants
[nested] [flat]
* pgsql: Wording improvement for recent sesssion identifier SQL query.
@ 2009-06-03 20:34 Bruce Momjian <momjian@postgresql.org>
0 siblings, 0 replies; 3+ messages in thread
From: momjian@postgresql.org @ 2009-06-03 20:34 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Wording improvement for recent sesssion identifier SQL query.
Modified Files:
--------------
pgsql/doc/src/sgml:
config.sgml (r1.218 -> r1.219)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.218&r2=1.219)
^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Stabilize test of BRIN parallel create
@ 2024-04-16 15:36 Tomas Vondra <tomas.vondra@postgresql.org>
0 siblings, 0 replies; 3+ messages in thread
From: Tomas Vondra @ 2024-04-16 15:36 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Stabilize test of BRIN parallel create
The test for parallel create of BRIN indexes added by commit 8225c2fd40
happens to be unstable - a background transaction (e.g. auto-analyze)
may hold back global xmin for the initial VACUUM / CREATE INDEX. If the
cleanup happens before the next CREATE INDEX, the indexes will not be
exactly the same.
This is the same issue as e2933a6e11, so fix it the same way by making
the table TEMPORARY, which uses an up-to-date cutoff xmin that is not
held back by other processes.
Reported by Alexander Lakhin, who also suggested the fix.
Author: Alexander Lakhin
Discussion: https://postgr.es/m/b58901cd-a7cc-29c6-e2b1-e3d7317c3c69@gmail.com
Discussion: https://postgr.es/m/2892135.1668976646@sss.pgh.pa.us
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/4d916dd876c3d9a4ceff5a0c54c5c58a0d1052e3
Modified Files
--------------
contrib/pageinspect/expected/brin.out | 2 +-
contrib/pageinspect/sql/brin.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Stabilize test of BRIN parallel create
@ 2024-04-17 14:20 Tomas Vondra <tomas.vondra@postgresql.org>
0 siblings, 0 replies; 3+ messages in thread
From: Tomas Vondra @ 2024-04-17 14:20 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Stabilize test of BRIN parallel create
As explained in 4d916dd876, the test instability is caused by delayed
cleanup of deleted rows. This commit removes the DELETE, stabilizing the
test without accidentally disabling parallel builds.
The intent of the delete however was to produce empty ranges, and test
that the parallel index build populates those correctly. But there's
another way to create empty ranges - partial indexes, which does not
rely on cleanup of deleted rows.
Idea to use partial indexes by Matthias van de Meent, patch by me.
Discussion: https://postgr.es/m/95d9cd43-5a92-407c-b7e4-54cd303630fe%40enterprisedb.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/0bd4b0689ba1f12fbbd9919ca76a71df3e7702a2
Modified Files
--------------
contrib/pageinspect/expected/brin.out | 13 ++++++-------
contrib/pageinspect/sql/brin.sql | 15 ++++++---------
2 files changed, 12 insertions(+), 16 deletions(-)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-04-17 14:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-06-03 20:34 pgsql: Wording improvement for recent sesssion identifier SQL query. Bruce Momjian <momjian@postgresql.org>
2024-04-16 15:36 pgsql: Stabilize test of BRIN parallel create Tomas Vondra <tomas.vondra@postgresql.org>
2024-04-17 14:20 pgsql: Stabilize test of BRIN parallel create Tomas Vondra <tomas.vondra@postgresql.org>
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