470,647 Members | 1,085 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Vacuuming specific schemas..


Hi,

Will it be a good idea for vacuum command
to allow vacumming specific schemas?

eg we have a schema for archiving purposes
which we do not want to vacumm everytime
as they are huge.

Rite now we loop thru the table names of particular
schmemas using system catalogs and perl and execute
vacuum.

regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #1
0 1218

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tambet Matiisen | last post: by
2 posts views Thread by John Jenkins | last post: by
6 posts views Thread by Dennis Gearon | last post: by
3 posts views Thread by Joe Maldonado | last post: by
3 posts views Thread by Sami Marzouki | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.