Re: Index creation running now for 14 hours

From: Qingqing Zhou <zhouqq(dot)postgres(at)gmail(dot)com>
To: Tory M Blue <tmblue(at)gmail(dot)com>
Cc: Igor Neyman <ineyman(at)perceptron(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index creation running now for 14 hours
Date: 2015-08-26 21:45:22
Message-ID: CAJjS0u0m=Ukpkr3himaAVXjiu+z3UsQg13EDk0pUVf0xALFmbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 26, 2015 at 1:26 PM, Tory M Blue <tmblue(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2015-08-26 21:53:23 Re: Index creation running now for 14 hours
Previous Message Tory M Blue 2015-08-26 20:26:30 Re: Index creation running now for 14 hours