Re: Index Slowing Insert >50x - Mailing list pgsql-performance

From Tom Lane
Subject Re: Index Slowing Insert >50x
Date
Msg-id 10297.1107235755@sss.pgh.pa.us
Whole thread Raw
In response to Index Slowing Insert >50x  ("Trevor Ball" <TBall@eppcon.com>)
List pgsql-performance
"Trevor Ball" <TBall@eppcon.com> writes:
> ... it doesn't
> seem reasonable to me that an index would slow an insert more than
> 50-fold, regardless of hardware or the nature of the index.

Seems pretty slow to me too.  Can you provide a self-contained test
case?

One possibility is that depending on your platform and locale setting,
varchar comparisons can be a whole lot slower than a normal person would
consider sane.  If you're not using C locale, you might try C locale and
see if it helps.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Automagic tuning
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Automagic tuning