From: | Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> |
---|---|
To: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c) |
Date: | 2025-02-28 13:30:54 |
Message-ID: | CAEudQAoXZGQNgk2M4rW3vs_C5_X9Y09QsYawZLRxV15W+D329Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Álvaro.
Em qui., 27 de fev. de 2025 às 16:50, Álvaro Herrera <
alvherre(at)alvh(dot)no-ip(dot)org> escreveu:
> On 2025-Feb-14, Ranier Vilela wrote:
>
> > Attached is the prototype version v1.
> > What do you think?
>
> I think this is still a bit confused. The new function's comment says
> "prepare the list of tables to ..." but what it really receives is a
> list of _indexes_ (as evidenced by the fact that they're compared to
> pg_index.indexrelid). So on input the user_list is an index list, and
> on output it has been changed into a list of tables, and the list of
> indexes is the function's return value? That seems quite weird.
Yeah, I think that is confusing.
I
> propose to change the API of this new function thus:
>
> static void
> get_parallel_tabidx_list(PGconn *conn,
> SimpleStringList *index_list,
> SimpleStringList *table_list,
> bool echo);
>
> where index_list is inout and the table_list is just an output argument.
>
Ok.
>
> I would also remove the 'type' argument, because I don't see a need to
> keep it.
>
Ok.
Thanks for your guidance.
v2 attached, please comment if you have any further objections.
best regards,
Ranier Vilela
Attachment | Content-Type | Size |
---|---|---|
v2-simplifies-reindex-one-database-reindexdb.patch | application/octet-stream | 10.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Srinath Reddy | 2025-02-28 13:36:29 | Re: bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite |
Previous Message | Álvaro Herrera | 2025-02-28 13:13:23 | Re: Get rid of WALBufMappingLock |