Re: Multiple Indexing, performance impact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Åkerud <zilch(at)home(dot)se>
Cc: "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple Indexing, performance impact
Date: 2001-06-22 18:48:25
Message-ID: 5120.993235705@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch(at)home(dot)se> writes:
> Anyone know what causes the signifacant performance decrease after 7 indexe=
> s?

I'd bet that somewhere around there, you are starting to see thrashing
of the buffer pool due to needing to touch too many different pages to
insert each tuple. What is your -B setting? If you increase it,
does the performance improve?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Åkerud 2001-06-22 19:04:49 TCP/IP Sockets, UNIX Sockets
Previous Message Edwin Grubbs 2001-06-22 18:45:48 web site suggestion

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Åkerud 2001-06-22 19:16:57 Re: Multiple Indexing, performance impact
Previous Message Daniel Åkerud 2001-06-22 18:06:03 Multiple Indexing, performance impact