[SQL] Column Index vs Record Insert Trade-off?

[Ken Hill]

Is there a performance trade-off between column indexes and record inserts?

I know that in MS Access there is such a trade-off. This being indexes make SQL queries perform faster at the cost of record insert speed. Put another way, the more column indexes in a table, the slower a record insert in that table performs.

Is there a similar trade-off in PostgreSQL?