Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Optimize pg_visibility with read streams. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Optimize pg_visibility with read streams.
Date
Msg-id E1so9Hj-000VJW-04@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Optimize pg_visibility with read streams.

We've measured 5% performance improvement, and this arranges to benefit
automatically from future optimizations to the read_stream subsystem.
The area lacked test coverage, so close that gap.

Nazir Bilal Yavuz

Discussion: https://postgr.es/m/CAN55FZ1_Ru3XpMgTwsU67FTH2fs_FrRROmb7x6zs+F44QBEiww@mail.gmail.com
Discussion: https://postgr.es/m/CAEudQAozv3wTY5TV2t29JcwPydbmKbiWQkZD42S2OgzdixPMDQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/65c310b310a613d86c1ba94891fa9972587e09fd

Modified Files
--------------
contrib/pg_visibility/meson.build         |   1 +
contrib/pg_visibility/pg_visibility.c     | 113 ++++++++++++++++++++++++------
contrib/pg_visibility/t/002_corrupt_vm.pl | 109 ++++++++++++++++++++++++++++
3 files changed, 202 insertions(+), 21 deletions(-)

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Use a hash table to de-duplicate column names in ruleutils.c.
Next
From: Amit Kapila
Date:
Subject: pgsql: Improve assertion in FindReplTupleInLocalRel().