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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
