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