Re: large table support 32,000,000 rows

are you running that on 32 bit or 64 bit hardware? I have an 18G
database which is mostly one table. Dumps and restores in
about 2-4 hours but sometimes is slow on certain operations.
Running it on 4G Ram, redhat 7.2 enterprise kernel.

> Hi!
> There are no problems with large tables.
> I am running postgresql with a database with over 100,000,000
records.
> The biggest table is with about 55,000,000 rows there are tables
with with
> 25,000,000 and 19,000,000 rows and few other with less than
10,000,000. It
> works pretty good. It's online at http://www.astro.bas.bg/
stargazer/ .
> The performance is excellent. The database is about 15G.
> The only problem was dump and restore while upgrading to 7.2
it took about 5
> days.
>
> Rumen
>
> --- Christopher Smith <christopherl_smith(at)yahoo(dot)com> wrote:
> >
> > I have a set of data that will compose a table with 32 million
rows. I
> > currently run postgresql with tables as large as 750,000 rows.
> >
> > Does anyone have experience with such large tables data. In
addition, I
> > have been reading information on moving postgresql tables to
> >
> > another hard-drive can anyone advise me.
> >
> > Thanks
> >
> >
> >
> > ---------------------------------
> > Do You Yahoo!?
> > Yahoo! Movies - coverage of the 74th Academy Awards
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards
> http://movies.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister
command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)
>
>