Horton

Re: Running update in chunks?

Tim Uckun <timuckun@gmail.com>

View thread View on postgr.es
From: Tim Uckun <timuckun@gmail.com>
To: patrick keshishian <pkeshish@gmail.com>
Cc: Richard Huxton <dev@archonet.com>, pgsql-general@postgresql.org
Date: 2013-01-21T21:48:36Z
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.