Postgres Pro
Downloads
Home   >   mailing lists

Inact_dirty is increasing continuously and causing the system to hang. - Mailing list pgsql-performance

From Kathirvel, Jeevanandam
Subject Inact_dirty is increasing continuously and causing the system to hang.
Date
Msg-id EB493C98A0338748AA3D997E071B0574010174F9@IE10EV813.global.ds.honeywell.com
Whole thread Raw
Responses Re: Inact_dirty is increasing continuously and causing the system to hang.
List pgsql-performance
Tree view

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

 

pgsql-performance by date:

Previous
From: "Emiliano Leporati"
Date:
Subject: un-understood index performance behaviour
Next
From: "Scott Marlowe"
Date:
Subject: Re: un-understood index performance behaviour