LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-02-2011, 01:28 AM   #1
shravankumar.bbc
LQ Newbie
 
Registered: Mar 2010
Posts: 9

Rep: Reputation: 0
Postgresql 8.4


Hi all,

I am using RHEL5.4 as my operating system in that i configured JBoss ON 2.4 server using Postgresql8.4.

The problem what i am getting over here is that the size of /opt/PostgreSQL/8.4/data/base/ is increasing daily. Can you please give me a suggestion to control the increasing the size. For that what changes i have to do in my Postgresql configuration.

Thanks in advance
 
Old 05-02-2011, 04:11 AM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
Hi,

What are you actually using the database for? If you keep
entering data, the size will grow, obviously.

Random thoughts:
Autovacuum? Vacuum on a regular basis? Logging levels?

Cheers,
Tink

Last edited by Tinkster; 05-02-2011 at 04:12 AM.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
postgresql johnh10000 Linux - Newbie 7 08-30-2009 03:52 PM
PostgreSql coolrock Slackware 4 10-04-2006 10:24 AM
PostgreSql sijomon_nd Fedora 1 09-27-2005 09:27 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
PostgreSQL dorian33 Linux - Software 3 01-15-2003 04:01 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:17 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration