Postgres running Very slowly

Поиск
Список
Период
Сортировка
От Radhika S
Тема Postgres running Very slowly
Дата
Msg-id fe27bfd40710091300h5838ad74sd2c0f90ae9918d4e@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres running Very slowly
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: SQL Monitoring
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: hashjoin chosen over 1000x faster plan