Re: Performance PG 8.0 on dual opteron / 4GB / 3ware

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: Pgsql-Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Date: 2005-11-06 20:26:13
Message-ID: 2503.1131308773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes:
> Explain analyse (with PgAdmin):
> ...
> Total runtime: 5049.467 ms
> Actual execution time: 82163 MS (without getting the data)

I'm confused --- where's the 82sec figure coming from, exactly?

We've heard reports of performance issues in PgAdmin with large
result sets ... if you do the same query in psql, what happens?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joost Kraaijeveld 2005-11-07 04:25:59 Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Previous Message Luke Lonergan 2005-11-06 20:19:02 Re: 8.1 iss