Re: How much log space does VACUUM need?
| От | Gordon Runkle |
|---|---|
| Тема | Re: How much log space does VACUUM need? |
| Дата | |
| Msg-id | 9atgv9$gh3$1@news.tht.net обсуждение |
| Ответ на | Re: How much log space does VACUUM need? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
In article <7843.986599087@sss.pgh.pa.us>, "Tom Lane" <tgl@sss.pgh.pa.us> wrote: > Not sure if that should be construed as a bug or not; Vadim will have to > answer that. But here's a thought: try increasing CHECKPOINT_TIMEOUT > and/or CHECKPOINT_SEGMENTS so that you don't get intermediate > checkpoints while the vacuum proceeds. Should reduce the thing's > appetite for log space ... Thanks Tom. I didn't get to do anything with this until today -- the power supply on that box fried (at least the 12V side did), during a COPY. I'm running ext2 as the filesystem and even so, things came right up after I fixed the box. So, I'm happy with PostgreSQL's recovery ability! It's WAL worth the effort you put into it. Sorry, it just came to me and I typed before I thought... Gordon. -- It doesn't get any easier, you just go faster. -- Greg LeMond
В списке pgsql-general по дате отправления: