Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple Indexing, performance impact - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple Indexing, performance impact
Date
Msg-id 5120.993235705@sss.pgh.pa.us
Whole thread Raw
In response to Multiple Indexing, performance impact  (Daniel Åkerud <zilch@home.se>)
List pgsql-general
Tree view 
=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch@home.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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Rerefences to derived rows
Next
From: Daniel Åkerud
Date:
Subject: TCP/IP Sockets, UNIX Sockets