Re: PostgreSQL profiling?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL profiling?
Дата
Msg-id 2380.981224518@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL profiling?  (Alex Pilosov <alex@pilosoft.com>)
Ответы Re: PostgreSQL profiling?  (Alex Pilosov <alex@pilosoft.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Fred Yankowski
Дата:
Сообщение: Re: CygIPC 1.08 Source Code : Where ?
Следующее
От: Denni
Дата:
Сообщение: php & postgresql data type