RE: [GENERAL] Is it possible to work with big databases (up to 10Gb) under Postgres?
I believe if you throw decent hardware at it (the sort of hardware you need to throw at 10GB database to make it perform well) then it is definitely worth giving it a go. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Ivan Babikov > Sent: Monday, 20 August 2001 9:06 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Is it possible to work with big databases > (up to 10Gb) under Postgres? > > > Hello All! > > Maybe this is one of those typical questions, but I have > heard people complaining that Postgres is just for quite > small bases, less than 2Gb. > > Now, we have to choose a free database engine for an > inexpensive branch of our project and Interbase looks better > in sense of capability to work with quite big bases (up to > 10-20Gb). I am not sure that Postgres will work fine with > databases greater than 10Gb. What does All think of it? > > Thanks in advance, Ivan Babikoff. > > > > > > ---(end of > broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Is it possible to work with big databases (up to 10Gb) under Postgres?
Hi Ivan! Well, I don't have a 10 Gb database _yet_; but my server manages 3 databases that currently total over 17 Gb without a problem. (Also, linking tables from different databases by querying via ODBC and MS Access works like a charm!) I used MySQL for a while; and considered Interbase. I moved from MySQL because you can't update one table using data from another table via the standard update SQL statement in MySQL. I never went the Interbase route because at that time: 1. It only imported fixed-length text tables; and 2. The email list I joined seemed dead. Things may have changed since then. The online documentation for PostgreSQL has been very helpful; and the support on this email list is very good. I hope this helps, Andrew Gould --- Ivan Babikov <[EMAIL PROTECTED]> wrote: > Hello All! > > Maybe this is one of those typical questions, but I > have heard people > complaining that Postgres is just for quite small > bases, less than 2Gb. > > Now, we have to choose a free database engine for an > inexpensive branch of > our project and Interbase looks better in sense of > capability to work with > quite big bases (up to 10-20Gb). I am not sure that > Postgres will work fine > with databases greater than 10Gb. What does All > think of it? > > Thanks in advance, Ivan Babikoff. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Is it possible to work with big databases (up to 10Gb) under Postgres?
Hi Ivan, I was running a database with ~27GB of info (admittedly in large, very simple tables) on PostgreSQL 7.0.3 a while ago for a few months. Didn't have any real problems with it, apart from having to accept that a lot of data takes time to process. :-/ Regards and best wishes, Justin Clift Ivan Babikov wrote: > > Hello All! > > Maybe this is one of those typical questions, but I have heard people > complaining that Postgres is just for quite small bases, less than 2Gb. > > Now, we have to choose a free database engine for an inexpensive branch of > our project and Interbase looks better in sense of capability to work with > quite big bases (up to 10-20Gb). I am not sure that Postgres will work fine > with databases greater than 10Gb. What does All think of it? > > Thanks in advance, Ivan Babikoff. > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
