Gavin Sherry wrote:
> I had a look at your data -- thanks.
> I have a question though: put_token() is invoked 120596 times in your
> benchmark... for 616 messages. That's nearly 200 queries (not even
> counting the 1-8 (??) inside the function itself) per message. Something
> doesn't seem right there....
I am pretty sure that's right because it is doing word statistics on
I need to spend some time studying the code, I just haven't found time yet.
Would it be safe to say that there isn't any glaring performance
penalties other than the sheer volume of queries?
In response to
pgsql-performance by date
|Next:||From: Chris Travers||Date: 2005-07-29 05:23:15|
|Subject: Re: Left joining against two empty tables makes a query|
|Previous:||From: Gnanavel S||Date: 2005-07-29 04:38:49|
|Subject: Re: Two queries are better than one?|