Explain Analyze - Total runtime very differentes

From: tarcizioab(at)c3sl(dot)ufpr(dot)br
To: pgsql-performance(at)postgresql(dot)org
Subject: Explain Analyze - Total runtime very differentes
Date: 2008-10-18 19:14:09
Message-ID: 50397.200.140.234.93.1224357249.squirrel@webmail.inf.ufpr.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello friends ...

I'm evaluating the performance of algorithms for optimization of queries.
I am comparing results between the algorithm of Dynamic Programming and an
implementation of Kruskal's algorithm. When submitting a query that makes
reference to only 2 tables of my base, logically the same "Query Plan" is
shown. But the "Total runtime" displayed by the command "Explain-Analyze"
presents a variation of time very high:

Dynamic Programming Total runtime: 1204.220 ms

Kruskal Total runtime: 3744.879 ms

No change of data (insert, delete, update) in the tables was made during
the tests. The same query was submitted several times (with Kruskal and
Dynamic Programming algorithms) and the variation of results persists.

The "explain analyze" only reports the time to run *execute* the query.
With the same "Query Plan", does not understand why this variation occurs.

In annex the Query Plans

If someone can help me.

Thank's for attention.

Tarcizio Bini

Attachment Content-Type Size
QueryPlans.txt text/plain 2.6 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-10-19 05:52:28 Re: Postgres Performance on CPU limited Platforms
Previous Message Віталій Тимчишин 2008-10-18 07:00:19 Re: Index bloat, reindex weekly, suggestions etc?