Postgres Pro
Downloads
Home   >   mailing lists

Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7 - Mailing list pgsql-admin

From Tom Lane
Subject Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
Date
Msg-id 25115.1008023651@sss.pgh.pa.us
Whole thread Raw
In response to problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7  ("Heather Johnson" <hjohnson@nypost.com>)
List pgsql-admin
Tree view 
"Heather Johnson" <hjohnson@nypost.com> writes:
> I have been having trouble getting subselect queries to complete on a Sun E=
> -450 running Solaris 7 and PostgreSQL 7.1.3. Just about any subselect query=
>  I try to run will fail to complete execution---Postgres's serverlog indica=
> tes that the process associated with the query gets killed after a few minu=
> tes have gone by.

Could we see the exact text of the log entries?

Is it possible that you have some kernel limit on CPU time, memory
space, etc expended by any one backend process?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Heather Johnson"
Date:
Subject: FOLLOW UP: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] How to get database schema without pg_dump?