postgresql issues - system running really slow Post: 302275843

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...

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. 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...

4. HP-UX

SAM running slow

Any ideas on why SAM would take so long to load and initialize?

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....

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...

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...

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...

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...

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 ----- -----------...

LEARN ABOUT DEBIAN

pg_buildext

PG_BUILDEXT(1)						 Debian PostgreSQL infrastructure					    PG_BUILDEXT(1)

NAME

       pg_buildext - Build and install a PostgreSQL extension

SYNOPSIS

       pg_buildext action srcdir target opts

DESCRIPTION

       pg_buildext is a script that will build a PostgreSQL extension in a VPATH way. It supports the configure, build, install, and clean
       actions, and will choose to build for the intersection of versions known in debian/pgversions (versions supported by the package) and in
       /usr/share/postgresql-common/supported-versions (versions supported in this release).

OPTIONS

       action
	   One of configure, build, install, or clean.

       srcdir
	   Where to find the extension sources, including the debian subdirectory.  (Usually $(CURDIR).) If not specified, defaults to the current
	   directory.

       target
	   The target directory where to build the sources, it will get created for you if it does not exist. If the target contains a %v sign, it
	   will get replaced by the specific version of PostgreSQL being built against.  (Usually build-%v.)

       opts
	   %v signs in opts will get replaced as in target.

	   configure
	       Options to pass to the configure script. (Most PostgreSQL extensions do not have a configure script.)

	   build
	       Custom CFLAGS options to use for the build.

	   install
	       Package name to install for. Make will be called with DESTDIR="srcdir/debian/package".

	   clean
	       clean does not take extra options.

USAGE

       As pg_buildext invokes make for the build, install, and clean actions, invocations from debian/rules (which is a makefile) should be
       prefixed with + so the sub-makes can talk with the make jobserver.

EXAMPLE

	 build-stamp:
		 +pg_buildext configure $(CURDIR) build-%v "--libdir=/usr/lib/postgresql/%v/lib --datadir=/usr/share/postgresql-%v-plsh"
		 +pg_buildext build $(CURDIR) build-%v

	 install: build
		 +pg_buildext install $(CURDIR) build-%v postgresql-%v-plsh

	 clean:
		 +pg_buildext clean $(CURDIR) build-%v

AUTHOR

       Dimitri Fontaine <dim@tapoueh.org>, with extensions by Christoph Berg <myon@debian.org>.

Debian								    2012-10-08							    PG_BUILDEXT(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Slow System

Discussion started by: Hansaplast

2. Solaris

Solaris running very slow!!

Discussion started by: a1_win

3. SCO

Server running slow

Discussion started by: tez

4. HP-UX

SAM running slow

Discussion started by: csaunders