Sample Header Ad - 728x90

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