Can too many btree indexes cause page level locking?
I read this…
http://www.postgresql.org/docs/7.4/static/locking-indexes.html
The concern is the exclusive page-level locking that occurs on inserts to the index.
I am experiencing locking related on two tables. Each has several indexes on it (4 or more). One table is frequently updated (20%), occasional inserts(10%), and many reads (70%) and the other has many inserts and reads every 20 secs.
The largest table is with many inserts currently has 2.5 million records and has inserts of about 200 per second. The read is every 20 seconds.
Thanks,
Brian