Re: insert/update tps slow with indices on table > 1M rows

From: James Mansion <james(at)mansionfamily(dot)plus(dot)com>
To: andrew klassen <aptklassen(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: insert/update tps slow with indices on table > 1M rows
Date: 2008-06-04 20:20:26
Message-ID: 4846F90A.7030700@mansionfamily.plus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

andrew klassen wrote:
> I'll try adding more threads to update the table as you suggest.
You could try materially increasing the update batch size too. As an
exercise you could
see what the performance of COPY is by backing out the data and
reloading it from
a suitable file.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message andrew klassen 2008-06-04 21:30:13 Re: insert/update tps slow with indices on table > 1M rows
Previous Message James Mansion 2008-06-04 20:15:45 Re: insert/update tps slow with indices on table > 1M rows