Different file system but we've loaded 39,000,000 row tables (about 30 gigs of spatial data) without any issues ... CPU load was 1.something for a while but not problems with loading, indexing or doing the stats command. I might suspect the underlying OS ... Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: Bernhard Ankenbrand [mailto:b.ankenbrand@media-one.de] Sent: Tuesday, April 06, 2004 4:22 AM To: pgsql-general@postgresql.org Subject: Crash in postgres/linux on verly large database Hi, we have a table width about 60.000.000 entrys and about 4GB storage size. When creating an index on this table the whole linux box freezes and the reiser-fs file system is corrupted on not recoverable. Does anybody have experience with this amount of data in postgres 7.4.2? Is there a limit anywhere? Thanks Bernhard Ankenbrand ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
