From: Dave Dutcher <dave@tridecap.com>
To: 'Piñeiro' <apinheiro@igalia.com>
Cc: 'PSQL-Performance' <pgsql-performance@postgresql.org>
Subject: Re: [Fwd: Re: Performance problem with Sarge compared
Date: Tue, 12 Sep 2006 14:05:35 -0500
Message-ID: <006301c6d69e$6d942500$8300a8c0@tridecap.com> (raw)
In-Reply-To: <1158085711.4349.24.camel@codfix.local.igalia.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dave@tridecap.com, apinheiro@igalia.com
Subject: Re: [Fwd: Re: Performance problem with Sarge compared
In-Reply-To: <006301c6d69e$6d942500$8300a8c0@tridecap.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox