Postgres problems with large databases.

From: Dan Moschuk <dan(at)freebsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres problems with large databases.
Date: 2000-08-10 21:50:37
Message-ID: 20000810175037.A9569@spirit.jaded.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Greetings,

I'm encounting some strange problems trying to use postgres on a table
with a fairly substantial amount of records (~1 million).

The problem comes when you try and select a record from the database.
Postmaster in debug mode complains whole heartedly about resource errors,
and after that, everything goes downhill (everything from postmaster crashes
to index corruption). This occurs both with 6.5.3 and 7.0.2.

Any pointers/ideas?

-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Perlstein 2000-08-10 21:59:01 Re: Postgres problems with large databases.
Previous Message vectro 2000-08-10 19:50:25 Re: Windows 98