From: Lionel B. <lio...@bo...> - 2006-01-15 09:10:57
|
Dave Strickler wrote the following on 15.01.2006 02:55 : > We are running a very large "connect" table (about 2.5 mill rows a day), Hum, quite the beast. > and therefore even on a very fast SQL server, our PostgreSQL "Vacuum > FULL" on the entire database takes about 2 hours, during which the > database is locked for read/write. Do you really need "VACUUM FULL"? What happens if you only run "VACUUM" or "VACUUM ANALYZE" (which both don't lock the tables at least with PostgreSQL 7.2+)? Which PostgreSQL version do you use? I have some hardware on which I can try to reproduce the problem. What are the specs of yours? Lionel. |