Postgres Pro
Downloads
Home   >   mailing lists

Re: Errors on missing pg_subtrans/ files with 9.3 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Errors on missing pg_subtrans/ files with 9.3
Date
Msg-id 20131112165538.GG23777@awork2.anarazel.de
Whole thread Raw
In response to Re: Errors on missing pg_subtrans/ files with 9.3  (J Smith <dark.panda+lists@gmail.com>)
Responses Re: Errors on missing pg_subtrans/ files with 9.3  (J Smith <dark.panda+lists@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Errors on missing pg_subtrans/ files with 9.3
Next
From: Tom Lane
Date:
Subject: Re: Clang 3.3 Analyzer Results