Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
| От | Heather Johnson |
|---|---|
| Тема | Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7 |
| Дата | |
| Msg-id | 01de01c18252$842a2c10$510b10ac@sephie обсуждение исходный текст |
| Ответ на | How to get database schema without pg_dump? ("Boban Acimovic" <acim@mbl.is>) |
| Ответы |
Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
|
| Список | pgsql-admin |
Hi Tom--
Sure, this is what I get:
2001-12-11 09:40:24 DEBUG: StartTransactionCommand
2001-12-11 09:40:24 DEBUG: query: select count(*) from users where id not in (select users_id from users_demographics)
/opt/postgres/bin/postmaster: reaping dead processes...
/opt/postgres/bin/postmaster: CleanupProc: pid 26260 exited with status 0
2001-12-11 09:40:24 DEBUG: query: select count(*) from users where id not in (select users_id from users_demographics)
/opt/postgres/bin/postmaster: reaping dead processes...
/opt/postgres/bin/postmaster: CleanupProc: pid 26260 exited with status 0
The E-450 box is managed by someone other than myself, but I've asked the person primarily responsible for managing it about quotas and other externally imposed resource limits. He doesn't think that there are any.
Heather
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Heather Johnson" <hjohnson@nypost.com>
Cc: <pgsql-admin@postgresql.org>; "Harry Ford" <hford@globix.com>; "Serge Canizares" <serge@enluminaire.com>; "Marie Musacchio" <marie@nypost.com>
Sent: Monday, December 10, 2001 5:34 PM
Subject: Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
> > 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 по дате отправления: