Re: Running update in chunks?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Running update in chunks?
Date: 2013-01-22 07:07:02
Message-ID: CAMkU=1zmfVJypqG7GiAmgbAu8Bf_NKYLVuORD+CiBQBE9pcOpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Clayton 2013-01-22 07:11:20 Re: Yet Another Timestamp Question: Time Defaults
Previous Message Jeff Janes 2013-01-22 07:02:57 Re: Running update in chunks?