From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | Stephan Vollmer <svollmer(at)gmx(dot)de>, pgsql-performance(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Creation of tsearch2 index is very slow |
Date: | 2006-01-20 20:21:45 |
Message-ID: | 26583.1137788505@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Something I'm missing is the calls to tsearch functions. I'm not 100%
> familiar with gprof, but is it possible those costs have been added
> somewhere else because it's in a shared library? Perhaps the costs went
> into FunctionCall1/3?
I think that the tsearch functions must be the stuff charged as
"data_start" (which is not actually any symbol in our source code).
That is showing as being called by FunctionCallN which is what you'd
expect.
If the totals given by gprof are correct, then it's down in the noise.
I don't think I trust that too much ... but I don't see anything in the
gprof manual about how to include a dynamically loaded library in the
profile. (I did compile tsearch2 with -pg, but that's evidently not
enough.)
I'll see if I can link tsearch2 statically to resolve this question.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | David Blewett | 2006-01-20 20:24:55 | Page-Level Encryption |
Previous Message | Martijn van Oosterhout | 2006-01-20 20:10:36 | Re: [GENERAL] Creation of tsearch2 index is very slow |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-01-20 20:51:32 | Re: [GENERAL] Creation of tsearch2 index is very slow |
Previous Message | Martijn van Oosterhout | 2006-01-20 20:10:36 | Re: [GENERAL] Creation of tsearch2 index is very slow |