You have plenty other FTS options: postgres has built-in FTS (tsearch), and
if you need something more lightweight than Solr, you can use Sphinx.
2010/8/20 Miguel Vaz
>
> Thank you all for your replies. I already had read about Lucene in its
> general flavour and eventually caught up about it
Am 20.08.2010 23:10, schrieb Wang, Mary Y:
Hi,
I'm having a problem right now. Some of our French users uploaded
some files with file names that had French accent marks, and those
file names were inserted into the Postgres database. When I examined
the value of those file names, they all ha
On Fri Aug 20 05:10 PM, Wang, Mary Y wrote:
>
> So my questions are:
> (1) What is the best character encoding that would work for most of
> those languages that have accent marks?
Store data in PostgreSQL as UTF-8
> (2) I assume that I also
> need to do some kind of conversion in the front end
After reading the documentation on Full Text Search here
http://www.postgresql.org/docs/8.4/interactive/textsearch-tables.html I
created the following table and index:
CREATE TABLE item (
pk uuid primary key,
...
[more columns here]
...
searchable_text text not null
);
CREATE INDEX item_
After reading the documentation on Full Text Search here
http://www.postgresql.org/docs/8.4/interactive/textsearch-tables.html I
created the following table and index:
CREATE TABLE item (
pk uuid primary key,
...
[more columns here]
...
searchable_text text not null
);
CREATE INDEX ite
Derrick Rice wrote:
> I've been reading up on the documentation for WAL shipping and warm standby
> configuration. One concern that I have (a common one, I'm sure) is that it
> seems that after bringing a standby server up as primary, other standby
> servers (including the original primary) need to
Is anyone else having problems accessing the mailing lists through NNTP?
-arturo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/8/18 Arturo Pérez :
> Is anyone else having problems accessing the mailing lists through NNTP?
Yeah, I see the occasional message coming through, but it looks like
the gateway between mail and NNTP isn't working.
--
http://linuxfinances.info/info/linuxdistributions.html
--
Sent via pgsql-g
Hi,
Using Postgres 8.4, I create this table:
rcs_test=> \d array_big1;
Table "public.array_big1"
Column | Type | Modifiers
---+--+---
id| integer | not null
chunk_ids | bigint[] |
Indexes:
"array_big1_pkey" PRIMARY KEY, btree (id)
It's initial
