pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedInact_dirty is increasing continuously and causing the system to hang.
2+ messages / 2 participants
[nested] [flat]
* Inact_dirty is increasing continuously and causing the system to hang.
@ 2008-07-01 11:59 Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
2008-07-01 15:03 ` Re: Inact_dirty is increasing continuously and causing the system to hang. Greg Smith <gsmith@gregsmith.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kathirvel, Jeevanandam @ 2008-07-01 11:59 UTC (permalink / raw)
To: pgsql-performance
Hi,
We are seeing system hang-up issue when we do continuous
update on table ( 2-3 records/sec) within 10-12 hours. Memory parameter
Inact_dirty( shown in /proc/meminfo) is increasing continuously and
causing the system to hang-up(not responding state). This issue is not
happening when we stop the continuous update.
Please help us to resolve this issue.
System details follows:
OS : Linux kernel version 2.4.7-10
RAM; 256MB (but 64MB used by RAM file system)
PostgreSQL version:7.4.3
postgresql.conf settings : default settings
Best Regards,
Jeeva
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Inact_dirty is increasing continuously and causing the system to hang.
2008-07-01 11:59 Inact_dirty is increasing continuously and causing the system to hang. Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
@ 2008-07-01 15:03 ` Greg Smith <gsmith@gregsmith.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Smith @ 2008-07-01 15:03 UTC (permalink / raw)
To: Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>; +Cc: pgsql-performance
On Tue, 1 Jul 2008, Kathirvel, Jeevanandam wrote:
> We are seeing system hang-up issue when we do continuous update on table
> ( 2-3 records/sec) within 10-12 hours. Memory parameter Inact_dirty(
> shown in /proc/meminfo) is increasing continuously and causing the
> system to hang-up(not responding state).
When you update a row, what it does is write a new version of that row out
to disk and then mark the old version dead afterwards. That process
generates disk writes, which show up as Inact_dirty data while they're in
memory. Eventually your system should be writing those out to disk. The
most helpful thing you could post here to narrow down what's going on is a
snippet of the output from "vmstat 1" during a period where things are
running slowly.
Dirty memory growing continuously suggests you're updating faster than
your disk(s) can keep up. The main thing you can usefully do in
PostgreSQL 7.4.3 to lower how much I/O is going on during updates is to
increase the checkpoint_segments parameters in your postgresql.conf file.
A modest increase there, say going from the default of 3 to 10, may reduce
the slowdowns you're seeing. Note that this will cause the database to
get larger and it will take longer to recover from a crash.
Given how old the versions of all the software you're using are, it's
quite possible what you're actually running into is a Linux kernel bug or
even a PostgreSQL bug. If this problem is getting annoying enough to
disrupt your operations you should be considering an upgrade of your whole
software stack. Start with going from PostgreSQL 7.4.3 to 7.4.21, try and
add more RAM to the server, look into whether you can re-install on a more
modern Linux, and try to get onto PostgreSQL 8.3 one day.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-01 15:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-01 11:59 Inact_dirty is increasing continuously and causing the system to hang. Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
2008-07-01 15:03 ` Greg Smith <gsmith@gregsmith.com>
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