Re: BUG #15460: Error while creating index or constraint - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #15460: Error while creating index or constraint
Date
Msg-id CAH2-WzmV0kmPLjV1V+-5pUwDe4zeL14S958xu73knizorVAi4g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15460: Error while creating index or constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #15460: Error while creating index or constraint
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15460: Error while creating index or constraint
Next
From: Dirk Heinrichs
Date:
Subject: Re: BUG #15453: Installer registers with major version only