Disadvantages of creating multiple indexes in a PostgreSQL table

Viewed 6432

After reading documentation on indexes I thought

Hey, since (in my case) almost always reading from database is performed much more often than writing to it, why not create indexes on most fields in the table?

Is it right attitude? Are there any other downsides of doing this, except longer inserting?

Of course, indexes would be limited to fields that I actually use in conditions of SELECT statements.

2 Answers
Related