Re: pg_log

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_log
Дата
Msg-id 6990.983907079@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_log  (Alvaro Herrera <alvherre@protecne.cl>)
Список pgsql-general
Alvaro Herrera <alvherre@protecne.cl> writes:
> ARAIK, pg_log records which tuples are "active" and which ones are
> obsolete, so I'm not going to delete it.

Actually, it records which transactions committed and which didn't.
So, you can slow the rate of growth of pg_log if you can reduce the
number of transactions used.  Consider wrapping sequences of operations
into begin/end blocks.

> I know I can dump and restore from a clean (empty) install,
> but is there a simpler way?

Afraid not.  pg_log is critical data.

            regards, tom lane

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

Предыдущее
От: "Francis Solomon"
Дата:
Сообщение: RE: [SQL] Date question
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: PostgreSQL 7 on Solaris 8 - Is it working?