Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group