Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heather Johnson" <hjohnson(at)nypost(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Harry Ford" <hford(at)globix(dot)com>, "Serge Canizares" <serge(at)enluminaire(dot)com>, "Marie Musacchio" <marie(at)nypost(dot)com>
Subject: Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
Date: 2001-12-10 22:34:11
Message-ID: 25115.1008023651@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

"Heather Johnson" <hjohnson(at)nypost(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-12-11 00:24:20 Re: [GENERAL] How to get database schema without pg_dump?
Previous Message bpalmer 2001-12-10 22:34:00 Re: problems doing sub-selects on PostgreSQL 7.1.3 and

Browse pgsql-general by date

  From Date Subject
Next Message William WAISSE 2001-12-10 22:37:37 Re: how to create a database
Previous Message bpalmer 2001-12-10 22:34:00 Re: problems doing sub-selects on PostgreSQL 7.1.3 and