Sponsored Content
Operating Systems Linux Red Hat postgresql issues - system running really slow Post 302275843 by jim mcnamara on Monday 12th of January 2009 10:06:47 AM
Old 01-12-2009
If the system is that old, I will assume you have a LOT of rows in your tables, unless you are actively purging and archiving data. Based on what you say, and if iostat does not show bottlenecks then it very probably has to be a db problem.

you did check iostat, right?

First: Look into record chaining. This occurs when you have updates applied to old records. Over time a full table scan on certain columns becomes almost impossible, time-wise. iostat will report more I/O because of chaining, but basically chaining can defeat disk and software caching and LRU strategies.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Slow System

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

Solaris running very slow!!

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

Server running slow

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

SAM running slow

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

Unix is running slow??

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

Slow while running a command for the first time

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

swap issues, system is running at 99%

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

Ubuntu seems running slow!

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 Running Script (Reading 8000 lines)

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

AIX server running very slow

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
iostat(1)						      General Commands Manual							 iostat(1)

NAME
iostat - report I/O statistics SYNOPSIS
[interval [count]] DESCRIPTION
iteratively reports I/O statistics for each active disk on the system. Disk data is arranged in a four-column format: Column Heading Interpretation -------------------------------------------------- device Device name bps Kilobytes transferred per second sps Number of seeks per second msps Milliseconds per average seek If two or more disks are present, data is presented on successive lines for each disk. To compute this information, seeks, data transfer completions, and the number of words transferred are counted for each disk. Also, the state of each disk is examined times per second (as defined in and a tally is made if the disk is active. These numbers can be combined with the transfer rates of each device to determine average seek times for each device. With the advent of new disk technologies, such as data striping, where a single data transfer is spread across several disks, the number of milliseconds per average seek becomes impossible to compute accurately. At best it is only an approximation, varying greatly, based on several dynamic system conditions. For this reason and to maintain backward compatibility, the milliseconds per average seek field is set to the value 1.0. Options recognizes the following options and command-line arguments: Report terminal statistics as well as disk (or lunpath) statistics. When used with the option, lunpath and terminal statistics are displayed. Terminal statistics include: Number of characters read from terminals. Number of characters written to terminals. Percentage of time system (active processors) has spent in user mode. Percentage of time system (active processors) has spent in user mode running low-priority (nice) processes. Percentage of time system (active processors) has spent in system mode. Percentage of time system (active processors) has spent idling. interval Display successive lines which are summaries of the last interval seconds. The first line reported is for the time since a reboot and each subsequent line is for the last interval only. count Repeat the statistics count times. Report active lunpath statistics. When used with the option, lunpath and terminal statistics are reported. The lunpaths are not displayed in any specific order, and the current order may change in future releases. Lunpath data is arranged in a four-column format: symbolic name of the lunpath of the form: diskm_lunpathn, where m is the instance number of LUN and n is the instance number of lunpath. For example, in disk47_lunpath7, m is 47 and n is 7. These instance numbers are displayed by using the option for the LUN and lunpath entries. For more information on LUN and lunpath hardware path, refer to intro(7). Kilobytes transferred per second. Number of seeks per second. Milliseconds per average seek. For multiple lunpaths, data is presented on successive lines for each active lunpath. If no lunpaths were active, a blank line is printed. EXAMPLES
Show current I/O statistics for all disks: Display I/O statistics for all disks every 10 seconds until INTERRUPT or QUIT is pressed: Display I/O statistics for all disks every 10 seconds and terminate after 5 successive readings: Display I/O statistics for all disks every 10 seconds, also show terminal and processor statistics, and terminate after 5 successive read- ings: Display I/O statistics for all active lunpaths: Display I/O statistics for all active lunpaths every 10 seconds until INTERRUPT or QUIT is pressed: Display I/O statistics for all active lunpaths every 10 seconds, and terminate after 5 successive readings: Display I/O statistics for all active lunpaths every 10 seconds, also show terminal and processor statistics, and terminate after 5 succes- sive readings: WARNINGS
Users of must not rely on the exact field widths and spacing of its output, as these will vary depending on the system, the release of HP- UX, and the data to be displayed. AUTHOR
was developed by the University of California, Berkeley, and HP. FILES
SEE ALSO
vmstat(1), ioscan(1M), intro(7). iostat(1)
All times are GMT -4. The time now is 12:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy