Re: Running update in chunks?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: patrick keshishian <pkeshish(at)gmail(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Running update in chunks?
Date: 2013-01-21 21:48:36
Message-ID: CAGuHJrNk7gMQMTJ-PQiXAwb6mXM+x7rRLkhnf7ONs2J7fQM=2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I'd be curious to see results of the same "update" on a standard HDD
> vs the SSD, and maybe on a more typical database deployment hardware
> vs a macbook air.
>

I haven't tried it on any other machine yet. CREATE TEMP TABLE tt as
SELECT ... takes eight seconds so presumably the disk is not the
choke point.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-01-21 21:50:22 Re: Running update in chunks?
Previous Message Tim Uckun 2013-01-21 21:45:24 Re: Running update in chunks?