Postgres Pro
Downloads
Home   >   mailing lists

Re: Index creation running now for 14 hours - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: Index creation running now for 14 hours
Date
Msg-id CAJjS0u0m=Ukpkr3himaAVXjiu+z3UsQg13EDk0pUVf0xALFmbQ@mail.gmail.com
Whole thread Raw
In response to Re: Index creation running now for 14 hours  (Tory M Blue <tmblue@gmail.com>)
Responses Re: Index creation running now for 14 hours
List pgsql-performance
Tree view 
On Wed, Aug 26, 2015 at 1:26 PM, Tory M Blue <tmblue@gmail.com> wrote:
>
> Right now the 100% cpu process which is this index is only using 3.5GB
> and has been for the last 15 hours
>

If 100% cpu, you can do 'sudo perf top' to see what the CPU is busy about.

Regards,
Qingqing

pgsql-performance by date:

Previous
From: Tory M Blue
Date:
Subject: Re: Index creation running now for 14 hours
Next
From: Tory M Blue
Date:
Subject: Re: Index creation running now for 14 hours