From: Radhika S <radhika.sambamurti@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Postgres running Very slowly
Date: Tue, 9 Oct 2007 16:00:04 -0400
Message-ID: <fe27bfd40710091300h5838ad74sd2c0f90ae9918d4e@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: radhika.sambamurti@gmail.com
Subject: Re: Postgres running Very slowly
In-Reply-To: <fe27bfd40710091300h5838ad74sd2c0f90ae9918d4e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox