Re: Add Index-level REINDEX with multiple jobs

2024-03-25 Thread Alexander Korotkov
On Mon, Mar 25, 2024 at 4:47 AM Richard Guo wrote: > On Mon, Mar 25, 2024 at 10:07 AM Tom Lane wrote: >> >> Alexander Korotkov writes: >> > Here goes the revised patch. I'm going to push this if there are no >> > objections. >> >> Quite a lot of the buildfarm is complaining about this: >> >> r

Re: Add Index-level REINDEX with multiple jobs

2024-03-24 Thread Richard Guo
On Mon, Mar 25, 2024 at 10:07 AM Tom Lane wrote: > Alexander Korotkov writes: > > Here goes the revised patch. I'm going to push this if there are no > objections. > > Quite a lot of the buildfarm is complaining about this: > > reindexdb.c: In function 'reindex_one_database': > reindexdb.c:434:

Re: Add Index-level REINDEX with multiple jobs

2024-03-24 Thread Tom Lane
Alexander Korotkov writes: > Here goes the revised patch. I'm going to push this if there are no > objections. Quite a lot of the buildfarm is complaining about this: reindexdb.c: In function 'reindex_one_database': reindexdb.c:434:54: error: 'indices_tables_cell' may be used uninitialized in

Re: Add Index-level REINDEX with multiple jobs

2024-03-22 Thread Alexander Korotkov
On Wed, Mar 20, 2024 at 7:19 PM Alexander Korotkov wrote: > On Mon, Mar 11, 2024 at 3:44 PM Maxim Orlov wrote: > > On Tue, 6 Feb 2024 at 09:22, Michael Paquier wrote: > >> The problem may be actually trickier than that, no? Could there be > >> other factors to take into account for their classi

Re: Add Index-level REINDEX with multiple jobs

2024-03-20 Thread Alexander Korotkov
On Mon, Mar 11, 2024 at 3:44 PM Maxim Orlov wrote: > On Tue, 6 Feb 2024 at 09:22, Michael Paquier wrote: >> The problem may be actually trickier than that, no? Could there be >> other factors to take into account for their classification, like >> their sizes (typically, we'd want to process the

Re: Add Index-level REINDEX with multiple jobs

2024-03-11 Thread Maxim Orlov
On Tue, 6 Feb 2024 at 09:22, Michael Paquier wrote: > > The problem may be actually trickier than that, no? Could there be > other factors to take into account for their classification, like > their sizes (typically, we'd want to process the biggest one first, I > guess)? Sorry for a late repl

Re: Add Index-level REINDEX with multiple jobs

2024-03-11 Thread Svetlana Derevyanko
Andrey M. Borodin писал(а) 2024-03-04 09:26: On 6 Feb 2024, at 11:21, Michael Paquier wrote: The problem may be actually trickier than that, no? Could there be other factors to take into account for their classification, like their sizes (typically, we'd want to process the biggest one first,

Re: Add Index-level REINDEX with multiple jobs

2024-03-03 Thread Andrey M. Borodin
> On 6 Feb 2024, at 11:21, Michael Paquier wrote: > > The problem may be actually trickier than that, no? Could there be > other factors to take into account for their classification, like > their sizes (typically, we'd want to process the biggest one first, I > guess)? Maxim, what do you thi

Re: Add Index-level REINDEX with multiple jobs

2024-02-05 Thread Michael Paquier
On Fri, Dec 29, 2023 at 04:15:35PM +0300, Maxim Orlov wrote: > Recently, one of our customers came to us with the question: why do reindex > utility does not support multiple jobs for indices (-i opt)? > And, of course, it is because we cannot control the concurrent processing > of multiple indexes