Re: Running update in chunks?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Kevin Grittner <kgrittn(at)mail(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Running update in chunks?
Date: 2013-01-25 08:57:31
Message-ID: CAGuHJrM8AU_VmMzPcCWRxJAhbmppw=5SMVaYoLRxD2dN_rkWPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2013-01-25 09:00:15 Re: Running update in chunks?
Previous Message Tim Uckun 2013-01-25 08:53:01 Re: Running update in chunks?