postgresql reindex frequency and monitoring
0
votes
1
answer
532
views
What's up guys. I have a couple of tables where i inserting much of data (and almost never deleting). Periodically i see that insert gains ExclusiveLock on index of table. So i guess that sometimes insert triggers reindex of table. So i wonder how often it happens and how can i see in logs how much time it took and how often it is triggered? Maybe some blogs/docs on it ? thanks in advance.
Asked by ArtemP
(69 rep)
Jul 6, 2016, 09:07 AM
Last activity: Jun 7, 2025, 11:04 AM
Last activity: Jun 7, 2025, 11:04 AM