Re: Limitations on 7.0.3?

On Wed, Jun 06, 2007 at 02:40:08PM -0500, ARTEAGA Jose wrote:
> I have been using postgres 7.0.3 (Solaris 2.9) for the past 4 years
> without any major problems, until about a month ago. We are now
> experiencing crashes on the backend (connection lost to backend) while
> running queries (inserts, etc). Anyway I don't want to make this too
> technical but I'd just like to understand if maybe I'm running into some
> sort of limit on the size of the database. My biggest table is currently
> at 1.5B tuples.

I don't believe it's a size limit. But 7.0 is pre-WAL. Are you
running with the -F switch turned on, for performance? It could well
be that you are running into data corruption that crashes the
database. (The lack of WAL is not the only reason you might be
running into that. 7.0 is a long time ago, and there are a lot of
bugs that have been squished since then.)

A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
However important originality may be in some fields, restraint and
adherence to procedure emerge as the more significant virtues in a
great many others. --Alain de Botton