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