Re: Rapidly decaying performance repopulating a large table
От | David Wilson |
---|---|
Тема | Re: Rapidly decaying performance repopulating a large table |
Дата | |
Msg-id | e7f9235d0804221446k5de18bc6s1b55c8cd3cfd93b3@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Rapidly decaying performance repopulating a large table ("Scott Marlowe" <scott.marlowe@gmail.com>) |
Ответы |
Re: Rapidly decaying performance repopulating a large table
Re: Rapidly decaying performance repopulating a large table |
Список | pgsql-general |
On Tue, Apr 22, 2008 at 5:18 PM, Scott Marlowe <scott.marlowe@gmail.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 david.t.wilson@gmail.com
В списке pgsql-general по дате отправления: