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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux