Re: Dead rows not getting removed during vacuum
| От | Sergey Konoplev |
|---|---|
| Тема | Re: Dead rows not getting removed during vacuum |
| Дата | |
| Msg-id | CAL_0b1tPrAQiyVxcXhKukhZxH9-sffwAcnXCm8ECbtHrepOhCA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Dead rows not getting removed during vacuum (Granthana Biswas <granthana@zedo.com>) |
| Ответы |
Re: Dead rows not getting removed during vacuum
|
| Список | pgsql-general |
On Fri, Mar 21, 2014 at 2:46 AM, Granthana Biswas <granthana@zedo.com> wrote: > We don't have two-phase commit prepared transactions. During vacuum, along with this problem we are also facing streamingreplication issue. Hundreds of xlogs are in ready state in pg_xlog/archive_status. Those are being copied manuallyafter vacuum otherwise rsync happens very slowly and replication lag keeps increasing. Okay, I see. Then next questions are: What postgres version is it? What max_standby_archive_delay and max_standby_streaming_delay are set to? Are there any long running activity or idling in transaction backends on your slaves? -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray.ru@gmail.com
В списке pgsql-general по дате отправления: