All, >>> I have a client who uses temp tables heavily, hundreds of thousands of >>> creates >>> and drops per day. They also have long running queries. The only thing that >>> keeps catalog bloat somewhat in check is vacuum full on bloated catalogs >>> a few times a day. With
Actually, this is a good point ... if we dropped VACUUM FULL, we'd need to also be able to call CLUSTER (or VACUUM REWRITE) on the system catalogs. -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
