Reply To: How To Find A Toast Table’s Primary Table In Postgres

IT Support Forum Forums Databases PostgreSQL General Discussion How To Find A Toast Table’s Primary Table In Postgres Reply To: How To Find A Toast Table’s Primary Table In Postgres

#2501
Webmaster
Keymaster

Personally, I found that there was a toast table that was being vacuumed for too long and I wanted to work out what the primary table for the toast table was, so I could deal with the problem. I used the above trick to find the table name that the toast table was related to. Once I had that, I could then understand why it was getting vacuumed so much (in my case, the data could have been stored in a better way and it was getting updated regularly and this wasn’t necessary. I stopped that and the associated toast table was no longer being constantly vacuumed).