Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 78B5D9F9F26 for ; Tue, 9 Oct 2007 17:00:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53772-07 for ; Tue, 9 Oct 2007 17:00:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 927229F98FF for ; Tue, 9 Oct 2007 17:00:06 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so166036ugf for ; Tue, 09 Oct 2007 13:00:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=/t1Mxb7592w7rHgBtJKZ6FaH9LMJJjo3nkwsgxXYQWg=; b=j1E4GYQr2BpZCxIDSCcgF1nR0IzzZbyQn/BU2B/spCTt2DUlDPdzhaTrmR9lxnWuZv/4Hg144+YOGauj9geKdGionmpMwqUdbMFM2xuJUsIC496iO/mewlEf33tXX5X2bcHbRUoDK4EsCvSgNNx3v5gUrqehpZSpulUbd+J8uH4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=b+zaAshTbOp3HSAGBu6aIPjbuE/vxMeQL9ThEQ78u/nEEXAeU+V3d0Wkv1TX8rhF3NMLH6TVz7698Bo/XrWC+5sa2rhUbCWL25gKnt6DQYT7gj07Bq22j1vAjsGTDgrU20lMmD2dzOYI+Tf4LZ2AScDl8pSWbtMD4Z3ygN0GGa0= Received: by 10.66.252.18 with SMTP id z18mr1120698ugh.1191960004691; Tue, 09 Oct 2007 13:00:04 -0700 (PDT) Received: by 10.66.244.10 with HTTP; Tue, 9 Oct 2007 13:00:04 -0700 (PDT) Message-ID: Date: Tue, 9 Oct 2007 16:00:04 -0400 From: "Radhika S" To: pgsql-performance@postgresql.org Subject: Postgres running Very slowly MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10347_891806.1191960004677" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/87 X-Sequence-Number: 27109 ------=_Part_10347_891806.1191960004677 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi -, I have a very peculiar situation. I am running a postgres 7.4.6 database. It is running slow....... . I vacuum --analyze daily. I just did again. I did a vacuum full last night. But to no avail. CPU usage and memory are normal, but the system is crawling. Here is the info from vacuum. CPU 0.02s/0.01u sec elapsed 0.02 sec. INFO: free space map: 167 relations, 1412 pages stored; 3440 total pages needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory. VACUUM Is there anything else I should be looking at like FSM configuration in the conf file? Any help would be appreciated. Thanks. Radhika -- It is all a matter of perspective. You choose your view by choosing where to stand. --Larry Wall ------=_Part_10347_891806.1191960004677 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi -,
I have a very peculiar situation.

I am running a postgres 7.4.6 database. It is running slow....... .
I vacuum --analyze daily. I just did again.
I did a vacuum full last night.

But to no avail. CPU usage and memory are normal, but the system is crawling.

Here is the info from vacuum.

CPU 0.02s/0.01u sec elapsed 0.02 sec.
INFO:  free space map: 167 relations, 1412 pages stored; 3440 total pages needed
DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory.
VACUUM


Is there anything else I should be looking at like FSM configuration in the conf file?

Any help would be appreciated.

Thanks.
Radhika

--
It is all a matter of perspective. You choose your view by choosing where to stand. --Larry Wall ------=_Part_10347_891806.1191960004677--