"Trevor Ball" <[EMAIL PROTECTED]> 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

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to