Re: Errors on missing pg_subtrans/ files with 9.3

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