Column Index vs Record Insert Trade-off? - Mailing list pgsql-sql

From Ken Hill
Subject Column Index vs Record Insert Trade-off?
Date
Msg-id 1139450040.15713.3.camel@localhost.localdomain
Whole thread Raw
Responses Re: Column Index vs Record Insert Trade-off?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Is there a performance trade-off between column indexes and record inserts?<br /><br /> I know that in MS Access there
issuch 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.<br /><br /> Is there a
similartrade-off in PostgreSQL?  

pgsql-sql by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: Syntax for "IF" clause in SELECT
Next
From: george young
Date:
Subject: unique constraint instead of primary key? what disadvantage(ODBC usage)?