On 11.05.11 15:45, "Pavel Stehule" <pavel.stehule@xxxxxxxxx> wrote: >it is expected behave :( . A loading of ispell dictionary is very slow. > >Use a german snowball instead. > >You can you a some pooling connection software too. Thank you for the response. Is the dictionary german_stem supplied with postgresql a snowball stemmer? If yes, it sure is incredibly fast, but yields much worse results and thus fewer and worse matches for search queries. To use connections pooling is...difficult in my situation, to say the least. We currently use quite a complex pgcluster/corosync setup for multi-master replication, load balancing and high availability. To introduce connection pooling to this setup could turn out to be quite a big project. -- Stanislav Raskin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general