From: Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
To: Claudio Freire <klaussfreire@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Long Running Update
Date: Fri, 24 Jun 2011 12:19:07 +0100
Message-ID: <4E0472AB.9090507@riskcontrollimited.com> (raw)
In-Reply-To: <BANLkTi=gt+LpTijBxtDp+k49fLFOFFZWQw@mail.gmail.com>
References: <4E035649.20007@riskcontrollimited.com>
<BANLkTi=gt+LpTijBxtDp+k49fLFOFFZWQw@mail.gmail.com>
Thank you Claudio.
> there are lots of ways in which it could be struggling...
I have been monitoring the server with IOSTAT -d and IOSTAT -c and I
cannot see anything alarming.
> It will be a lot faster if you can drop all indices...
This is counter-intuitive - because the WHERE clause is matching the
only two indexed fields, and my understanding is that querying on
indexed fields is faster than querying on fields that are not indexed.
(Note also, that the indexed field is NOT being updated.)
But if this update fails, I shall try what you suggest!
Kind regards
Harry Mantheakis
London, UK
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: harry.mantheakis@riskcontrollimited.com, klaussfreire@gmail.com
Subject: Re: Long Running Update
In-Reply-To: <4E0472AB.9090507@riskcontrollimited.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox