Обсуждение: Database became very slow(Help PLS)

Поиск
Список
Период
Сортировка

Database became very slow(Help PLS)

От
go
Дата:
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

Re: Database became very slow(Help PLS)

От
Richard Huxton
Дата:
go wrote:
> 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?

Difficult to say without some evidence.

Keep an eye on the size of your database files and use the oid2name tool
in contrib to see if any particular object is growing in size.

--
   Richard Huxton
   Archonet Ltd

Re: Database became very slow(Help PLS)

От
Scott Marlowe
Дата:
On Tue, 2005-06-14 at 22:55, go wrote:
> 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?

Are your drives nearly full or have they been for a while?  This being a
windows machine, fragmentation is likely to be more of an issue.  Using
a larger drive / stripe set will help alleviate fragmenting somewhat.
You'll likely still have to defrag in windows, even with lots of drive
space, unless things have changed in the latest version of windows.