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.

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 <iab@qms.e-burg.ru> 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/

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

Ivan,

I have 2 databases that are about 400GB each. Some of the tables have
over 60 Million rows. The problem area's that I see are vacuum's,
reindexing, dumps and upgrades.

Speed doesn't seem to be an issue for me. The application was converted
from Oracle. An application transaction hit between 10 to 20 tables.
Most transactions execute under 1 second.

The systems are Intel P3 500's running RedHat 6.2 with 600G of disk
space and 512M of Ram.

Hope this helps.

Let me know if you need any more info

Jim

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)---------------------------

"JB" == Jim Buttafuoco <jim@spectrumtelecorp.com> writes:

JB> from Oracle. An application transaction hit between 10 to 20 tables.
JB> Most transactions execute under 1 second.

JB> The systems are Intel P3 500's running RedHat 6.2 with 600G of disk
JB> space and 512M of Ram.

What kind of performance tuning did you do? Most interesting to me
would be your SHM and SEM kernel settings, and your postgres tuning
parameters (max connections, max memory, etc.)

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/