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 Krosing||Date: 2002-12-10 20:50:22|
|Subject: Re: Performance of multi-column index on INSERT|
|Previous:||From: Tom Lane||Date: 2002-12-10 00:08:03|
|Subject: Re: questions about disk configurations |