Re: Temporary tables versus wraparound... again
От | Greg Stark |
---|---|
Тема | Re: Temporary tables versus wraparound... again |
Дата | |
Msg-id | CAM-w4HNyZYKDWjd9DSbiqwpmg-g8Lqv6VdGC3b3r9ivSYdFYgw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Temporary tables versus wraparound... again (Greg Stark <stark@mit.edu>) |
Ответы |
Re: Temporary tables versus wraparound... again
|
Список | pgsql-hackers |
Hm, in an optimized build using kernel perf I see this. But I don't know how to find what the call sites are for LWLockAcquire/Release. If it's the locks on pgproc that would be kind of bad. I wonder if I should be gathering horizons once in the PrecommitActions and then just using those for every temp table somehow. Perhaps only actually doing an update if the relfrozenxid is actually at least vacuum_freeze_table_age old. 3.98% postgres LWLockAcquire 3.51% postgres LWLockRelease 3.18% postgres hash_search_with_hash_value 2.20% postgres DropRelationLocalBuffers 1.80% [kernel] check_preemption_disabled 1.52% postgres hash_bytes 1.27% postgres LockAcquireExtended 0.97% postgres _bt_compare 0.95% [kernel] kmem_cache_alloc I still think we should be applying the vacuum warning messages to stable and probably backpatching. I've actually heard from other users who have faced the same surprise wraparound shutdown.
В списке pgsql-hackers по дате отправления: