Database restore speed - Mailing list pgsql-performance

From Steve Oualline
Subject Database restore speed
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB06750F77@mail01.stbernard.com
Whole thread Raw
List pgsql-performance

Our application tries to insert data into the database as fast as it can.
Currently the work is being split into a number of 1MB copy operations.

When we restore the postmaster process tries to use 100% of the CPU.

The questions we have are:

1) What is postmaster doing that it needs so much CPU?

2) How can we get our system to go faster?

Note: We've tried adjusting the checkpoint_segements parameter to no effect.
Any suggestions welcome.

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: COPY into table too slow with index: now an I/O
Next
From: Tom Lane
Date:
Subject: Re: COPY into table too slow with index: now an I/O