Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 05-18-2006, 07:13 PM   #1
LQ Newbie
Registered: May 2006
Posts: 3

Rep: Reputation: 0
Lightbulb How to fine tune POSTGRESQL


i am running a Postgresql V 7.4.2 database ,
whenever we access /update the database it creates a new process for the activity. its eating up my system memory. After sometime the application is very slow to access because of too many postgres process.

Is there any way to fine tune this and kill the unwanted processes using a script.

Thanks in advance
Old 05-20-2006, 05:20 PM   #2
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927
First of all: the version of Postgres you're using is ancient.
Secondly: the default behaviour for postgres is to terminate
the sub-process when the connection gets dropped; this leads me
to believe that the problem is with your application, and trying
to fix the app by killing off postgres processes is daft (and I'm
being friendly here... ).

To assess your problem more efficiently we'd need to know more
about the environment, and how you use it.



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
MythTV PVR250 - Everything works, fine tune picture???? Giallo998 Linux - Software 1 03-22-2005 12:35 AM
need 2 remove kernel fat from boot and fine tune what's left mjewell Linux - Newbie 10 01-24-2004 09:01 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM
Fine Tune Performance Help? Sabeer Linux - General 4 06-05-2003 04:55 AM
Fine Tune Performance Help? Sabeer Linux - General 1 06-03-2003 09:49 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:23 PM.

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
Open Source Consulting | Domain Registration