Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?

Sami Imseih <samimseih@gmail.com>

From: Sami Imseih <samimseih@gmail.com>
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-01-08T17:36:51Z
Lists: pgsql-hackers

Attachments

> s/parallel vacuum workers for index vacuuming/parallel workers for index creation/?

oops, that's my oversight from copying the message from vacuum. fixed.

> I'd add "in parallel" to match its counterpart "serially" above. That would
> make it more clear in case one just look for "building index" in the log.

good point.

Below is the new output with the attached v2.

postgres=# create index foo_idx1 on foo(id);
DEBUG:  building index "foo_idx1" on table "foo" with parallel workers
DEBUG:  launched 1 parallel workers for index creation (planned: 1)
DEBUG:  index "foo_idx1" can safely use deduplication
CREATE INDEX

Regards,

Sami