Re: [PERFORM] Table not getting vaccumed.

"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

Re: [PERFORM] how to optimize postgres 8.1

Hi, Gurkan, [EMAIL PROTECTED] wrote: > If I run the query below with informix, it gives cost=107. > with postgres with additional indexes it gives cost=407, before the additional > indexes it was even much slower What are your real timing measurements, in a produciton-like setup in a production-

[PERFORM] Table not getting vaccumed.

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.