Re: Simplify the logic a bit (src/bin/scripts/reindexdb.c)

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

In response to

Browse pgsql-hackers by date

  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