Re: Running update in chunks? - Mailing list pgsql-general

From Jeff Janes
Subject Re: Running update in chunks?
Date
Msg-id CAMkU=1zmfVJypqG7GiAmgbAu8Bf_NKYLVuORD+CiBQBE9pcOpA@mail.gmail.com
Whole thread Raw
In response to Re: Running update in chunks?  (Tim Uckun <timuckun@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Running update in chunks?
Next
From: Nathan Clayton
Date:
Subject: Re: Yet Another Timestamp Question: Time Defaults