How to Manage Lock Requests in Postgres

Each partition has 22 indexes. This suggests that once we had 12 partitions, including all data in one of the partition, and then a partition for each day, the day of this began to struggle with managing the volume of lock requests. So now, remember, let's talk about locks a little bit. When you do an a select on a table, on Postgres at least, or insert or update, you acquire essentially two types of locks,. Something called the table lock, and something called the raw locks.