pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Refactor ExecProject and associated routines so that fast-path
7+ messages / 2 participants
[nested] [flat]
* pgsql: Refactor ExecProject and associated routines so that fast-path
@ 2009-04-02 22:39 Tom Lane <tgl@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: tgl@postgresql.org @ 2009-04-02 22:39 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Refactor ExecProject and associated routines so that fast-path code is used
for simple Var targetlist entries all the time, even when there are other
entries that are not simple Vars. Also, ensure that we prefetch attributes
(with slot_getsomeattrs) for all Vars in the targetlist, even those buried
within expressions. In combination these changes seem to significantly
reduce the runtime for cases where tlists are mostly but not exclusively
Vars. Per my proposal of yesterday.
Modified Files:
--------------
pgsql/src/backend/executor:
execQual.c (r1.243 -> r1.244)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execQual.c?r1=1.243&r2=1.244)
execUtils.c (r1.157 -> r1.158)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execUtils.c?r1=1.157&r2=1.15...)
pgsql/src/include/nodes:
execnodes.h (r1.202 -> r1.203)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h?r1=1.202&r2=1.203)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:08 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:08 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/d603e674462d7c4df0e88b7a61d4ae14ae3ed191
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:09 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:09 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
REL_13_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/5cc1f2626369536c191009bf084c9d1f456abc7a
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:09 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:09 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/4e8529da48baf780f2a2c7e0255a0c9ea02b0d11
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:09 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:09 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/0d466bce9ee19a5f7ef6c2964376aa6572ef76fd
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:09 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:09 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
REL_16_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/3676b846b129b975034927cdf5f57297211d6f15
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: amcheck: Normalize index tuples containing uncompressed varlena
@ 2024-03-23 22:11 Alexander Korotkov <akorotkov@postgresql.org>
0 siblings, 0 replies; 7+ messages in thread
From: Alexander Korotkov @ 2024-03-23 22:11 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
amcheck: Normalize index tuples containing uncompressed varlena
It might happen that the varlena value wasn't compressed by index_form_tuple()
due to current storage parameters. If compression is currently enabled, we
need to compress such values to match index tuple coming from the heap.
Backpatch to all supported versions.
Discussion: https://postgr.es/m/flat/7bdbe559-d61a-4ae4-a6e1-48abdf3024cc%40postgrespro.ru
Author: Andrey Borodin
Reviewed-by: Alexander Lakhin, Michael Zhilin, Jian He, Alexander Korotkov
Backpatch-through: 12
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/b1fe8efdf17eb4877f7c4c31c85111ec740ad872
Modified Files
--------------
contrib/amcheck/expected/check_btree.out | 10 ++++++++++
contrib/amcheck/sql/check_btree.sql | 6 ++++++
contrib/amcheck/verify_nbtree.c | 13 +++++++++++++
3 files changed, 29 insertions(+)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-03-23 22:11 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-02 22:39 pgsql: Refactor ExecProject and associated routines so that fast-path Tom Lane <tgl@postgresql.org>
2024-03-23 22:08 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@postgresql.org>
2024-03-23 22:09 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@postgresql.org>
2024-03-23 22:09 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@postgresql.org>
2024-03-23 22:09 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@postgresql.org>
2024-03-23 22:09 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@postgresql.org>
2024-03-23 22:11 pgsql: amcheck: Normalize index tuples containing uncompressed varlena Alexander Korotkov <akorotkov@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