From: Reuven M. Lerner <reuven@lerner.co.il>
To: sthomas@peak6.com
Cc: Glyn Astill <glynastill@yahoo.co.uk>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Very long deletion time on a 200 GB database
Date: Fri, 24 Feb 2012 16:54:04 +0200
Message-ID: <4F47A48C.6000302@lerner.co.il> (raw)
In-Reply-To: <4F479FDE.1070509@peak6.com>
References: <4F45FB55.1020600@lerner.co.il>
<1329990620.15378.YahooMailNeo@web171403.mail.ir2.yahoo.com>
<4F4730B4.2050602@lerner.co.il>
<4F479FDE.1070509@peak6.com>
Hi, everyone. Shaun said:
> On 02/24/2012 12:39 AM, Reuven M. Lerner wrote:
>
>> - CPU is virtually idle when running the deletes, using about 1% of
>> CPU
>
> I think you found your problem.
>
> See if you can get the Windows admins to give you some info on how busy
> the disks are (percent utilization, IOPS, something) the next time you
> try this. Increasing your memory settings may help, but a 1% CPU usage
> usually suggests it's waiting for disk blocks to be read before it can
> actually do something.
I asked them for disk readings, but I'm not sure how to contextualize
the numbers I got:
I/O writes: process1: 820,000, process2: 1Milion Process3: 33,000
Any suggestions for what I can do to improve performance with such a
slow disk, and a lack of additional RAM?
Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner
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: reuven@lerner.co.il, sthomas@peak6.com, glynastill@yahoo.co.uk
Subject: Re: Very long deletion time on a 200 GB database
In-Reply-To: <4F47A48C.6000302@lerner.co.il>
* 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