Hi Tom, Thanks! for the reply, I just realized that yesterday by mistake the vacuum script also included "template0" database and it vacuumed that one too. Would that cause any problems ? Pallav. Tom Lane wrote: > Pallav Kalva <pkalva@xxxxxxxxxxxxxxxxx> writes: > >> Does anybody know what this means ? "LOG: removing file >> "/var/lib/pgsql/data/pg_clog/0000", >> > > Routine maintenance; don't worry about it. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >