Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [PostgreSQL] Optimize Database [R]
#2
Yes, because

ANALYZE TABLE tablename is wrong. The query goes without the TABLE statement. Btw...I think that VACUUM ANALYZE tablename would be better, because it cleans up the tables and reindexes them.


Messages In This Thread
RE: [PostgreSQL] Optimize Database [R] - by DoctorCasino - 2008-11-17, 02:25 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)