Re: Postgres problems with large databases.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: Dan Moschuk <dan(at)freebsd(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres problems with large databases.
Date: 2000-08-11 05:42:15
Message-ID: 1153.965972535@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alfred Perlstein <bright(at)wintelcom(dot)net> writes:
> * Dan Moschuk <dan(at)freebsd(dot)org> [000810 14:55] wrote:
>> I'm encounting some strange problems trying to use postgres on a table
>> with a fairly substantial amount of records (~1 million).

> First off I'm sure the developers would like to know more than:
> "complains whole heartedly about resource errors"
> can you name the errors specifically?

Indeed. 1 million records is by no means an impressive amount ---
lots of people are using PG with multi-gigabyte databases.
We need more details about your database setup and the exact errors
you are seeing (as well as the exact queries that produce 'em).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Tille 2000-08-11 06:52:26 Re: pg_dump and restore
Previous Message Daryl Sayers 2000-08-11 04:44:46 Date storage class type