Database became very slow(Help PLS)

Поиск
Список
Период
Сортировка
От go
Тема Database became very slow(Help PLS)
Дата
Msg-id 342958000.20050615075511@ugnn.ru
обсуждение исходный текст
Ответы Re: Database became very slow(Help PLS)  (Richard Huxton <dev@archonet.com>)
Re: Database became very slow(Help PLS)  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
Hi,

 After about 2 month of greate work, my database (running under
 PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
 and Analyze didn't help(i did it from pg_admin III).
 But after dropdb and pg_restore it become fast again.
 (The same database -both very small , about 50 Mb- running under PG 8.01
 on Linux RHEL AS3 do not need in recreating db = only a dayly vacuumdb)
 Tell me please what im doing wrong on Win2000?


Tanks and Have a nice day!
--

 Igor                          mailto:go@ugnn.ru


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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: (NONE)
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: How to set an expiration date for a WHOLE user account