| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Benjamin Krajmalnik <kraj(at)illumen(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Subject: | Re: pg_clog questions |
| Date: | 2006-05-25 22:39:44 |
| Message-ID: | 20060525223944.GO13700@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Krajmalnik | 2006-05-25 22:43:30 | Re: pg_clog questions |
| Previous Message | Benjamin Krajmalnik | 2006-05-25 22:25:03 | Re: pg_clog questions |