Re: tsearch parser inefficiency if text includes urls or emails - new version
От
Kevin Grittner
Тема
Re: tsearch parser inefficiency if text includes
urls or emails - new version
Дата
Msg-id
4B1E1AFF020000250002D1E1@gw.wicourts.gov
Список
Дерево обсуждения
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls or emails - new version Andres Freund <andres@anarazel.de>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls or emails - new version Andres Freund <andres@anarazel.de>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls
or emails - new version Greg Smith <greg@2ndquadrant.com>
Re: tsearch parser inefficiency if text includes urls or emails - new version Andres Freund <andres@anarazel.de>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls
or emails - new version Greg Smith <greg@2ndquadrant.com>
Re: tsearch parser inefficiency if text includes urls or emails - new version Tom Lane <tgl@sss.pgh.pa.us>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls or
emails - new version Greg Smith <greg@2ndquadrant.com>
Re: tsearch parser inefficiency if text includes urls or emails - new version Andres Freund <andres@anarazel.de>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls or emails - new version Andres Freund <andres@anarazel.de>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes urls or emails - new version Tom Lane <tgl@sss.pgh.pa.us>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: tsearch parser inefficiency if text includes
urls or emails - new version "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
I wrote: > Frankly, I'd be amazed if there was a performance regression, OK, I'm amazed. While it apparently helps some cases dramatically (Andres had a case where run time was reduced by 93.2%), I found a pretty routine case where run time was increased by 3.1%. I tweaked the code and got that down to a 2.5% run time increase. I'm having troubles getting it any lower than that. And yes, this is real, not noise -- the slowest unpatched time for this test is faster than the fastest time with any version of the patch. :-( Andres, could you provide more information on the test which showed the dramatic improvement? In particular, info on OS, CPU, character set, encoding scheme, and what kind of data was used for the test. I'll do some more testing and try to figure out how the patch is slowing things down and post with details. -Kevin
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата: