Re: how to truncate/purge the pg_xlog directory?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: how to truncate/purge the pg_xlog directory?
Дата
Msg-id 470F7F2C.6080206@archonet.com
обсуждение исходный текст
Ответ на Re: how to truncate/purge the pg_xlog directory?  (tfinneid@student.matnat.uio.no)
Список pgsql-general
tfinneid@student.matnat.uio.no wrote:
>> As checkpoints are issued, old WAL files will either be recycled
>> (renamed) or deleted. Change the setting, then try (as user postgres)
>> issuing a "vacuum full <tbl>" followed by "SELECT pg_switch_xlog()" that
>> should recycle them quicker. That'll only get you down to 3 or 4 files
>> though - that's the minimum.
>
> Nothings changed yet, maybe I need to start using the db again before I
> something real happens...

The timestamps on the WAL files should be updated if they get recycled.
Check those.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: "Relyea, Mike"
Дата:
Сообщение: Out of memory with ODBC
Следующее
От: Clemens Schwaighofer
Дата:
Сообщение: Query problem