We dump and vacuum every database every evening, so we can control when the vacuums occur. How does one vacuum the system catalogs? By each tablename pg_*? Thanks, Naomi > > On Mon, Oct 26, 2009 at 3:46 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Anj Adu <fotographs@xxxxxxxxx> writes: >>> We have several partitioned tables that get dropped every day ..We do >>> not do autovacuum as it is an IO hog (and most tables are dropped >>> anyways..and the large tables are never updated).. >> If you're not going to run autovacuum then that means *you* must take >> responsibility for vacuuming everything on a reasonable schedule. >> That includes the system catalogs. I think you'd be better off taking >> the effort to learn to tune autovacuum to fit your requirements. >> >> regards, tom lane >> > -- ------------------------------------------------------------------------ Naomi Walker Chief Information Officer Eldorado Computing, Inc nwalker@xxxxxxxxxxxx ---An Mphasis Company 602-604-3100 ------------------------------------------------------------------------ The grand essentials to happiness in this life are something to do, something to love and something to hope for. - Joseph Addison ------------------------------------------------------------------------ -- CONFIDENTIALITY NOTICE -- Information transmitted by this e-mail is proprietary to MphasiS and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmaster@xxxxxxxxxxx and delete this mail from your records. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
