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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

  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,


Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!


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-2017 The PostgreSQL Global Development Group