LinuxQuestions.org
Register a domain and help support LQ
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: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,974
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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


All times are GMT -5. The time now is 11:28 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration