Re: Slow update with simple query - Mailing list pgsql-performance

From Arnaud Lesauvage
Subject Re: Slow update with simple query
Date
Msg-id 45817B2F.7070502@freesurf.fr
Whole thread Raw
In response to Re: Slow update with simple query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane a écrit :
> I think the conclusion must be that there was just too much I/O to be
> done to update all the rows.  Have you done any tuning of shared_buffers
> and so forth?  I recall having seen cases where update performance went
> bad as soon as the upper levels of a large index no longer fit into
> shared_buffers ...

Yes, that's probably it.
I think my raid1 array's performances are very bad.
I am switching to a brand new hardware next week, I am quite confident that this
will solve many problems.

Thanks for helping !

Regards
--
Arnaud


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow update with simple query
Next
From: Evgeny Gridasov
Date:
Subject: Re: EXPLAIN ANALYZE on 8.2