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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
