Re: Running update in chunks?
От
Tim Uckun
Тема
Re: Running update in chunks?
Дата
Msg-id
CAGuHJrM8AU_VmMzPcCWRxJAhbmppw=5SMVaYoLRxD2dN_rkWPg@mail.gmail.com
Ответ на
Re: Running update in chunks? (Jeff Janes)
Список
Дерево обсуждения
Re: Running update in chunks? Jasen Betts <jasen@xnet.co.nz>
> > What if you do: > alter table cars.imports set (fillfactor=50); > Before the vacuum full, and then try the update again? This makes a dramatic difference when combined with a vacuum. UPDATE 98834 Time: 3408.210 ms Ten times faster! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления
