Re: update problem?

>>>>> "JS" == Jörg Schulz <jschulz@sgbs.de> writes:

JS> This update takes over 30 seconds!
JS> It uses 7 or 8 logfiles in the pg_xlog directory 16MB each.
JS> But does this explain why it take *so* long?

Try running a vacuum between your updates.  Perhaps you're using more
disk pages than you can fit into memory, causing lots of disk I/O.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/