postgresql-9.5 (9.5.25-0ubuntu0.16.04.1) xenial; urgency=medium
* New upstream version (LP: #1915254)
+ Fix CREATE INDEX CONCURRENTLY to wait for
concurrent prepared transactions (Andrey Borodin)
At the point where CREATE INDEX CONCURRENTLY
waits for all concurrent transactions to complete so that it can see
rows they inserted, it must also wait for all prepared transactions
to complete, for the same reason. Its failure to do so meant that
rows inserted by prepared transactions might be omitted from the new
index, causing queries relying on the index to miss such rows.
In installations that have enabled prepared transactions
(max_prepared_transactions > 0),
it's recommended to reindex any concurrently-built indexes in
case this problem occurred when they were built.
+ Details about this and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-25.html
Date: Wed, 10 Feb 2021 11:47:36 +0100
Changed-By: Christian Ehrhardt <christian.ehrha...@canonical.com>
Maintainer: Ubuntu Developers <ubuntu-devel-disc...@lists.ubuntu.com>
https://launchpad.net/ubuntu/+source/postgresql-9.5/9.5.25-0ubuntu0.16.04.1
Format: 1.8
Date: Wed, 10 Feb 2021 11:47:36 +0100
Source: postgresql-9.5
Architecture: source
Version: 9.5.25-0ubuntu0.16.04.1
Distribution: xenial
Urgency: medium
Maintainer: Ubuntu Developers <ubuntu-devel-disc...@lists.ubuntu.com>
Changed-By: Christian Ehrhardt <christian.ehrha...@canonical.com>
Launchpad-Bugs-Fixed: 1915254
Changes:
postgresql-9.5 (9.5.25-0ubuntu0.16.04.1) xenial; urgency=medium
.
* New upstream version (LP: #1915254)
+ Fix CREATE INDEX CONCURRENTLY to wait for
concurrent prepared transactions (Andrey Borodin)
.
At the point where CREATE INDEX CONCURRENTLY
waits for all concurrent transactions to complete so that it can see
rows they inserted, it must also wait for all prepared transactions
to complete, for the same reason. Its failure to do so meant that
rows inserted by prepared transactions might be omitted from the new
index, causing queries relying on the index to miss such rows.
In installations that have enabled prepared transactions
(max_prepared_transactions > 0),
it's recommended to reindex any concurrently-built indexes in
case this problem occurred when they were built.
.
+ Details about this and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-25.html
Checksums-Sha1:
51f08f10a94da3d5f5a14527a66107814da593d4 3777
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.dsc
06775dad91cff791d54f07aef4499eb844843932 17923796
postgresql-9.5_9.5.25.orig.tar.bz2
05ac1d52f3650f9e351e9fd24be6a1e416f6a0a2 28708
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.debian.tar.xz
63d4296a5b404a9be599e045eec75b232047a8ee 8225
postgresql-9.5_9.5.25-0ubuntu0.16.04.1_source.buildinfo
Checksums-Sha256:
e11e859a85ac36983a1fc2649ad855e699d90e2a68e0fdd73ede5b9c310b1467 3777
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.dsc
7628c55eb23768a2c799c018988d8f2ab48ee3d80f5e11259938f7a935f0d603 17923796
postgresql-9.5_9.5.25.orig.tar.bz2
889866ece7d22d7ba376782333b900198048856f0d112d1d0e007b2406b10f97 28708
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.debian.tar.xz
e566a4a36f9a05fc1316d0825f933991ab60fd6f2edfd69851eb0856a4deed5d 8225
postgresql-9.5_9.5.25-0ubuntu0.16.04.1_source.buildinfo
Files:
be6c9699f23ab675ffca25ea5f31c021 3777 database optional
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.dsc
c7a30da52669780e435a029c2f918df0 17923796 database optional
postgresql-9.5_9.5.25.orig.tar.bz2
3967adb4d400f62a9d8827716411eeca 28708 database optional
postgresql-9.5_9.5.25-0ubuntu0.16.04.1.debian.tar.xz
e9c78dfb042823a3c734fd875b449a2e 8225 database optional
postgresql-9.5_9.5.25-0ubuntu0.16.04.1_source.buildinfo
Original-Maintainer: Debian PostgreSQL Maintainers
<pkg-postgresql-pub...@lists.alioth.debian.org>
--
Xenial-changes mailing list
Xenial-changes@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/xenial-changes
