Re: PostgreSQL profiling?

Thanks Tom.

I think that in future, locale setting should be a disclosed part of
benchmark results whenever PostgreSQL is benchmarked.

-alex



On Sat, 3 Feb 2001, Tom Lane wrote:

> Alex Pilosov <alex@pilosoft.com> writes:
> > Have someone made effort to do profiling of pgsql during execution of
> > certain things (inserts, selects, sorting, indices)?
>
> Yes ...
>
> > I have a feeling (based on stopping postgres from gdb periodically), that
> > a lot of time is used in strcoll() (if table and index has string
> > columns).
> > Column in question is declared char(3).
> > So, why's postgres collating anything at all?
>
> Because textual comparisons are defined in terms of strcoll() if you've
> enabled locale support.  There is no way around this; either don't use
> locales or write a faster version of strcoll().
>
>             regards, tom lane
>
>