Re: [GENERAL] PostgreSQL profiling?

2001-02-03 Thread Tom Lane
Alex Pilosov [EMAIL PROTECTED] 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

[GENERAL] PostgreSQL profiling?

2001-02-02 Thread Alex Pilosov
A quick question: Have someone made effort to do profiling of pgsql during execution of certain things (inserts, selects, sorting, indices)? 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).