0001-Force-VACUUM-to-avoid-zeroed-pages-from-bulk-extensi.patch
application/octet-stream
Filename: 0001-Force-VACUUM-to-avoid-zeroed-pages-from-bulk-extensi.patch
Type: application/octet-stream
Part: 0
Message:
Re: POC: GROUP BY optimization
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0001
Subject: Force VACUUM to avoid zeroed pages from bulk extension mess with planning.
| File | + | − |
|---|---|---|
| src/test/regress/expected/aggregates.out | 1 | 1 |
| src/test/regress/sql/aggregates.sql | 1 | 1 |
From 4352e08c22ffc19d764e037967f164e8e58dba5d Mon Sep 17 00:00:00 2001 From: Maxim Orlov <orlovmg@gmail.com> Date: Wed, 21 Feb 2024 17:58:26 +0300 Subject: [PATCH] Force VACUUM to avoid zeroed pages from bulk extension mess with planning. --- src/test/regress/expected/aggregates.out | 2 +- src/test/regress/sql/aggregates.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index dba6f23001..7f387e3023 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -2736,7 +2736,7 @@ CREATE TABLE btg AS SELECT i AS w FROM generate_series(1,10000) AS i; CREATE INDEX btg_x_y_idx ON btg(x,y); -ANALYZE btg; +VACUUM ANALYZE btg; -- GROUP BY optimization by reorder columns by frequency SET enable_hashagg=off; SET max_parallel_workers= 0; diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index d6ed5d0eff..31e73ec1f1 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -1189,7 +1189,7 @@ CREATE TABLE btg AS SELECT i AS w FROM generate_series(1,10000) AS i; CREATE INDEX btg_x_y_idx ON btg(x,y); -ANALYZE btg; +VACUUM ANALYZE btg; -- GROUP BY optimization by reorder columns by frequency -- 2.43.0