Postgres Pro
Downloads
Home   >   mailing lists

Re: This query is still running after 10 hours... - Mailing list pgsql-performance

From Robert Creager
Subject Re: This query is still running after 10 hours...
Date
Msg-id 20040928202140.4ea9d090@thunder.mshome.net
Whole thread Raw
In response to Re: This query is still running after 10 hours...  (Kevin Barnard <kevin.barnard@gmail.com>)
Responses Re: This query is still running after 10 hours...  (Kevin Barnard <kevin.barnard@gmail.com>)
List pgsql-performance
Tree view 
When grilled further on (Tue, 28 Sep 2004 09:28:47 -0500),
Kevin Barnard <kevin.barnard@gmail.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
nodirect 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
Attachment

pgsql-performance by date:

Previous
From: "Matthew Nuzum"
Date:
Subject: Re: Caching of Queries
Next
From: Robert Creager
Date:
Subject: Re: This query is still running after 10 hours...