[GE users] ARCo postgres database growth

Jana Olivova Jana.Olivova at Sun.COM
Thu Jul 26 14:36:29 BST 2007

    [ The following text is in the "iso-8859-1" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some special characters may be displayed incorrectly. ]


The growth is normal, there is large amount of data being generated. it also depends what report_variables have you configured to be reported. In qconf -me global

There are default delete rules that are configured in $SGE_ROOT/dbwriter/database/<db_name>/dbwriter.xml

You can change the frequency of the deletes and other subscope attributes to tailor it to your needs to delete exactly what you need and how often.

You can learn more on configuring the delete rules in the Administration Guide.


Refer to section Deleting Outdated Records.


Jana Olivova

Michael Phillips wrote: 

	The number of jobs that we are running is about 10,000 per week



	From: Michael Phillips [mailto:Michael.Phillips at csr.com] 
	Sent: 26 July 2007 13:48
	To: users at gridengine.sunsource.net
	Subject: [GE users] ARCo postgres database growth


	Hi All,


	Have recently installed ARCo v6.0 u11 on Solaris 10 x64 with a postgres database.


	The rate of growth of the postgres database is about 500 Mb a day in the week and 200 Mb a day on weekends, giving a weekly growth figure of around 3 Gb.


	 Is this rate of growth normal or is something going wrong.


	If this is normal is there any housekeeping that I can do, I could not find anything in the documentation.






Mike Phillips
Senior Unix Engineer - Corporate Infrastructure

CSR plc,
St John's House,
Cambridge Business Park,
Milton Road,
Cambridge. CB4 0WZ
United Kingdom.



Direct Line: +44(0)1223 692021

Switchboard: +44(0)1223 692000
Fax: +44(0)1223 692001

michael.phillips at csr.com

www.csr.com <http://www.csr.com/> 


	Latest Trade Press Releases from CSR:
	25/07/2007 CSR reports record results for H1 2007 <http://www.csr.com/pr/pr299.htm> 
	24/07/2007 CSR brings Bluetooth to austriamicrosystems Portable Media Player designs <http://www.csr.com/pr/pr298.htm> 
	Supports two Bluetooth headsets and native MP3 coding
	23/07/2007 CSR boosts Actions Semiconductor's MP3 design with wireless connectivity <http://www.csr.com/pr/pr297.htm> 
	Latest Financial Press Releases from CSR:
	25/07/2007 CSR PLC - Interim Results <http://ir.csr.com/phoenix.zhtml?c=177117&p=irol-newsArticle&ID=1030351&highlight=> 

	To report this email as spam click here <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==> .

    [ Part 1.2, "ATT9731982.gif"  Image/GIF (Name: "ATT9731982.gif") 2.4 ]
    [ KB. ]
    [ Unable to print this part. ]

    [ Part 2, "ATT9731983.txt"  Text/PLAIN (Name: "ATT9731983.txt") ~213 ]
    [ bytes. ]
    [ Unable to print this part. ]

More information about the gridengine-users mailing list