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

От: Kevin Grittner
Тема: Re: [Slony1-general] WAL partition overloaded--by autovacuum?
Дата: ,
Msg-id: 4C35EB520200002500033294@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: [Slony1-general] WAL partition overloaded--by autovacuum?  (Richard Yen)
Список: 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", )

Richard Yen <> wrote:

> When you say "bulk-loaded," I suppose that also includes loading
> the data via slony ADD NODE as well--correct?

I would think so.  Anything which loads a lot of data in relatively
few database transactions would qualify; I would think slony would
do this, as it's generally required to get decent performance.

-Kevin


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

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