Welcome Simon Riggs wrote:
Tune your wal settings and bgwriter to improve things, plus upgrade to 8.1 which has made leaps forward with this issue.
What is best settings for that case? I have the same on 7.4 but for me it's not critical issue or big problem. I have database (size 2-3 GB) with image from few kb to 20MB.
Best Regards, Simon Riggs
Best Regards GP
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org