From: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(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:43:30 |
Message-ID: | 8511B4970E0D124898E973DF496F9B432516EB@stash.stackdump.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks.
I revacumed and now they are gone.
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Thursday, May 25, 2006 4:40 PM
To: Benjamin Krajmalnik
Cc: Tom Lane; pgsql-admin(at)postgresql(dot)org; 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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2006-05-26 02:20:46 | Re: pg_clog questions |
Previous Message | Alvaro Herrera | 2006-05-25 22:39:44 | Re: pg_clog questions |