Horton

Re: Running update in chunks?

Jeff Janes <jeff.janes@gmail.com>

View thread View on postgr.es
From: Jeff Janes <jeff.janes@gmail.com>
To: Tim Uckun <timuckun@gmail.com>
Cc: Steve Crawford <scrawford@pinpointresearch.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2013-01-22T07:07:02Z
Lists: pgsql-general 
On Monday, January 21, 2013, Tim Uckun wrote:

> I already posted the schema earlier. It's a handful of integer fields
> with one hstore field.
>


one hstore field can easily be equivalent to 50 text fields with an index
on each one.

I'm pretty sure that that is your bottleneck.

what does \di+ show?


Cheers,

Jeff

>
>