| From: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(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-24 07:20:56 |
| Message-ID: | CANhcyEXBnQs31N2zAH7m9uSNWfOBianZEMEAzi-rj_kQ3B9ihQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Amit,
Thanks for reviewing the patch.
On Thu, 23 Oct 2025 at 16:58, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> 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?
>
I added it as per comment in [1] to increase test coverage. I also do
not see any other existing test in HEAD hitting this error. So I added
this test.
> > > 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?
>
According to the latest discussion. I have removed this test.
Attached the updated patches.
Thanks,
Shlok Kyal
| Attachment | Content-Type | Size |
|---|---|---|
| v8_REL_17-0001-Remove-the-validation-from-the-GUC-check-h.txt | text/plain | 5.3 KB |
| v8_REL_18-0001-Remove-the-validation-from-the-GUC-check-h.txt | text/plain | 5.3 KB |
| v8_HEAD-0001-Remove-the-validation-from-the-GUC-check-hoo.patch | application/octet-stream | 5.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shlok Kyal | 2025-10-24 07:22:18 | Re: issue with synchronized_standby_slots |
| Previous Message | Sergey Prokhorenko | 2025-10-24 07:16:41 | Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions |