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

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 (view raw or flat)
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

pgsql-performance by date

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

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