Re: Performance problem with query

On 7/14/06, Christian Rengstl
<Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> wrote:
> Hi,
>
> somehow my reply yesterday got lost, but nevertheless here comes the
> explain analyze again. It's the explain of the operation that causes
> this huge performance discrepancy. Unfortunately i had to perform the
> explain analyze with an empty temp_table, because after the whole
> operation is done, i delete the data again to save some space.

that's not much help. remember that explain analyze actually performs
your query. so next time you run it, do explain analyze and post
results here. just quick tip: run analyze before you run your big
query.

merlin