Re: Migration study, step 1: bulk write performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Migration study, step 1: bulk write performance
Date
Msg-id 2262.1142978185@sss.pgh.pa.us
Whole thread Raw
In response to Re: Migration study, step 1: bulk write performance  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Migration study, step 1: bulk write performance
List pgsql-performance
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> I've also found that modest increases in commit_siblings and
> commit_delay help a lot on certain types of imports.

On a data import?  Those really should have zero effect on a
single-process workload.  Or are you doing multiple concurrent imports?

            regards, tom lane

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Migration study, step 1: bulk write performance
Next
From: Scott Marlowe
Date:
Subject: Re: Migration study, step 1: bulk write performance