On Tue, 11 Nov 2003, Antonis Antoniou wrote: > Guys, does anyone has any idea?
Are you sure that vacuum is not just waiting on a lock that some other transaction is holding? I'd suggest checking the contents of pg_locks. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match