Re: large table support 32,000,000 rows

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/