When grilled further on (Tue, 28 Sep 2004 11:04:23 -0400),
Tom Lane <[EMAIL PROTECTED]> confessed:
> Robert Creager <[EMAIL PROTECTED]> writes:
> > Normally, this query takes from 5 minutes to 2 hours to run. On this
> > update, it's been running for more than 10 hours.
>
> > ...
> > ->
When grilled further on (Tue, 28 Sep 2004 21:41:50 -0500),
Kevin Barnard <[EMAIL PROTECTED]> confessed:
> On Tue, 28 Sep 2004 20:21:40 -0600, Robert Creager
> <[EMAIL PROTECTED]> wrote:
> >
> > The trigger keeps another table (catalog) up to date with the information
> > from the obs_v and obs_i
On Tue, 28 Sep 2004 20:21:40 -0600, Robert Creager
<[EMAIL PROTECTED]> wrote:
>
> 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.
>
It's pos
When grilled further on (Tue, 28 Sep 2004 16:55:13 +0200),
Gaetano Mendola <[EMAIL PROTECTED]> confessed:
> Robert Creager wrote:
> > Help?
> >
> > Normally, this query takes from 5 minutes to 2 hours to run. On this
> > update, it's been running for more than 10 hours.
> >
> > Can it be helped
When grilled further on (Tue, 28 Sep 2004 09:28:47 -0500),
Kevin Barnard <[EMAIL PROTECTED]> 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 o
I could spend a week or two tweaking the performance of my database servers
and probably make some sizeable improvements, but I'm not going to.
Why? Because PostgreSQL screams as it is.
I would make sure that if the consensus is to add some sort of caching that
it be done only if there is no hit
Folks,
I'm beginning a series of tests on OSDL's Scalable Test Platform in order to
determine some recommended settings for many of the new PostgreSQL.conf
parameters as well as pg_autovacuum.
Is anyone else interested in helping me with this?
--
--Josh
Josh Berkus
Aglio Database So
Robert Creager wrote:
Help?
Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's
been running for more than 10 hours.
Can it be helped?
When I see this usually means that tables are full of
dead rows. Did you vacuum you DB. Which version are you
using ?
Regards
Gaeta
Robert Creager <[EMAIL PROTECTED]> writes:
> Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's
> been running for more than 10 hours.
> ...
> -> Nested Loop (cost=250.69..129094.19 rows=77211 width=59)
> -> Hash Join (cost=250.69..307.34
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Aaron Werman" <[EMAIL PROTECTED]>
Cc: "Iain" <[EMAIL PROTECTED]>; "Jim C. Nasby" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 28, 2004 9:58 AM
Subject: Re: [PERFORM] Caching of Queries
> "Aaron Werman" <
What does observations_trigger do?
On Tue, 28 Sep 2004 08:19:57 -0600, Robert Creager
<[EMAIL PROTECTED]> wrote:
>
> Help?
>
> Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's
> been running for more than 10 hours.
>
> Can it be helped?
>
> UPDATE obs_v
> SET m
Help?
Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's
been running for more than 10 hours.
Can it be helped?
UPDATE obs_v
SET mag = obs_v.imag + zp.zero_v + cg.color_v * (obs_v.imag - i.imag),
use = true
FROM color_groups AS cg, zero_pair AS zp, obs_i AS
"Aaron Werman" <[EMAIL PROTECTED]> writes:
> I imagine a design where a shared plan cache would consist of the plans,
> indexed by a statement hash and again by dependant objects. A statement to
> be planned would be hashed and matched to the cache. DDL would need to
> synchronously destroy all de
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Cc: "Jim C. Nasby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 27, 2004 11:17 PM
Subject: Re: [PERFORM] Caching of Queries
> "Iain" <[EMAIL PROTECTED]> writes:
> > I can only te
14 matches
Mail list logo
