| 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
| 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 |
| 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 |