wanna locker - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2003-05-22 04:02:21 | Full vacuuming of BIG tables takes too long (Eugene M. Zheganin)
locks the table and the number of procecces, awaiting their inserts becomes too high. So it is much faster (40-50 mins) to dump the entire database, then drop it, recreate and resore
Mailing lists >> pgsql-admin >> Thread
2002-06-19 08:30:51 | Re: index keeps on growing (Brian McCane)
lock on the table, so while you are rebuilding the index noone can write to the table (I am not sure on this might wanna