dbTalk Databases Forums  

Using postgres for large database

comp.databases.postgresql comp.databases.postgresql


Discuss Using postgres for large database in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM






Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #12  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM






Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #13  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM



Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #14  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM



Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #15  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM



Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #16  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM



Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
  #17  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Using postgres for large database - 10-20-2008 , 02:48 AM



Daniil Baturin <dmbaturin (AT) gmail (DOT) com> wrote:
Quote:
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?
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.