Re: Crash in postgres/linux on verly large database

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(dot)ankenbrand(at)media-one(dot)de]
Sent: Tuesday, April 06, 2004 4:22 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] 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