| From: | Virupaksha Kanjilal <v(dot)kanjilal(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Output of pg_controldata |
| Date: | 2013-05-30 20:59:52 |
| Message-ID: | CADm2AyNad_Axj82ZUdK8op7ANrJS26GXCHZMU0r_72jjae1Wpw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi
I want to know the meaning of these fields specifically :
*Latest checkpoint location: 0/5F000020*
*Prior checkpoint location: 0/5E000020*
*Latest checkpoint's REDO location: 0/5F000020*
*
*
*Latest checkpoint's NextXID: 0/1894*
*
*
*Latest checkpoint's NextMultiXactId: 1*
*Latest checkpoint's NextMultiOffset: 0*
Thanks
Viru
On Fri, May 24, 2013 at 2:53 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>wrote:
> Virupaksha Kanjilal escribió:
> > Does anyone know what the fields in the output of pg_controldata mean?
>
> A lot of people. What do you want to know, precisely?
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2013-05-31 05:06:22 | Re: How do I know my table is bloated? |
| Previous Message | Rodrigo Barboza | 2013-05-30 19:08:41 | Re: How do I know my table is bloated? |