Re: BUG #15460: Error while creating index or constraint

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #15460: Error while creating index or constraint
Дата
Msg-id CAH2-WzmV0kmPLjV1V+-5pUwDe4zeL14S958xu73knizorVAi4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15460: Error while creating index or constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #15460: Error while creating index or constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Mon, Oct 29, 2018 at 3:31 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > LOG:  performsort of 0 done: CPU: user: 250.03 s, system: 42.66 s, elapsed: 294.35 s
> > LOG:  parallel external sort of 0 ended, 462886 disk blocks used: CPU: user: 250.03 s, system: 42.66 s, elapsed:
298.95s
 
> > LOG:  begin index sort: unique = f, workMem = 2096128, randomAccess = f
> > LOG:  performsort of -1 starting: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
> > LOG:  could not rmdir directory "base/pgsql_tmp/pgsql_tmp5088.0.sharedfileset": Directory not empty
> > ERROR:  could not determine size of temporary file "0"
>
> "performsort of -1"?  Seems a bit suspicious.

This just refers to the leader Tuplesortstate. It isn't suspicious.

We follow the convention that worker -1 is the leader within
tuplesort.c. trace_sort is a developer option, so this seems fine to
me.

-- 
Peter Geoghegan


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15460: Error while creating index or constraint
Следующее
От: Dirk Heinrichs
Дата:
Сообщение: Re: BUG #15453: Installer registers with major version only