Peterson, Bjorn wrote:
My coworkers and I studied the EXPLAIN and EXPLAIN ANALYZE output for this
query and determined that the query planner seemed to be causing problems
with this query. By calling "set enable_nestloop = off" before executing
our query we were able to get the execution time down
: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Zombie processes
My coworkers and I studied the EXPLAIN and EXPLAIN ANALYZE output for this
query and determined that the query planner seemed to be causing problems
with this query. By calling "set enable_nestloop = off" before executing
2 minutes,
which is acceptable for our purposes.
Thanks for your response-
Bjorn
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 1:31 AM
To: Peterson, Bjorn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Zombie processes
Peter
Peterson, Bjorn wrote:
I am running Postgres 8.0.1 on a Windows 2000 server as a service, and the
query returns appropriate values after about 30 seconds when executed from a
psql console. However, when running this query from a Java application on
the same machine through the postgres JDBC driver
I’m running out of ideas for the following problem:
I have a moderately complex query as follows-
SELECT t.term_id, a.user_id, a.time_slot, a.status,
SUM(CASE WHEN a.date>=t.start_date THEN 1 ELSE 0 END),
COUNT(a. date)
FROM "Table1" a, "Table2" t, "Table2"
ytd, "Table3" cu, "Ta
