dbTalk Databases Forums  

Vacuuming specific schemas..

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Vacuuming specific schemas.. in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rajesh Kumar Mallah
 
Posts: n/a

Default Vacuuming specific schemas.. - 07-02-2003 , 02:32 AM







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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.