Re: This query is still running after 10 hours...

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: This query is still running after 10 hours...
Date: 2004-09-29 02:21:40
Message-ID: 20040928202140.4ea9d090@thunder.mshome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

When grilled further on (Tue, 28 Sep 2004 09:28:47 -0500),
Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com> confessed:

> What does observations_trigger do?
>

The trigger keeps another table (catalog) up to date with the information from the obs_v and obs_i tables. There are no direct insert/update/delete's on the catalog table, only though the trigger.

--
19:56:54 up 5 days, 22:23, 2 users, load average: 2.46, 2.27, 2.15
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Creager 2004-09-29 02:25:07 Re: This query is still running after 10 hours...
Previous Message Matthew Nuzum 2004-09-29 01:36:43 Re: Caching of Queries