Hello!
I'm newbie in databases but I have a project where it's necessary. I
need a DB software to store about a few Gb of text (xml) documents and
provide full-text search.
Would postgres be a good choice?

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin ha scritto:
links are a good start

http://lucene.apache.org/java/docs/
http://www.postgresql.org/docs/8.3/s...extsearch.html

Mirco

Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
I think it would be.
"A few GB" ist not exactly large these days.

PostgreSQL has full text search capability built in since version 8.3,
as well as support for an XML data type.

Keep in mind that, like other database systems, PostgreSQL will need
some maintenance: you'll have to concieve and implement a backup
strategy, and you should regulary check the log files to see if it is happy.

PostgreSQL has a client-server architecture, so you'll have to have a
database server process running somewhere.

Yours,
Laurenz Albe