Re: [GENERAL] Creation of tsearch2 index is very slow

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-performance by date

  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