Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-19 Thread Wojciech Knapik
psql multiple times and paste the result. All the results I pasted had the medium run time out of multiple calls. These were certainly not some extreme corner cases. cheers, Wojciech Knapik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-19 Thread Wojciech Knapik
this? Thanks a lot for looking into this. I hope this will lead to some improvements one day. Unfortunately my C skills were pretty basic years ago and I haven't used the language since, so I can't be of much help.. cheers, Wojciech Knapik -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-18 Thread Wojciech Knapik
. cheers, Wojciech Knapik PS. Weird, I get the emails without a reply-to set for the list.. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-18 Thread Wojciech Knapik
for an ispell dictionary ? I didn't realize that. Sorry for the bother then. It just seemed way too slow to be practical. cheers, Wojciech Knapik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-18 Thread Wojciech Knapik
times... This is 8.4.1 version of PostgreSQL. An that was 8.3.8/OSX. cheers, Wojciech Knapik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-18 Thread Wojciech Knapik
lists to find out. If you're saying this is ok and there's nothing to fix here, then there's nothing more to discuss and we may consider the thread closed. If not, ts_headline deserves a closer look. cheers, Wojciech Knapik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] Very bad FTS performance with the Polish config

2009-11-17 Thread Wojciech Knapik
sure you can easily reproduce my results. I'm putting my code into production tomorrow, since I can't wait anymore. Hints would be very much appreciated! cheers, Wojciech Knapik PS. This issue is not related to the loading time of dictionaries, or calls to ts_headline for results that won't

[HACKERS] Very bad FTS performance with the Polish config

2009-11-17 Thread Wojciech Knapik
for themselves. I'm sure you can easily reproduce my results. I'm putting my code into production tomorrow, since I can't wait anymore. Hints would be very much appreciated! cheers, Wojciech Knapik PS. This issue is not related to the loading time of dictionaries, or calls to ts_headline for results

Re: [HACKERS] Very bad FTS performance with the Polish config

2009-11-17 Thread Wojciech Knapik
: http://pastie.textmate.org/private/4iaipottrmjmfxfykz94mw cheers, Wojciech Knapik PS. Sorry for the double post. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers