Thanks. I revacumed and now they are gone. -----Original Message----- From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] Sent: Thursday, May 25, 2006 4:40 PM To: Benjamin Krajmalnik Cc: Tom Lane; pgsql-admin@xxxxxxxxxxxxxx; Matthew T. O'Connor Subject: Re: [ADMIN] pg_clog questions Benjamin Krajmalnik wrote: > I just ran both VACUUM ANALYZE and VACUUM on all of the databases (the > project database and the database created for the default user). > All of the commit logs are still there. Did you vacuum the template1 (and possibly postgres) databases as well? > Do they get cleared only by VACUUM FULL? No, VACUUM suffices. > On another subject, is there a query I can run to find out who the owner > of a filenode is? Sure -- pg_class.relowner from pg_class where relfilenode = ' ... ' -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
