Re: Is it possible to work with big databases (up to 10Gb) under Postgres?

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)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>