Re: BUG #6136: Perfomance dies when using PK on 64-bit field

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "Robert" <robert(dot)ayrapetyan(at)gmail(dot)com>
Subject: Re: BUG #6136: Perfomance dies when using PK on 64-bit field
Date: 2011-08-01 08:10:32
Message-ID: 201108011010.32521.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

What happens if you drop other indices with a similar size before starting the
copy? It might just be the additional io-load (causing more checkpoints, more
random io, etc) is causing the problems.

Could you share your config and hw info?

Greetings,

Andres

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Ayrapetyan 2011-08-01 08:49:28 Re: BUG #6136: Perfomance dies when using PK on 64-bit field
Previous Message Simon Riggs 2011-08-01 07:27:32 Re: BUG #6136: Perfomance dies when using PK on 64-bit field