| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | J Smith <dark(dot)panda+lists(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Errors on missing pg_subtrans/ files with 9.3 |
| Date: | 2013-11-12 16:55:38 |
| Message-ID: | 20131112165538.GG23777@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2013-11-12 11:46:19 -0500, J Smith wrote:
> > * Does SELECT count(*) FROM pg_prepared_xacts; return 0?
>
> Yes it does.
Could you show the output? Do you actually use prepared xacts actively?
Do you actively use row level locking? Is there high concurrency in that
environment? In short, could you describe your database usage a bit?
Did you restart the database since getting the errors?
> Latest checkpoint's NextXID: 0/5138174
> Latest checkpoint's NextOID: 3574036
> Latest checkpoint's NextMultiXactId: 5762623
> Latest checkpoint's NextMultiOffset: 11956824
> Latest checkpoint's oldestXID: 1673
> Latest checkpoint's oldestXID's DB: 1
> Latest checkpoint's oldestActiveXID: 5138174
> Latest checkpoint's oldestMultiXid: 1
Interesting. Pretty high multixact usage.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-11-12 17:00:01 | Re: Clang 3.3 Analyzer Results |
| Previous Message | Stephen Frost | 2013-11-12 16:54:48 | Re: Errors on missing pg_subtrans/ files with 9.3 |