Skip site navigation (1) Skip section navigation (2)

Performance of multi-column index on INSERT

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-performance(at)postgresql(dot)org>
Subject: Performance of multi-column index on INSERT
Date: 2002-12-10 16:55:31
Message-ID: 20021210165531.67062.qmail@web80305.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi:

  Is the performance overhead of creating a
multi-column index greater than creating an individual
index for each column? (i.e. Is the INSERT slower for
a table with a three column index than a similar table
with three single column indices?).

   I was wondering this because according to
PostgreSQL Manual in the section on multi-columned
indexes "Multicolumn indexes should be used sparingly.
Most of the time, an index on a single column is
sufficient and saves space and time".


Thank you very much,

ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

Responses

pgsql-performance by date

Next:From: Hannu KrosingDate: 2002-12-10 20:50:22
Subject: Re: Performance of multi-column index on INSERT
Previous:From: Tom LaneDate: 2002-12-10 00:08:03
Subject: Re: questions about disk configurations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group