pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Pierre Frédéric Caillaud <lists@peufeu.com>
To: Eduardo Piombino <drakorg@gmail.com>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: a heavy duty operation on an "unused" table kills my server
Date: Thu, 14 Jan 2010 17:16:11 +0100
Message-ID: <op.u6i549rvcke6l8@soyouz> (raw)
In-Reply-To: <e24c1d9d1001122147l1c0e2111kce25dc2c7f393087@mail.gmail.com>
References: <e24c1d9d1001122059ic5d4721o98ccf85033b1fead@mail.gmail.com>
<4B4D5698.8040808@emolecules.com>
<e24c1d9d1001122147l1c0e2111kce25dc2c7f393087@mail.gmail.com>
> "high CPU usage" It might very well be "high IO usage".
Try this :
Copy (using explorer, the shell, whatever) a huge file.
This will create load similar to ALTER TABLE.
Measure throughput, how much is it ?
If your server blows up just like it did on ALTER TABLE, you got a IO
system problem.
If everything is smooth, you can look into other things.
How's your fragmentation ? Did the disk ever get full ? What does the
task manager say (swap in/out, disk queue lengthn etc)
PS : try a separate tablespace on another disk.
view thread (25+ messages) latest in thread
Message-ID: <op.u6i549rvcke6l8@soyouz> Permalink: ../op.u6i549rvcke6l8@soyouz/ Also on: postgresql.org/message-id/op.u6i549rvcke6l8@soyouz ·
reply
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: lists@peufeu.com, drakorg@gmail.com, craig_james@emolecules.com Subject: Re: a heavy duty operation on an "unused" table kills my server In-Reply-To: <op.u6i549rvcke6l8@soyouz> * 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