| From: | Granthana Biswas <granthana(at)zedo(dot)com> |
|---|---|
| To: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
| Cc: | PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Dead rows not getting removed during vacuum |
| Date: | 2014-03-21 09:46:36 |
| Message-ID: | CAACh-pXCnsBXN1SbmV09jAfei19f3kbcV2R7UcuybU6LuhWi8g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Sergey,
We don't have two-phase commit prepared transactions. During vacuum, along
with this problem we are also facing streaming replication issue. Hundreds
of xlogs are in ready state in pg_xlog/archive_status. Those are being
copied manually after vacuum otherwise rsync happens very slowly and
replication lag keeps increasing.
Regards,
Granthana
On Fri, Mar 21, 2014 at 3:36 AM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:
> On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas <granthana(at)zedo(dot)com>
> wrote:
> > Has anyone ever faced the issue of dead rows not getting removed during
> > vacuum even if there are no open transactions/connections?
>
> What does the pg_prepared_xacts view show?
>
> --
> 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(dot)ru(at)gmail(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashmita Jain | 2014-03-21 10:16:57 | COPY error with null date |
| Previous Message | Granthana Biswas | 2014-03-21 05:20:37 | Re: Dead rows not getting removed during vacuum |