Re: Postgres problems with large databases. - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres problems with large databases.
Date
Msg-id 1153.965972535@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres problems with large databases.  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-general
Alfred Perlstein <bright@wintelcom.net> writes:
> * Dan Moschuk <dan@freebsd.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

pgsql-general by date:

Previous
From: Daryl Sayers
Date:
Subject: Date storage class type
Next
From: Andreas Tille
Date:
Subject: Re: pg_dump and restore