Sponsored Content
Operating Systems Linux Red Hat postgresql issues - system running really slow Post 302276193 by csorhand on Tuesday 13th of January 2009 08:30:33 AM
Old 01-13-2009
clive306,

Can you post the version of POSTGRESQL you are using?Do you perform a maintainance detach / attached of the whole database? quarterly maintenance ?

HOw is the disk space usage of your database in a daily basis? .


Cheers!
 

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
Session::Lock::Semaphore(3)				User Contributed Perl Documentation			       Session::Lock::Semaphore(3)

NAME
Apache::Session::Lock::Semaphore - Provides mutual exclusion through semaphores SYNOPSIS
use Apache::Session::Lock::Semaphore; my $locker = new Apache::Session::Lock::Semaphore; die "no semaphores" unless $locker; $locker->acquire_read_lock($ref); $locker->acquire_write_lock($ref); $locker->release_read_lock($ref); $locker->release_write_lock($ref); $locker->release_all_locks($ref); DESCRIPTION
Apache::Session::Lock::semaphore fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through system semaphores and the IPC::Semaphore module. CONFIGURATION
The module must know how many semaphores to use, and what semaphore key to use. The number of semaphores has an impact on performance. More semaphores means less lock contention. You should use the maximum number of semaphores that your platform will allow. On stock NetBSD, OpenBSD, and Solaris systems, this is probably 16. On Linux 2.2, this is 32. This module tries to guess the number based on your operating system, but it is safer to configure it yourself. To set the number of semaphores, you need to pass an argument in the usual Apache::Session style. The name of the argument is NSems, and the value is an integer power of 2. For example: tie %s, 'Apache::Session::Blah', $id, {NSems => 16}; You may also need to configure the semaphore key that this package uses. By default, it uses key 31818. You can change this using the argument SemaphoreKey: tie %s, 'Apache::Session::Blah', $id, {NSems => 16, SemaphoreKey => 42}; PROBLEMS
There are a few problems that people frequently encounter when using this package. If you get an invalid argument message, that usually means that the system is unhappy with the number of semaphores that you requested. Try decreasing the number of semaphores. The semaphore blocks that this package creates are persistent until the system is rebooted, so if you request 8 semaphores one time and 16 semaphores the next, it won't work. Use the system commands ipcs and ipcrm to inspect and remove unwanted semphore blocks. Cygwin IPC on Cygwin requires running cygserver. Without it, program will exit with "Bad System call" message. It cannot be intercepted with eval. Read /usr/share/doc/Cygwin/cygserver.README for more information. Darwin/MacOS X Darwin and MacOS X may not have semaphores, see <http://sysnet.ucsd.edu/~bellardo/darwin/sysvsem.html> *BSD Error "No space left on device" means that maximum number of semaphores is reached. See http://www.postgresql.org/docs/7.3/static/kernel-resources.html <http://www.postgresql.org/docs/7.3/static/kernel-resources.html> for more information. AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session perl v5.12.1 2008-04-30 Session::Lock::Semaphore(3)
All times are GMT -4. The time now is 12:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy