Re: [GENERAL] Database became very slow(Help PLS)

2005-06-15 Thread 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 agai

Re: [GENERAL] Database became very slow(Help PLS)

2005-06-14 Thread 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

[GENERAL] Database became very slow(Help PLS)

2005-06-14 Thread 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