01-12-2009
postgresql issues - system running really slow
Hi All,
I'm new here.
i was wondering if anyone could shed a light on the problem i am having.
I use a system for distributing broadband amongst users of for example a hotel, the system was designed by someone in the US and it is based on redhat 2.4 (i know its old) and the system uses Postgresl NOT mysql.
the problem i am having is that i cannot contact the company for linux support no more and the system itself is failing fast. the problem is speed. its really slow at performing database request, in some cases so slow that it just doesn't work at all.
I have a script on the system calles auto_vacumm for postgresql and it is setup in crontab to run daily, but this seems to make no difference to the performance of the server.
could anyone point me in the right direction to solving the problem, i have checked 'top' and the CPU is running @ 90%+ idle.
any information would be very much appreciated.
thanks in advance
Clive.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have an SCO-Unix server running.
There are some processes (unknown to me) which consume a lot of the system resources. This slows down the server dramatically.
Is there a command or program that monitors what processes are using the cpu, disk, etc.. and tell me how excessive and how... (3 Replies)
Discussion started by: Hansaplast
3 Replies
2. Solaris
Hi all,
Solaris is working very slow as login to solaris takes time say after 10 to 15 mins we get the login prompt back after logging in as oracle account/other account.
This causes most Batch run delays(DWHouse jobs) scheduled through cronjobs.
Where should one look for such issues to... (3 Replies)
Discussion started by: a1_win
3 Replies
3. SCO
Hi,
Wonder is someone can help.
I've got a server SCO_SV 3.2v5.0.7 PentIII that is located at a different site and is running slow and has been for a week. I've been speaking to a third party who say nothing is wrong with it but its still running slow.
The 3rd party advise it could be a... (2 Replies)
Discussion started by: tez
2 Replies
4. HP-UX
Any ideas on why SAM would take so long to load and initialize? (4 Replies)
Discussion started by: csaunders
4 Replies
5. UNIX for Dummies Questions & Answers
All, This is my interview questions. Let me explain the question. Some one is asking me that, the unix server is running very slow. As a unix unix admin, what are the steps we should follow?? What/which process we should check?? What is the way to find the root cause ? Please let me know.... (8 Replies)
Discussion started by: govindts
8 Replies
6. Solaris
I am facing a performance problem on a Solaris 10 Sparc V890 server, it is an old one I know. The first time we realized there is a problem with the server, is the time when ftp transfers are made. There were 4 other identical servers doing much better. Network drivers are checked and there... (3 Replies)
Discussion started by: royalliege
3 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I am trying to understand why my system is running at very high. This system is almost out of memory. See below.
swapon -s
Filename Type Size Used Priority
/dev/mapper/VolGroup00-LogVol02 partition 8388600 8235088 -1... (2 Replies)
Discussion started by: samnyc
2 Replies
8. UNIX for Dummies Questions & Answers
Hello,
My PC seems running slow: OS32 system, Pentium(R)4---2.40Ghz, 1GB RAM, 80GB HDI am running Ubuntu 11.10 (Oneiric Ocelot) alone in this box, which seems very slow to me. Is this normal?
Compared with my other PC (Running XP) with 1.99GHz AMD Athlon 3200+, 2GB RAM,500GB HD, XP and Mint... (11 Replies)
Discussion started by: yifangt
11 Replies
9. Shell Programming and Scripting
Slow runnin script. The problem seems to be the sed calls.
In summary the script reads list of users in file1. For each
username search two files (file 1 & file2) for the username
and get the value in the next line after "=". Compare these
values with each other.
If the same then output... (9 Replies)
Discussion started by: u20sr
9 Replies
10. AIX
Hello,
All the commands on AIX are running very slow.
Below is few stats but I didn't find any issue in cpu or memory reosurces
vmstat
System configuration: lcpu=4 mem=6144MB ent=1.00
kthr memory page faults cpu
----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
LEARN ABOUT DEBIAN
pgsql2dlf
PGSQL2DLF.IN(1) LogReport's Lire Documentation PGSQL2DLF.IN(1)
NAME
pgsql2dlf - convert pgsql logfiles to dlf format
SYNOPSIS
pgsql2dlf
DESCRIPTION
pgsql2dlf converts a PostgreSQL query log file to DLF format. Information on PostgreSQL can be found on http://www.postgresql.org/.
Logging can be enabled in the postgresql.conf file.
The following options should be present at least for this converter to work well:
debug_level = 1
debug_print_parse = on
debug_print_query = on
The generic database dlf format is described in database.xml.
EXAMPLES
To process a log as produced by PostgreSQL:
$ pgsql2dlf < /var/log/postgresql.log
pgsql2dlf will be rarely used on its own, but is more likely called by lr_log2report:
$ lr_log2report pgsql < /var/log/postgresql.log
NOTES
The parser has been tested for log files from PostgreSQL 7.2.1.
SEE ALSO
psql(1), postmaster(1), postgresql.conf(5)
VERSION
$Id: pgsql2dlf.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This file is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
AUTHOR
Wessel Dankers <wsl@logreport.org>
Lire 2.1.1 2006-07-23 PGSQL2DLF.IN(1)