Crash in postgres/linux on verly large database

From: Bernhard Ankenbrand <b(dot)ankenbrand(at)media-one(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Crash in postgres/linux on verly large database
Date: 2004-04-06 11:22:26
Message-ID: 407292F2.5070305@media-one.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Schapachnik 2004-04-06 12:16:55 Re: pg_autovacuum won't make on FreeBSD
Previous Message Rajat Katyal 2004-04-06 08:45:01 PERFORM statement inside procedure