Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 05-02-2011, 02:28 AM   #1
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, 05:11 AM   #2
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910

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?


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


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 04:52 PM
PostgreSql coolrock Slackware 4 10-04-2006 11:24 AM
PostgreSql sijomon_nd Fedora 1 09-27-2005 10:27 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM
PostgreSQL dorian33 Linux - Software 3 01-15-2003 05:01 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:21 AM.

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