Column Index vs Record Insert Trade-off?

From: Ken Hill <ken(at)scottshill(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Column Index vs Record Insert Trade-off?
Date: 2006-02-09 01:53:59
Message-ID: 1139450040.15713.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message george young 2006-02-09 02:04:55 unique constraint instead of primary key? what disadvantage(ODBC usage)?
Previous Message Bricklen Anderson 2006-02-08 23:20:45 Re: Syntax for "IF" clause in SELECT