Re: update problem?

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: update problem?
Date: 2002-07-10 20:52:56
Message-ID: x7znwzs3tj.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

>>>>> "JS" == Jörg Schulz <jschulz(at)sgbs(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Hill 2002-07-10 20:53:56 Re: XML to Postgres conversion
Previous Message Jan Wieck 2002-07-10 20:42:54 Re: (A) native Windows port

Browse pgsql-novice by date

  From Date Subject
Next Message Matt Price 2002-07-10 20:59:00 web archiving
Previous Message Vasco Amaral 2002-07-10 16:34:30 UDF examples. returning rows