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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]) > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
