Gábor Farkas wrote: > hmm... can a full-vacuum be performed while the database is still "live" > (i mean serving requests)? > > will the db still be able to respond to queries? VACUUM FULL will exclusive lock the table, which means that other queries accessing it will block and wait until it's finished. > or in a different way: > > if i do a full vacuum to that table only, will the database still serve > data from the other tables at a normal speed? Yes. The extra I/O load vacuum full generates while it's running might disrupt other activity, though. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
