| From: | "Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Postgres running Very slowly |
| Date: | 2007-10-09 20:00:04 |
| Message-ID: | fe27bfd40710091300h5838ad74sd2c0f90ae9918d4e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2007-10-09 20:09:51 | hashjoin chosen over 1000x faster plan |
| Previous Message | Gregory Stark | 2007-10-09 19:00:06 | Re: SQL Monitoring |