tsearch2 from CVS HEAD). or are you suggesting to use the 8859
stemmers with a utf8 tsearch install?
regards, thies
Am 22.02.2006 um 08:26 schrieb Teodor Sigaev:
Contact with Alexander Presber about
dictionaries, he now work on it. UTF8 will work only in CVS HEAD
(8.2 release in the future
hi,
i'm using tsearch2 from HEAD with 8.1.3 (with some 8.1.x compile
fixes) and want to use the UTF8 snowball stemmers. so far (haven't
really hacked on it yet) with little success. i've seen some messages
on the list lately but i failed to find a step-by-step guid how to
use the utf8 ste
hi,
use "cp /dev/null pqsql.log" to truncate the logfile "in place" and
free some space.
re, thies
Am 08.12.2005 um 23:26 schrieb Ed L.:
On Thursday December 8 2005 9:19 am, Oleg Bartunov wrote:
I'd do
echo > pgql.log
That won't free any space from an open file. You have to stop
postg
hello,
i have a table with documents that have an id and belong to a pool:
(the sample tables have no indices, i know)
Table "public.asset"
Column | Type | Modifiers
--+-+---
asset_id | integer |
pool_id | integer |
content | text|
each pool belongs to
Am 16.11.2005 um 14:49 schrieb Martijn van Oosterhout: i understand that postgres has to read every row from the heap to make sure that they are all still valid and count. but from my understanding query (a) would have something like an uncorrected count (somewhere internally) for the whole quer
Am 16.11.2005 um 14:07 schrieb Richard Huxton:You don't say what applicaton language you are using, but most offer a pg_num_rows() interface which tells you how many results are in the recordset you have fetched. my query uses LIMIT and OFFSET - so pg_num_rows will return what i specify in LIMIT (o
hi,
i have some system where i show pages results on a web-page - the query
that returns the paged result looks like this:
(table has a few hundred thousand rows, result-set is ~3)
a) select asset.asset_id, asset.found_time from asset.asset WHERE
found_time > 1130926914 AND pool_id in (1
