From: Russell Smith <mr-russ@pws.com.au>
To: Hugo Ferreira <bytter@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help trying to tune query that executes 40x slower than in SqlServer
Date: Thu, 10 Mar 2005 09:08:32 +1100
Message-ID: <200503100908.32467.mr-russ@pws.com.au> (raw)
In-Reply-To: <4e8efcf5050309040836b06cc5@mail.gmail.com>
References: <20050304002724.650A95AF649@svr4.postgresql.org>
<3276.1110218527@sss.pgh.pa.us>
<4e8efcf5050309040836b06cc5@mail.gmail.com>
On Wed, 9 Mar 2005 11:08 pm, Hugo Ferreira wrote:
> For example... I run the query, it takes 122seconds. Then I delete the
> target tables, vacuum the database, re-run it again: 9s. But if I run
> vacuum several times, and then run, it takes again 122seconds. If I
> stop this 122seconds query, say, at second 3 and then run it again, it
> will only take 9s. It simply doesn't make sense. Also, explain analyse
> will give me diferent plans each time I run it... Unfortunately, this
> is rendering PostgreSQL unusable for our goals. Any ideas?
>
The explain analyze is still be best information if you want assistance with
what postgresql is doing, and how to stop it. If you could attach
explain analyzes for both the fast (9s), and slow (122s) runs, that would
help people get an idea of how the query is running. At the moment
we don't know how postgresql is actually executing the query.
Regards
Russell Smith.
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: mr-russ@pws.com.au, bytter@gmail.com
Subject: Re: Help trying to tune query that executes 40x slower than in SqlServer
In-Reply-To: <200503100908.32467.mr-russ@pws.com.au>
* 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