Re: [Fwd: Re: Performance problem with Sarge compared - Mailing list pgsql-performance

From Dave Dutcher
Subject Re: [Fwd: Re: Performance problem with Sarge compared
Date
Msg-id 006301c6d69e$6d942500$8300a8c0@tridecap.com
Whole thread Raw
In response to Re: [Fwd: Re: Performance problem with Sarge compared  (Piñeiro <apinheiro@igalia.com>)
List pgsql-performance

> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Piñeiro
> > TIP 6: explain analyze is your friend
> Well, yes, it is a friend, but as the select at postgre Sarge version
> never finished I can't use a explain analyze. I show you the explain,
> with the hope that someone has any idea, but i think that
> this is almost
> indecipherable (if you want the Woody ones i can post the explain
> analyze). Thanks in advance.

Does the machine run out of disk space every time?  Is it possible to try
the query on a different machine with more hard drive room?  An explain
analyze of the slow plan will be much more helpful than an explain, even if
its from a different machine.  If its generating a large temp file, it is
another sign that the query is doing some kind of large cross product.


pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: tsearch2 question (was: Poor performance on seq
Next
From: Alvaro Herrera
Date:
Subject: Re: [Fwd: Re: Performance problem with Sarge compared