Re: [PERFORM] Table not getting vaccumed.

2006-10-02 Thread Jim C. Nasby
On Sat, Sep 30, 2006 at 02:55:54PM +0530, Nimesh Satam wrote: > I am trying to vaccum one of the table using the following command: > > VACUUM FULL ANALYZE VERBOSE table_name; Are you sure you want to do a vacuum full? Normally, that shouldn't be required. -- Jim Nasby

Re: [PERFORM] Table not getting vaccumed.

2006-09-30 Thread Tom Lane
"Nimesh Satam" <[EMAIL PROTECTED]> writes: > I am trying to vaccum one of the table using the following command: > VACUUM FULL ANALYZE VERBOSE table_name; > But for some reason the table vaccuming is not going ahead. VACUUM FULL requires exclusive lock on the table, so it's probably waiting for so

[PERFORM] Table not getting vaccumed.

2006-09-30 Thread Nimesh Satam
Hi,     I am trying to vaccum one of the table using the following command:   VACUUM FULL ANALYZE VERBOSE table_name;       But for some reason the table vaccuming is not going ahead. Can you guys let me know what the problem is.   Regards, Nimesh.