Re: [Slony1-general] WAL partition overloaded--by autovacuum?

От: Kevin Grittner
Тема: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата: ,
Msg-id: 4C35DADF020000250003326D@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Robert Haas)
Ответы: Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen)
Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

WAL partition overloaded--by autovacuum?  (Richard Yen, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
  Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
   Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Robert Haas, )
    Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
     Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
       Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
        Re: [Slony1-general] WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Tom Lane, )
       Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
     Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Tom Lane, )
      Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
   Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Greg Smith, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
 Re: WAL partition overloaded--by autovacuum?  (Scott Marlowe, )
 Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Mark Kirkwood, )
  Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen, )
 Re: WAL partition overloaded--by autovacuum?  ("Kevin Grittner", )

Robert Haas <> wrote:

> I don't understand how you managed to fill up 37GB of disk with
> WAL files.  Every time you fill up checkpoint_segments * 16MB of
> WAL files, you ought to get a checkpoint.  When it's complete, WAL
> segments completely written before the start of the checkpoint
> should be recyclable.  Unless I'm confused, which apparently I am.

You're not alone.  At first I was assuming that it was because of
archiving, but the OP says that's turned off.  Unless it had been on
and there wasn't a *restart* after changing the configuration, I
can't see how this could happen, and was hoping someone else could
cast some light on the issue.

The one setting that gave me pause was:

commit_siblings=200

but it doesn't seem like that should matter with:

commit_delay=0;

-Kevin


В списке pgsql-performance по дате сообщения:

От: "Joshua D. Drake"
Дата:
Сообщение: Re: performance on new linux box
От: Craig Ringer
Дата:
Сообщение: Re: Need help in performance tuning.