Horton

Re: Running update in chunks?

Tim Uckun <timuckun@gmail.com>

View thread View on postgr.es
From: Tim Uckun <timuckun@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Kevin Grittner <kgrittn@mail.com>, Richard Huxton <dev@archonet.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2013-01-25T08:57:31Z
Lists: pgsql-general 
>
> 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!