Re: insert/update tps slow with indices on table > 1M rows - Mailing list pgsql-performance

From James Mansion
Subject Re: insert/update tps slow with indices on table > 1M rows
Date
Msg-id 4846F90A.7030700@mansionfamily.plus.com
Whole thread Raw
In response to Re: insert/update tps slow with indices on table > 1M rows  (andrew klassen <aptklassen@yahoo.com>)
List 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.


pgsql-performance by date:

Previous
From: James Mansion
Date:
Subject: Re: insert/update tps slow with indices on table > 1M rows
Next
From: andrew klassen
Date:
Subject: Re: insert/update tps slow with indices on table > 1M rows