Re: Quad Opteron stuck in the mud

From: Dan Harris <fbsd(at)drivefaster(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Quad Opteron stuck in the mud
Date: 2005-07-13 20:20:24
Message-ID: 7C8917ED-62B8-4D76-AC02-90CF04002C97@drivefaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jul 13, 2005, at 2:17 PM, Stephen Frost wrote:
>
> Could you come up w/ a test case that others could reproduce where
> explain isn't returning?

This was simply due to my n00bness :) I had always been doing
explain analyze, instead of just explain. Next time one of these
queries comes up, I will be sure to do the explain without analyze.

FYI that update query I mentioned in the initial thread just finished
after updating 8.3 million rows.

-Dan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2005-07-13 20:39:48 Re: cost-based vacuum
Previous Message Alvaro Herrera 2005-07-13 20:18:17 Re: Quad Opteron stuck in the mud