Re: pg_clog questions

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Re: pg_clog questions
Дата
Msg-id 8511B4970E0D124898E973DF496F9B432516EB@stash.stackdump.local
обсуждение исходный текст
Ответ на pg_clog questions  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Список pgsql-admin
Thanks.
I revacumed and now they are gone.


-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Sent: Thursday, May 25, 2006 4:40 PM
To: Benjamin Krajmalnik
Cc: Tom Lane; pgsql-admin@postgresql.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_clog questions
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: pg_clog questions