On Mon, Jan 21, 2013 at 1:48 PM, Tim Uckun <timuckun@xxxxxxxxx> wrote: >> 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. you are making an assumption that a fresh write is the same as a re-write. try the test. --patrick -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
