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