From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
---|---|
To: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
Cc: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Alexander Kukushkin <cyberdemn(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: issue with synchronized_standby_slots |
Date: | 2025-10-23 11:28:18 |
Message-ID: | CAA4eK1LuYdDwW38Tv3mX=XxULsRnjBvROMM6FL1oY0YDF1QgJg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Oct 23, 2025 at 2:58 PM Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> wrote:
>
> On Thu, 23 Oct 2025 at 13:45, Hayato Kuroda (Fujitsu)
> <kuroda(dot)hayato(at)fujitsu(dot)com> wrote:
> >
> > 2.
> > Also, test for PG18 should not have the case which rejects the reserved name.
> >
Why to have that even for HEAD and PG18?
> > 3.
> > ```
> > -- Parallel worker does not throw error during startup.
> > SET min_parallel_table_scan_size TO 0;
> > SET parallel_setup_cost TO 0;
> > SET parallel_tuple_cost TO 0;
> > ```
> >
> > According to contrib/pg_stat_statements/sql/parallel.sql, max_parallel_workers_per_gather
> > should be also set. There is a possiblity that `make installcheck` is used and
> > it has max_parallel_workers_per_gather=0.
> >
+-- Parallel worker does not throw error during startup.
+SET min_parallel_table_scan_size TO 0;
+SET max_parallel_workers_per_gather TO 2;
+SET parallel_setup_cost TO 0;
+SET parallel_tuple_cost TO 0;
+CREATE TABLE t1(a int);
+INSERT INTO t1 VALUES(1), (2), (3), (4);
+SELECT count(*) FROM t1;
Isn't it better to reset these parameters after the test?
--
With Regards,
Amit Kapila.
From | Date | Subject | |
---|---|---|---|
Next Message | Arseniy Mukhin | 2025-10-23 11:39:56 | Re: amcheck: support for GiST |
Previous Message | Amit Kapila | 2025-10-23 11:17:24 | Re: Logical Replication of sequences |