Skip site navigation (1) Skip section navigation (2)

Re: Rapidly decaying performance repopulating a large table

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rapidly decaying performance repopulating a large table
Date: 2008-04-22 21:46:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Tue, Apr 22, 2008 at 5:18 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>  Try upping your checkpoint segments.  Some folks find fairly large
>  numbers like 50 to 100 to be helpful.  Each segment = 16Megs, so be
>  sure not to run your system out of drive space while increasing it.

Ahh, much more progress. Upping the segments to 50, timeout to 30m and
completion target to 0.9 has improved average copy time to between 2
and 10 seconds, which is definitely an improvement. Thanks for the
help. Any other random thoughts while you're at it? :)

- David T. Wilson

In response to


pgsql-general by date

Next:From: Erik JonesDate: 2008-04-22 21:59:32
Subject: Re: Schema migration tools?
Previous:From: D. Dante LorensoDate: 2008-04-22 21:34:55
Subject: Re: How to modify ENUM datatypes?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group