v1-0001-Create-test-tables-as-temporary-to-avoid-autovacu.patch
application/octet-stream
Filename: v1-0001-Create-test-tables-as-temporary-to-avoid-autovacu.patch
Type: application/octet-stream
Part: 0
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 v1-0001
Subject: Create test tables as temporary to avoid autovacuum hazards.
| File | + | − |
|---|---|---|
| contrib/pg_visibility/expected/pg_visibility.out | 1 | 1 |
| contrib/pg_visibility/sql/pg_visibility.sql | 1 | 1 |
From efe9ff708e43d746a0cd9908f505672a16ac348d Mon Sep 17 00:00:00 2001
From: reshke <reshke@double.cloud>
Date: Sat, 31 Jan 2026 05:06:49 +0000
Subject: [PATCH v1] Create test tables as temporary to avoid autovacuum
hazards.
---
contrib/pg_visibility/expected/pg_visibility.out | 2 +-
contrib/pg_visibility/sql/pg_visibility.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/contrib/pg_visibility/expected/pg_visibility.out b/contrib/pg_visibility/expected/pg_visibility.out
index e10f1706015..d26f0ab7589 100644
--- a/contrib/pg_visibility/expected/pg_visibility.out
+++ b/contrib/pg_visibility/expected/pg_visibility.out
@@ -207,7 +207,7 @@ select pg_truncate_visibility_map('test_partition');
-- test the case where vacuum phase I does not need to modify the heap buffer
-- and only needs to set the VM
-create table test_vac_unmodified_heap(a int);
+create temp table test_vac_unmodified_heap(a int);
insert into test_vac_unmodified_heap values (1);
vacuum (freeze) test_vac_unmodified_heap;
select pg_visibility_map_summary('test_vac_unmodified_heap');
diff --git a/contrib/pg_visibility/sql/pg_visibility.sql b/contrib/pg_visibility/sql/pg_visibility.sql
index 57af8a0c5b6..0888adb96a6 100644
--- a/contrib/pg_visibility/sql/pg_visibility.sql
+++ b/contrib/pg_visibility/sql/pg_visibility.sql
@@ -97,7 +97,7 @@ select pg_truncate_visibility_map('test_partition');
-- test the case where vacuum phase I does not need to modify the heap buffer
-- and only needs to set the VM
-create table test_vac_unmodified_heap(a int);
+create temp table test_vac_unmodified_heap(a int);
insert into test_vac_unmodified_heap values (1);
vacuum (freeze) test_vac_unmodified_heap;
select pg_visibility_map_summary('test_vac_unmodified_heap');
--
2.43.0