Re: [GENERAL] Counting all results before LIMIT

2012-10-05 Thread P Gouv
You cant. There is an article about count performance. Generally its slow but latest version 9.2 i think supports index for count under some condition.But 300 isnt that much that you should worry.Another modern solution is to not count results just add one more at limit to see if there is next page

[GENERAL] Add a stemmer for fts

2012-10-05 Thread P Gouv
Hello. I was trying to find a stemmer for greek but it isnt supported out of the box. Dictionaries dont help at all because they just limit the words they do nothing useful for my problem. I found several stemmers in php / java etc from lucene but i am not sure how i can use it with postgresql. I g