Re: BUG #6136: Perfomance dies when using PK on 64-bit field - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #6136: Perfomance dies when using PK on 64-bit field
Date
Msg-id 201108011010.32521.andres@anarazel.de
Whole thread Raw
In response to BUG #6136: Perfomance dies when using PK on 64-bit field  ("Robert" <robert.ayrapetyan@gmail.com>)
Responses Re: BUG #6136: Perfomance dies when using PK on 64-bit field
List 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

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #6136: Perfomance dies when using PK on 64-bit field
Next
From: Bernd Helmle
Date:
Subject: Re: Warm Standby startup process unconditionally hangs