| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] pg_multixact issues |
| Date: | 2014-09-19 02:37:55 |
| Message-ID: | 20140919023755.GS4701@eldon.alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
Dev Kumkar wrote:
> On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
> wrote:
> > Can you show pg_controldata output and the output of 'SELECT oid,
> > datname, relfrozenxid, age(relfrozenxid), relminmxid FROM pg_database;'?
> >
>
> Here are the details:
> oid datname datfrozenxid age(datfrozenxid) datminmxid
> 16384 myDB 1673 10872259 1
Can you paste the pg_controldata output please?
Also, what files are there in pg_multixact/offsets/ ?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Guenther | 2014-09-19 02:40:58 | Re: Watching Views |
| Previous Message | Robert Nix | 2014-09-19 01:50:21 | Re: Re: How can i monitor exactly what (partition) tables are accessed by a query? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2014-09-19 04:22:32 | Re: Anonymous code block with parameters |
| Previous Message | Andrew Gierth | 2014-09-19 01:45:29 | Re: Final Patch for GROUPING SETS |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2014-09-19 07:33:57 | Re: [GENERAL] pg_multixact issues |
| Previous Message | Adrian Klaver | 2014-09-18 21:47:04 | Re: [GENERAL] [SQL] pg_multixact issues |